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 | Greenplum |
Runtime Environment | The name of the runtime environment where you want to run tasks. You can specify a Secure Agent, Hosted Agent, or serverless runtime environment. |
Host Name | Host name or IP address of the Greenplum server. |
Port | Greenplum server port number. If you enter 0, the gpload utility reads from the environment variable $PGPORT. Default is 5432. |
Database | Name of the Greenplum database. |
Schema | Name of the schema that contains the metadata for Greenplum sources or targets. Default is public. |
Property | Description |
|---|---|
Username | User name with permissions to access the Greenplum database. |
Password | Password to connect to the Greenplum database. |
Property | Description |
|---|---|
Certificates Path | Path where the SSL certificates for the Greenplum server are stored. Specify the path if you want to establish secure communication between the gpload utility and the Greenplum server over SSL. For information about the files that need to be available in the certificates path, see the gpload documentation. Note: You can use the SSL-based connection only in a Target transformation in a mapping to write to Greenplum. |
Metadata Additional Connection Configuration | Additional connection properties that you want to set to fetch the metadata from Greenplum. Enter the properties in the following format: <parameter name1>=<value1>, <parameter name2>=<value2> |
Driver Name | The driver name. Specify DataDirect 7.1 Greenplum Wire Protocol. |
Property | Description |
|---|---|
Host Name | Host name or IP address of the Greenplum server. |
Port | Greenplum server port number. If you enter 0, the gpload utility reads from the environment variable $PGPORT. Default is 5432. |
Database | Name of the Greenplum database. |
Property | Description |
|---|---|
Kerberos Connection Properties | Additional connection properties to use Kerberos authentication to connect to the Greenplum database. Enter properties in the following format: <parameter name>=<parameter value> If you specify more than one property, separate each key-value pair with a semicolon. |
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>
|