Intellicus Enterprise Reporting and Business Insights 19.1

Relational Database Management Systems (RDBMS)

0 views June 28, 2020 0

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

 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