Field | Description |
Database | Select the supported database. |
Driver Group | Select the driver group to connect to the database. You can upload a new JDBC driver through the Add Driver option from the drop-down list box. You can upload only certified jars. |
Transaction Type | Select the transaction type for transaction support for the account. The following are the supported transaction types:  NO_TRANSACTION: The connection automatically commits operations.LOCAL_TRANSACTION: The connection uses local transactions. With this transaction type, all of the operations on the same account in a single transaction boundary are either committed or rolled back together. |
DataSource Class | Select the DataSource class. This field specifies the name of the JDBC driver's DataSource class. |
Server Name | Type the name of the server that hosts the database. Note: If the tenant cannot connect to the cloud database, then check the security settings of the cloud database. |
User | Type the user name that the connection uses to connect to the database. |
Password | Type the password for the user name specified in User. |
Database Name | Type the database name to which the connection connects to. |
Port Number | Type the port number that the connection uses to connect to the database. |
Truststore Alias | Select the alias name of the Integration Cloud truststore configuration. The truststore contains trusted certificates that are used to determine the trust for the remote server peer certificates. You can also add a new Truststore from this field. |
Network Protocol | Indicates the name of the network protocol that the connection uses when connecting to the database. Type TCP or TCPS to indicate the network protocol. |
Other Properties | Select or type the property name. Also, enter the value for the corresponding property in the input text field. Note: Properties listed for you to select from the drop-down list box are driver-dependent. Example: Use this field to choose a property such as TableFilter. You can either select or type the TableFilter property in the drop-down list box and enter the ‘<current catalog>'.‘Accounting' in the input text field. Use {} to configure a combination of multiple key-value pairs. Example, connectionProperties={oracle.jdbc.V8Compatible=true, includeSynonymns=true } By default, the loginTimeout is set to 60. This value specifies the login timeout in seconds that a connection waits while attempting to connect to a database. |