Database (3.0)
- Former user (Deleted)
- Yong Chee Keong
- Yeok Hong Ng (Deactivated)
In a Database profile configuration, you can create database profiles for use in various agents and profiles. These include:
Audit Profile
- Database Agents
- Event Notifications
What a profile can be used for depends on the selected database type. The supported usage for each database type is described in the section below, Database Types.
The Database profile is loaded when you start a workflow that depends on it. Changes to the profile become effective when you restart the workflow.
The Database profile has two tabs: General and Properties.
General Tab
In the General tab, the two radio buttons Default Connection Setup and Advanced Connection Setup display different connection options.
Default Connection Setup
Select the Default Connection Setup radio button to use a preconfigured connection string.
| Setting | Description |
|---|---|
Default Connection Setup | Select this option to configure a default connection. |
Database Type | Select a database type. You may need to make 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 for the database instance. |
Database Host/Path | Enter the host name. Enter it exactly as when you access it from any other application within the network. This is applicable to all database type except the CSV File. Enter the path for CSV File. |
Port Number | Enter the database network port. |
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. |
Advanced Connection Setup
The Advanced Connection Setup enables you to specify a customized connection string. You can use this when you need to add additional properties to a connection.
| Setting | Description |
|---|---|
Advanced Connection Setup | Select to configure the data source connection using a connection string. |
Database Type | Select a database type. 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. |
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. |
Properties Tab
The Properties tab allows you to configure additional properties for certain database types.
Currently the following properties can be configured:
| Database Type | Properties |
|---|---|
| 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 |
Database Types
The following table provides information of the database versions supported.
| Database | Version |
|---|---|
| CSV | N/A |
| Derby | 10 |
| MySQL | 8 |
| Oracle | 12cR2/19c |
| PostgreSQL | 12/13/14/15 |
| SAP HANA | 2.0 (Please refer to SAP docs on latest supported SPS versions) |
| SQL Server | 2008, 2008R2, 2012, 2014, 2016, Azure SQL Database, Azure SQL Data Warehouse/Parallel Data Warehouse |
| Sybase IQ | Version of Sybase IQ supported through the use of the JCONN4 driver |
This section includes the following subsections: