You can use Greenplum Connector stages in your jobs to
read data from Greenplum databases or write data to Greenplum databases
or look up data in the contexts of those jobs.
Procedure
- Define a job that includes a Greenplum Connector
stage.
- Define a connection to a Greenplum data source.
- To set up the Greenplum Connector stage as a source stage
to read data from the Greenplum database, complete the following steps:
- Configure the Greenplum Connector stage
as a source.
- Set up column definitions on the output link.
- To set up the Greenplum Connector stage as a target stage
to write data to the Greenplum database, complete the following steps:
- Configure the Greenplum Connector stage
as a target.
- Set up column definitions on the input link.
- To set up the Greenplum Connector stage to look up data
in a Greenplum database, complete the following step:
- Configure normal lookup operations or configure sparse lookup operations.
- Compile and run the job.