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. |
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. |
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>
|
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. |
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. |
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. |
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. |
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. |