This page describes the provider-specific properties of relational databases and the details you need to input to create connections to those databases. Some properties are common to these databases; you can find that information in the common properties section.
CUSTOM JDBC
Select this provider when you use a non-SQL way to access a data source.
Property | Values | Comments |
Driver Class Name | Type Yourself | Specify the driver class name for the driver |
DB2
Property | Values | Comments |
System | Type Yourself | The IP or name of the machine where the database server is running |
Port | Type Yourself
| The port at which the database server is listening |
Database | Type Yourself | Specify the name of the database to connect to using this connection |
Schema (optional) | Type Yourself | The schema to be used for a specified user for this database connection |
H2
Property | Values | Comments |
Path | Type Yourself | The path (including the file name) to the location where the database file is available |
H2 (Embedded)
Property | Values | Comments |
Path | Type Yourself | The path (including the file name) to the location where the database file is available |
H2 (Standalone)
Property | Values | Comments |
Server | Type Yourself | The IP or name of the machine where the database server is running |
Port | Type Yourself | The port at which the database server is listening |
Path | Type Yourself | The path to the folder where database files are residing |
MSSQL
Property | Values | Comments |
Driver Version | Select from the list | Select the driver version of MSSQL Database to connect to using this connection. |
Authentication Mode | Select from the list | Select Server Authentication if you want the Database server to authenticate. You must provide a database username and password. Select Windows Authentication to use the credentials used for Windows authentication. In this case, the Windows username and password used to log into the machine where the Intellicus report server is running will be used for authentication. |
Driver Type | Select from the list | Select Microsoft or JTDS based on the driver you want the System to use |
Server | Type Yourself | The IP or name of the machine where the database server is running |
Port | Type Yourself | The port at which the database server is listening |
Database | Type Yourself | Specify the name of the database to connect to using this connection |
SSL | Check/Uncheck | In case of forced encryption at the database server, you can check the SSL option to enable you to connect. |
Domain | Type Yourself | Specify the name of the network domain. (Domain is asked when you select Authentication Mode as Windows and Driver Type as JTDS) |
Instance | Type Yourself
| Specify the name of the instance with which you want to connect |
MYSQL
You must download the driver and place it in the <Intellicus_Install>ReportEnginelibMYSQL folder.
Property | Values | Comments |
Driver Version | Select from the list | Select the desired driver version for MYSQL |
Server | Type Yourself | The IP or name of the machine where the database server is running |
Port | Type Yourself | The port at which the database server is listening |
Fetch size | Type Yourself | Specify -1 to receive a one-by-one record as a stream. This is good if you have an extensive record set. Please leave it blank so we can accept the entire record simultaneously. |
SID | Type Yourself | This unique name identifies a specific database from several databases on a server. |
ODBC
Property | Values | Comments |
DSN | Type Yourself | Specify the System DSN created for the ODBC connection |
ORACLE
Property | Values | Comments |
Driver Type | Select from the list | Select one of the drivers you are using to connect to the database |
Driver Version | Select from the list | From the options, select the driver version |
Server | Type Yourself | The IP or name of the machine where the database server is running |
Port | Type Yourself
| The port at which the database server is listening |
SID | Type Yourself | This unique name identifies a specific database from several databases on a server. |
ORACLE_THIN
Property | Values | Comments |
Server | Type Yourself | The IP or name of the machine where the database server is running |
Port | Type Yourself | The port at which the database server is listening |
SID | Type Yourself | This unique name identifies a specific database from several databases on a server. |
OTHERS
Note: Before specifying driver details for OTHERS connection, you need to add respective driver using Add Driver button on Databases page.
Property | Values | Comments |
Driver Class Name | Type Yourself | The class name for the driver |
POSTGRES
Property | Values | Comments |
Server | Type Yourself | The IP or name of the machine where the database server is running |
Port | Type Yourself
| The port at which the database server is listening |
SID | Type Yourself | This unique name identifies a specific database from several databases on a server. |
Note: If you are using a database that is derived from PostgreSQL, (for example, EnterpriseDB) select POSTGRES as database provider.
SQLLITE
Property | Values | Comments |
Path | Type Yourself | Path of the database files |
SYBASE
Property | Values | Comments |
Driver Type | Select from the list | Select the driver type to be used to connect with this database |
Server | Type Yourself | The IP or name of the machine where the database server is running |
Port | Type Yourself | The port at which the database server is listening |
Database | Type Yourself | The name of the database to connect to using this connection |
SAP HANA
Property | Values | Comments |
Server | Type Yourself | The IP or name of the machine where the database server is running |
Port | Type Yourself | The port at which the database server is listening |
Database | Type Yourself | The name of the database to connect to using this connection |
Fetch size | Type Yourself | Specify 1 to receive records one by one as a stream. This is useful when you have an extensive record. Please leave it blank so we can accept the entire record simultaneously. |
Max Rows | Type Yourself | Specify the maximum number of rows to be fetched from the dataset |