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

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.

To configure Kerberos authentication, you need the service principle name, host name, port, and database name from your PostgreSQL account.

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

Property	Description
Service Principal Name	Service principal name that you want to use for Kerberos authentication. Specify the service principal name in the following format: <Service_Name>/<Fully_Qualified_Domain_Name>@<REALM.COM> - Service_Name is the name of the service hosting the instance. - Fully_Qualified_Domain_Name is the fully qualified domain name of the host machine. - REALM.COM is the domain name of the host machine. This value is optional. If you do not specify the realm name, the default realm is used.
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.

The following table describes the advanced connection property for Kerberos authentication:

Property	Description
Additional Kerberos Properties	Additional connection properties to use Kerberos authentication to connect to PostgreSQL. Enter properties in the following format: <parameter name>=<parameter value> If you enter more than one property, separate each key-value pair with a semicolon.

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.
Additional Connection Properties	Additional connection parameters that you want to use. Provide the connection parameters as semicolon-separated key-value pairs.

Encryption types

The following table describes the advanced connection properties for 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.
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.

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.

Connection details