webMethods Integration Cloud and Cloud Deployment Documentation 5.6.0 | webMethods Integration Cloud | Applications, Accounts, Operations, Listeners, Upgrade, Keys and Certificates | Applications | Predefined Applications | Database
 
Database
 
Database Application Operations
JDBC Data Type to Java Data Type Mappings
Driver Management
Samples Accounts
Supported Cloud Databases
Integration Cloud allows you to connect to database using Database Application. The Database Application allows you to perform database operations with cloud databases through the use of a JDBC driver.
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. You can upload only the certified jars.
Transaction Type
Select transaction type for transaction support on Account. The following are the supported transaction types:
*NO_TRANSACTION: The connection automatically commits operations.
*LOCAL_TRANSACTION: The connection uses local transactions.
DataSource Class
Select the DataSource class from the drop-down. This field specifies the name of the JDBC driver's DataSource class.
Server Name
Enter the name of the server that hosts the database.
Note: Ensure to check the security settings of the cloud database, if the tenant is unable to connect to the cloud database.
User
Enter the user name that the connection uses to connect to the database.
Password
Enter the password for the user name specified in User.
Database Name
Enter the database name to which the connection connects to.
Port Number
Enter 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 used to determine 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 will use when connecting to the database.
Enter TCP/TCPS, which specifies the name of the network protocol.
Other Properties
Specify the driver-dependent property settings to provide additional configurations for the connection that you use.
Use the following format:
propertyName=value
Note: Use a ; (semi-colon) to delimit driver-dependent property settings. Do not enter spaces after the semi-colon.
For example: TableFilter=‘<current catalog>'.‘Accounting';driverType=thin
loginTimeout=60 Specifies the default time in seconds that a connection will wait while attempting to connect to a database.
The <current catalog> represents the default catalog associated with the Account.
The <current schema> represents the default schema associated with the Account.
PostgreSQL Database
When you configure an operation to select a table, you must always select the table under <current catalog>.
Adding or Editing Accounts
Copyright © 2014- 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.