Integration Cloud 7.0.0 | Applications | Predefined Applications | Database
 
Database
 
Database Application Operations
JDBC Data Type to Java Data Type Mappings
Driver Management
Samples Accounts
Supported Cloud Databases
How to use the Insert and Select operations using the Database Application
Integration Cloud allows you to connect to a database using the Database Application. The Database Application allows you to perform database operations with cloud databases using a JDBC driver.
Complete the following fields to create a new account:
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.
The <current catalog> represents the default catalog associated with an account.
The <current schema> represents the default schema associated with an account.
PostgreSQL Database
When you configure an operation to select a table, you must always select the table under <current catalog>.
MariaDB
If you configure an operation for MariaDB using the driver versions greater than or equal to 2.4.0, select the table under <current catalog>.