Versions Compared

Old Version 13

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Chee Hove Teng

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Item

Description

External References

Select this menu item to Enable External References in an agent profile field. Refer to Enabling External References in an Agent Profile Field in 8.12 11 External Reference Profile for further information.

...

SettingDescription

Default Connection Setup

Select this option to configure a default connection.

Advanced Connection Setup

Select this option to configure the data source connection using a connection string. For further information, see the section below, Advanced Connection Setup.

Database Type

Select any of the available database types. 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.

Database Name

Enter a name that identifies the database instance. For example, when you configure the profile for an Oracle database, this field should contain the SID.

Database Host

Enter the host name or IP address of the host on which the database is running. Type it exactly as when accessing it from any other application within the network.

Port Number

Enter the database network port.

Username

Enter the database user name.

Password

Enter the database password.

Enable TLS Truststore

Enable TLS/SSL for connection to a SAP HANA Database. This option will be enabled by default. This option applies only for SAP HANA and will only be visible when SAP HANA is selected as the Database Type. For information about advanced connection for SAP HANA with TLS/SSL enabled, you an refer to 8.6.10 9 SAP HANA.

Note
titleNote!

If the TLS Truststore is configured for SAP HANA default connection setup, the following SAP HANA JDBC connection string properties will be added as well:

  • encrypt=true
  • hostNameInCertificate=*

For information about SAP HANA  connection string properties, you can refer to the SAP HANA documentation at the SAP Help Portal.


TLS TruststoreEnter the path and filename to the TLS/SSL trust store file that contains the SAP HANA hosting server's certificate. This option applies only for SAP HANA and will only be visible when SAP HANA is selected as the Database Type. 
TLS Truststore PasswordEnter the password for the TLS/SSL trust store file. This option applies only for SAP HANA and will only be visible when SAP HANA is selected as the Database Type. 

Try Connection

Click to try the connection to the database, using the configured values.

...

SettingDescription

Default Connection Setup

Select to configure a default connection. For further information, see the section above, Default Connection Setup.

Advanced Connection Setup

Select to configure the data source connection using a connection string.

Database Type

Select any of the available database types. 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.

Notification Service

This field is used when the selected Database Type is Oracle. For more information, see 8.6.7 6 Oracle.

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.

...

Database TypeProperties
CSVAll properties described on the page http://csvjdbc.sourceforge.net/doc.html in the section section "Driver Properties" can be used.
MySQLmysql.connectionpool.maxlimit
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
PostgreSQL

postgresql.connectionpool.maxlimit
escapeSyntaxCallMode

Note
titleNote!

From PostgreSQL 11 onwards, there is support for stored PROCEDURE, prior versions of PostgreSQL supports 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 HANAsapdb.connectionpool.maxlimit

...

DatabaseVersion
Cassandra3.11.3
CSV-
DB210
Derby

10

MS SQL Server

2008, 2008R2, 2012, 2014, 2016, Azure SQL Database, Azure SQL Data Warehouse/Parallel Data Warehouse

MySQL

5.x

8.x (only for PCC storage)

Netezza-
Oracle11.2/12.1/12.2
PostgreSQL9.6/10/11
Redshift-
SAP Hana-
Snowflake-
Sybase IQVersion of Sybase IQ support through the use of the JCONN4 driver
Teradata16.20
TimesTen

11.2

Vertica8.1


Scroll ignore
scroll-viewportfalse
scroll-pdftrue
scroll-officefalse
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmlfalse

This section includes the following subsections: