Database (4.3)

Owned by Jenni Wallin
Last updated: Dec 12, 2024 by Yuri Au Yong
3 min read

In a Database profile configuration, you can create database profiles for use in various agents and profiles including:

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

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 CSV File path.

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

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

Database Type

Properties

Oracle

oracle.pool.connectionwaittimeout
oracle.pool.maxlimit
oracle.net.encryption_client
oracle.net.encryption_types_client
oracle.net.crypto_checksum_client
oracle.net.crypto_checksum_types_client

PostgreSQL

postgresql.connectionpool.maxlimit

escapeSyntaxCallMode

Note!

Since PostgreSQL 11, there is support for stored PROCEDURE, prior versions of PostgreSQL support only the stored FUNCTION. Hence, a new connection property called escapeSyntaxCallMode has been introduced by PostgreSQL for users to configure.

This property specifies how the driver transforms JDBC escape call syntax into underlying SQL, for invoking procedures or functions.

  • In escapeSyntaxCallMode=select (the PostgreSQL default) mode, the driver always uses a SELECT statement (allowing function invocation only).

  • In escapeSyntaxCallMode=callIfNoReturn  mode, the driver uses a CALL statement (allowing procedure invocation) if there is no return parameter specified. Otherwise, the driver uses a SELECT statement.

  • In escapeSyntaxCallMode=call mode, the driver always uses a CALL statement (allowing procedure invocation only)

In case you are using Callable Statements with PostgreSQL, you can configure the escapeSyntaxCallMode connection property in the Database Profile. However, if this property is not configured in the Database Profile, it will be using the default escapeSyntaxCallMode=select.

If you're utilizing Callable Statements with PostgreSQL, you have the option to set the escapeSyntaxCallMode property either within the Connection String parameters or within the Properties tab of the Database Profile. Should you choose to configure this property in both locations, priority will be given to the setting within the Connection String.

SAP HANA

sapdb.connectionpool.maxlimit

Database Types

The following table provides information of the database versions supported.

Database

Version

Database

Version

CSV

N/A

Derby

10

MySQL

8

Oracle

12cR2/19c

PostgreSQL

12/13/14/15/16

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: