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 |
Use Secret Vault | Stores sensitive credentials for this connection in the secrets manager that is configured for your organization. This property appears only if secrets manager is set up for your organization. This property is not supported by Data Ingestion and Replication. When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured. For information about how to configure and use a secrets manager, see Secrets manager configuration. |
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>
|