This section provides you the details on various fields required to configure Oracle in Data Integrity Suite.
| Field | Description |
|---|---|
| Name | Specifies the name of data connection. This is a mandatory field. Example: OracleDataConnection |
| Description | Allows you to describe the purpose of this data connection. Example: Connection to the Oracle database for customer data management. |
| Agent to access data | Select an agent from the dropdown list, responsible for managing
the Oracle Server connection. Example: Agent1 Note: When setting up a shared connection for
data integration, if users have the SYSDBA or SYSOPER roles, you
must add extra URL parameters that are appropriate for the
respective roles.
|
| Host name | Specifies the hostname that can be Cloud Oracle or on-premise server. This is a mandatory field. Example: oracle-server.company.com |
| Port number | Mention the port number to access the database server. The default value is 1521. This is a mandatory field. Example: 1521 |
| Connect using | Select a connection method from the dropdown list.
|
| Additional URL parameters | Specify the additional JDBC driver connection parameters in the
key=value pairs format separated by semicolon. Example:
key1=value1;key2=value2. Allowed parameters can be referred here. Example:
oracle.net.ssl_server_dn_match=true;oracle.net.ssl_version=1.2 Note: If the user role is
SYSDBA, then add
SysLoginRole=SYSDBA;; and when the user
role is SYSOPER, then add
SysLoginRole=SYSOPER;. |
| You will see the advanced options if your worksapce is enabled with Advanced connectivity bundle. | |
|
Advanced Options |
For advanced configuration, refer Advanced connectivity bundle |