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
Driver Class Name	Specify the driver class name for the driver

DB2

Property	Description
System	The IP or name of the machine where the database server is running
Port	The port at which the database server is listening
Database	Specify the name of the database to connect to using this connection
Schema (optional)	The schema to be used for a specified user for this database connection

H2

Property	Description
Path	The path (including the file name) to the location where the database file is available

H2 (Embedded)

Property	Description
Path	The path (including the file name) to the location where the database file is available

H2 (Standalone)

Property	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
Path	The path to the folder where database files are residing

MSSQL

Property	Description
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	The IP or name of the machine where the database server is running
Port	The port at which the database server is listening
Database	Specify the name of the database to connect to using this connection
SSL	In case of forced encryption at the database server, you can check the SSL option to enable you to connect.
Domain	Specify the name of the network domain. (Domain is asked when you select Authentication Mode as Windows and Driver Type as JTDS)
Instance	Specify the name of the instance with which you want to connect

MYSQL

You must download the driver and place it in the <Kyvos Reporting install path>\ReportEngine\lib\MYSQL folder.

Property	Description
Driver Version	Select the desired driver version for MYSQL
Server	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	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	This unique name identifies a specific database from several databases on a server.

ODBC

Property	Description
DSN	Specify the System DSN created for the ODBC connection

ORACLE

Property	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	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.

ORACLE_THIN

Property	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	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	Description
Driver Class Name	The class name for the driver

POSTGRES

Property	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	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	Description
Path	Path of the database files

SYBASE

Property	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	The port at which the database server is listening
Database	The name of the database to connect to using this connection

SAP HANA

Property	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
Database	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

Kyvos 2024.12

Relational Database Management System (RDBMS)