Connect to PostgreSQL

Property	Description
Connection Name	Name of the connection. Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -, Maximum length is 255 characters.
Description	Description of the connection. Maximum length is 4000 characters.
Type	PostgreSQL
Runtime Environment	The name of the runtime environment where you want to run tasks. Select the Informatica Cloud Hosted Agent.

Authentication types

Database authentication

To configure database authentication, you need the user name, password, host name, port, and database name from your PostgreSQL account.

The following table describes the basic connection properties for database authentication:

Property	Description
User Name	User name to access the PostgreSQL database.
Password	Password for the PostgreSQL database user name.
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.
Database Name	The PostgreSQL database name.

Kerberos authentication

Kerberos authentication does not apply to a Data Loader task.

Advanced settings

Property	Description
Schema Name	The schema name. If you don't specify the schema name, all the schemas available in the database are listed when you import the source object in the data loader task.
Connection Environment SQL	The SQL statement to set up the database environment when you connect to the database. The database environment applies for the entire session that uses this connection. For example, you can enter this statement to set the time zone: SET timezone to 'America/New_York';
Additional Connection Properties	Additional connection parameters that you want to use. Provide the connection parameters as semicolon-separated key-value pairs.

Encryption types

SSL

When you use the SSL encryption method, data is encrypted using SSL. If the PostgreSQL database server can't configure SSL, the connection fails.

The following table describes the advanced connection properties for SSL encryption:

Note: You need to select the Validate Server Certificate check box for some SSL properties, while others need client authentication enabled on the PostgreSQL server.

Property	Description
Validate Server Certificate	Doesn't apply to a data loader task.
Truststore	Doesn't apply to a data loader task.
Truststore Password	Doesn't apply to a data loader task.
Host Name In Certificate	Doesn't apply to a data loader task.
Keystore	Doesn't apply to a data loader task.
Keystore Password	Doesn't apply to a data loader task.
Key Password	Doesn't apply to a data loader task.
Use SSLv3	Doesn't apply to a data loader task.
Use TLSv1.2	Doesn't apply to a data loader task.

Request SSL

When you use the requestSSL encryption method, PostgreSQL attempts to establish a connection using SSL. If the PostgreSQL database server can't configure SSL, the Secure Agent establishes an unencrypted connection.

The following table describes the advanced connection properties for Request SSL encryption:

Property	Description
Validate Server Certificate	Doesn't apply to a data loader task.
Truststore	Doesn't apply to a data loader task.
Truststore Password	Doesn't apply to a data loader task.
Host Name In Certificate	Doesn't apply to a data loader task.
Use SSLv3	Doesn't apply to a data loader task.
Use TLSv1.2	Doesn't apply to a data loader task.