Data Integration Connections > Connection properties > Greenplum connection properties
  

Greenplum connection properties

When you set up a Greenplum connection, you must configure the connection properties.
The following table describes the Greenplum connection properties:
Connection property
Description
Runtime Environment
The name of the runtime environment where you want to run the tasks.
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 database.
Schema
Name of the schema that contains the metadata for Greenplum sources or targets.
Default is public.
Certificate 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: SSL configuration is applicable only for the Greenplum writer.
Metadata Additional Connection Configuration
Additional metadata connection properties that you want to use.
Use the following format:
<parameter name1>=<value1>, <parameter name2>=<value2>
Driver Name
The driver name. Specify DataDirect 7.1 Greenplum Wire Protocol.
User Name
User name with permissions to access the Greenplum database.
Password
Password to connect to the Greenplum database.