Designing jobs with Greenplum Connector stages

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

  1. Define a job that includes a Greenplum Connector stage.
  2. Define a connection to a Greenplum data source.
  3. To set up the Greenplum Connector stage as a source stage to read data from the Greenplum database, complete the following steps:
    1. Configure the Greenplum Connector stage as a source.
    2. Set up column definitions on the output link.
  4. To set up the Greenplum Connector stage as a target stage to write data to the Greenplum database, complete the following steps:
    1. Configure the Greenplum Connector stage as a target.
    2. Set up column definitions on the input link.
  5. To set up the Greenplum Connector stage to look up data in a Greenplum database, complete the following step:
    1. Configure normal lookup operations or configure sparse lookup operations.
  6. Compile and run the job.