This page describes the provider specific properties for relational databases and the details you need to input to create connections to the specific databases. There are some properties that are common to these databases, you can find those information, here.
CUSTOM JDBC
Select this provider when you use non-SQL way to access from 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 database server is running |
| Port |
Type Yourself
|
The port at which database server is listening |
| Database |
Type Yourself |
Specify 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 database file is available |
H2 (Embedded)
| Property |
Values |
Comments |
| Path |
Type Yourself |
The path (including the file name) to the location where database file is available |
H2 (Standalone)
| Property |
Values |
Comments |
| Server |
Type Yourself |
The IP or name of the machine where database server is running |
| Port |
Type Yourself |
The port at which 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 should authenticate. You need to provide user name and password for the database.
Select Windows Authentication to use the credentials used for windows authentication. In this case, Windows user name and password used to log into the machine where 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 system to use |
| Server |
Type Yourself |
The IP or name of the machine where database server is running |
| Port |
Type Yourself |
The port at which database server is listening |
| Database |
Type Yourself |
Specify 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 need to download the driver and place it in <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 database server is running |
| Port |
Type Yourself |
The port at which database server is listening |
| Fetch size |
Type Yourself |
Specify -1 to receive one by one record as a stream. This is good if you have a very large recordset. Leave it blank to receive entire recordset at a time |
| SID |
Type Yourself |
This is a unique name that identifies a specific database from number of 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 options, select the driver version |
| Server |
Type Yourself |
The IP or name of the machine where database server is running |
| Port |
Type Yourself
|
The port at which database server is listening |
| SID |
Type Yourself |
This is a unique name that identifies a specific database from number of databases on a server |
ORACLE_THIN
| Property |
Values |
Comments |
| Server |
Type Yourself |
The IP or name of the machine where database server is running |
| Port |
Type Yourself |
The port at which database server is listening |
| SID |
Type Yourself |
This is a unique name that identifies a specific database from number of 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 database server is running |
| Port |
Type Yourself
|
The port at which database server is listening |
| SID |
Type Yourself |
This is a unique name that identifies a specific database from number of databases on a server |
| SSL Mode |
Select from drop down |
In case of forced encryption at the database server, you can check the SSL option to enable you to connect |
| SSL Root Certificate |
Type Yourself |
Specify the root certificate to connect to the SSL enabled database 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 database server is running |
| Port |
Type Yourself |
The port at which 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 database server is running |
| Port |
Type Yourself |
The port at which 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 a very large recordset. Leave it blank to receive entire recordset at a time |
| Max Rows |
Type Yourself |
Specify the maximum number of rows to be fetched from dataset |