Table of Contents

Search

  1. Preface
  2. Connectors and connections
  3. Connection configuration
  4. Connection properties
  5. Swagger file generation for REST V2 connections

Data Integration Connections

Data Integration Connections

PostgreSQL connection properties

PostgreSQL connection properties

When you set up an PostgreSQL connection, you must configure the connection properties.
The following table describes the PostgreSQL connection properties:
Connection property
Description
Runtime Environment
The name of the runtime environment where you want to run the tasks.
Specify a Secure Agent, Hosted Agent, or serverless runtime environment.
Host Name
Host name of the PostgreSQL server to which you want to connect.
Port
Port number for the PostgreSQL server to which you want to connect.
Default is 5432.
Schema
Optional. The schema name.
If you do not specify the schema name, all the schemas available in the database are listed while importing the source object in
Data Integration
.
Database
The PostgreSQL database name.
User Name
User name to access the PostgreSQL database.
Password
Password for the PostgreSQL database user name.
Encryption Method
Determines whether the data exchanged between the Secure Agent and the PostgreSQL database server is encrypted:
Select one of the following encryption methods:
  • noEncryption. Establishes a connection without using SSL. Data is not encrypted.
  • SSL. Establishes a connection using SSL. Data is encrypted using SSL. If the PostgreSQL database server cannot configure SSL, the connection fails.
  • requestSSL. Attempts to establish a connection using SSL. If the PostgreSQL database server cannot configure SSL, the Secure Agent establishes an unencrypted connection.
Default is noEncryption.
SSL is not applicable when you use the Hosted Agent. You can configure SSL when you use the Secure Agent or the serverless runtime environment.
Validate Server Certificate
Applicable if you select SSL or requestSSL as the encryption method.
Select the Validate Server Certificate option so that the Secure Agent validates the server certificate that is sent by the PostgreSQL database server. If you specify the Host Name In Certificate property, the Secure Agent also validates the host name in the certificate.
TrustStore
Applicable if you select SSL or requestSSL as the encryption method and the Validate Server Certificate option.
The path and name of the truststore file, which contains the list of the Certificate Authorities (CAs) that the PostgreSQL client trusts.
For the serverless runtime environment, specify the following certificate path in the serverless agent directory:
data2/home/cldagnt/SystemAgent/serverless/configurations/ssl_store/<TrustStore_filename>
TrustStore Password
Applicable if you select SSL or requestSSL as the encryption method and the Validate Server Certificate option.
The password to access the truststore file that contains the SSL certificate.
Host Name In Certificate
Optional when you select SSL or requestSSL as the encryption method and the Validate Server Certificate option.
A host name for providing additional security. The Secure Agent validates the host name included in the connection with the host name in the SSL certificate.
KeyStore
Applicable if you select SSL as the encryption method and when client authentication is enabled on the PostgreSQL database server.
The path and the file name of the key store. The keystore file contains the certificates that the PostgreSQL client sends to the PostgreSQL server in response to the server's certificate request.
For the serverless runtime environment, specify the following certificate path in the serverless agent directory:
data2/home/cldagnt/SystemAgent/serverless/configurations/ssl_store/<KeyStore_filename>
KeyStore Password
Applicable if you select SSL as the encryption method and when client authentication is enabled on the PostgreSQL database server.
The password for the keystore file required for secure communication.
Key Password
Applicable if you select SSL as the encryption method and when client authentication is enabled on the PostgreSQL database server.
Required when individual keys in the keystore file have a different password than the keystore file.
Additional Connection Properties
Additional connection parameters that you want to use.
You must provide the connection parameters as semicolon-separated key-value pairs.
Crypto Protocol Versions
Required if you select SSL or requestSSL as the encryption method.
A cryptographic protocol or a list of cryptographic protocols to use with an encrypted connection.
You can select from the following protocols:
  • SSLv3
  • TLSv1
  • TLSv1_1
  • TLSv1_2