About the Greenplum Adapter

The PutGreenplumRecord Greenplum Adapter property identifies the controller service that specifies and manages the connection to Greenplum Database. The only compatible controller service for this function is named GreenplumGPSSAdapter.

You configure a PutRecordProcessor Greenplum Adapter via the processor configuration dialog, PROPERTIES tab. You can also add a new adapter instance via the Operate Palette configuration dialog CONTROLLER SERVICES tab.

When you configure the GreenplumGPSSAdapter controller service, you identify a Greenplum Streaming Server instance host and port. You also specify Greenplum Database connection properties including master host and port, database and user names, and user password.

While all connection properties are required, the Connector utilizes default values for many.

Property Name Description Default Value
Greenplum Streaming Server Host The name or IP address of the host on which the GPSS instance is running. Required.
Greenplum Streaming Server Port The GPSS port number. Required. 5000
Greenplum Database Master Host The name or IP address of the Greenplum Database master host. Required.
Greenplum Database Master Port The Greenplum master server port number. Required. 5432
Greenplum Database Name The name of the Greenplum database. Required. postgres
Greenplum User Name The Greenplum user/role name to use to connect to the database. gpadmin
Greenplum User Password The password for the Greenplum user/role. Required.

You can re-use a Greenplum Adapter controller service for any dataflows that use the specified Greenplum Streaming Server instance to load data to the same Greenplum master host and database as the specified user.