Database (3.0)

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.

SettingDescription

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.

SettingDescription

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 TypeProperties
Oracleoracle.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
PostgreSQLpostgresql.connectionpool.maxlimit
SAP HANAsapdb.connectionpool.maxlimit

Database Types

The following table provides information of the database versions supported.

DatabaseVersion
CSVN/A
Derby10
MySQL8
Oracle12cR2/19c
PostgreSQL12/13/14/15
SAP HANA2.0 sp4
SQL Server2008, 2008R2, 2012, 2014, 2016, Azure SQL Database, Azure SQL Data Warehouse/Parallel Data Warehouse
Sybase IQVersion of Sybase IQ supported through the use of the JCONN4 driver

This section includes the following subsections: