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 |
Description |
Comments
Driver Class Name |
Type Yourself
Specify the driver class name for the driver |
DB2
Property |
Values
Description |
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 |
Description |
Comments
Path |
The path (including the file name) to the location where the database file is available |
H2 (Embedded)
Property |
Values
Description |
Path |
Type Yourself
The path (including the file name) to the location where the database file is available |
H2 (Standalone)
Property |
Values
Description |
Server |
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 |
Description |
Comments
Driver Version | Select |
the |
driver version of MSSQL Database to connect to using this connection. | |
Authentication Mode | 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 |
Kyvos Reporting report server is running will be used for authentication. |
Driver Type |
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 |
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 <Kyvos Reporting install path>\ReportEngine\lib\MYSQL folder.
Property |
Description |
Comments
Driver Version |
Select the desired driver version for MYSQL | |
Server |
Type Yourself
The IP or name of the machine where the database server is running |
Port |
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 |
Description |
Comments
DSN |
Specify the System DSN created for the ODBC connection |
ORACLE
Property |
Values
Description | |
Driver Type | Select |
one of the drivers you are using to connect to the database |
Driver Version |
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 |
Description |
Comments
Server |
Type Yourself
The IP or name of the machine where the database server is running |
Port |
The port at which the database server is listening | |
SID |
This unique name identifies a specific database from several databases on a server. |
OTHERS
| Panel | |||
|---|---|---|---|
|
...
| |||
Note Before specifying driver details for OTHERS connection, you need to add respective driver using Add Driver button on Databases page. |
Property |
Description |
Comments
Driver Class Name |
Type Yourself
The class name for the driver |
POSTGRES
Property |
Values
Description |
Server |
The IP or name of the machine where the database server is running | |
Port |
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. |
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note If you are using a database that is derived from PostgreSQL, (for example, EnterpriseDB) select POSTGRES as database provider. |
SQLLITE
Property |
Values
Description |
Path |
Path of the database files |
SYBASE
Property |
Values
Description | |
Driver Type | Select |
the |
driver type to be used to connect with this database |
Server |
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 |
Description |
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 |
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 |
Specify the maximum number of rows to be fetched from the dataset |