External References

Select this menu item to Enable External References in an agent profile field. Refer to Enabling External References in an Agent Profile Field in External Reference Profile for further information.

Default Connection Setup

Select this option to configure a default connection.

Advanced Connection Setup

Select this option to configure the data source connection using a connection string. For further information, see the section below, Advanced Connection Setup.

Database Type

Select any of the available database types. You may need to perform some preparations before attempting to connect to the database for the first time. For information about required preparations, see the section below, Database Types.

Database Name

Enter a name that identifies the database instance. For example, when you configure the profile for an Oracle database, this field should contain the SID.

Database Host

Enter the hostname or IP address of the host on which the database is running. Type it exactly as when accessing it from any other application within the network.

Port Number

Enter the database network port.

Username

Enter the database user name.

Password

Enter the database password.

Enable TLS Truststore

Enable TLS/SSL for connection to an SAP HANA Database. This option will be enabled by default. This option applies only to SAP HANA and will only be visible when SAP HANA is selected as the Database Type. For information about advanced connection for SAP HANA with TLS/SSL enabled, you can refer to SAP HANA DB.

TLS Truststore

Enter the path and filename to the TLS/SSL trust store file that contains the SAP HANA hosting server's certificate. This option applies only for SAP HANA and will only be visible when SAP HANA is selected as the Database Type. 

TLS Truststore Password

Enter the password for the TLS/SSL trust store file. This option applies only to SAP HANA and will only be visible when SAP HANA is selected as the Database Type. 

Try Connection

Click to try the connection to the database, using the configured values.

Default Connection Setup

Select to configure a default connection. For further information, see the section above, Default Connection Setup.

Advanced Connection Setup

Select to configure the data source connection using a connection string.

Database Type

Select any of the available database types. You may need to perform some preparations before attempting to connect to the database for the first time. For information about required preparations, see the section below, Database Types.

Connection String

Enter a connection string containing information about the database and the means of connecting to it.

Notification Service

This field is used when the selected Database Type is Oracle. For more information, see Oracle.

Username

Enter the database user name.

Password

Enter the database password.

Try Connection

Click to try the connection to the database, using the configured values.

CSV

All properties described on the page http://csvjdbc.sourceforge.net/doc.html in the section section "Driver Properties" can be used.

MySQL

mysql.connectionpool.maxlimit

Oracle

oracle.pool.connectionwaittimeout
oracle.pool.inactivitytimeout
oracle.pool.maxlimit
oracle.pool.minlimit
oracle.pool.propertycheckinterval
oracle.pool.refreshonsqlerror
oracle.net.encryption_client
oracle.net.encryption_types_client
oracle.net.crypto_checksum_client
oracle.net.crypto_checksum_types_client

PostgreSQL

postgresql.connectionpool.maxlimit

SAP HANA

sapdb.connectionpool.maxlimit

Cassandra

3.11.3

CSV

-

DB2

10

Derby

10

MS SQL Server

2008, 2008R2, 2012, 2014, 2016, Azure SQL Database, Azure SQL Data Warehouse/Parallel Data Warehouse

MySQL

8

Netezza

-

Oracle

12cr2/19c

PostgreSQL

9.6/10/11

Redshift

-

SAP Hana

-

Snowflake

-

Sybase IQ

The version of Sybase IQ support through the use of the JCONN4 driver

Teradata

16.20

TimesTen

11.2

Vertica

8.1