Defining a job that includes a Greenplum Connector stage

Before you can read, write, or look up data from a Greenplum data source, you must create a job that includes a Greenplum Connector stage. Then, you add any additional stages that are required and create the necessary links.

Procedure

  1. In the InfoSphere® DataStage® and QualityStage® Designer client, select File > New from the menu.
  2. In the New window, select the Parallel Job icon, and then click OK.
  3. Add the Greenplum Connector stage to the job:
    1. In the palette, select the Database category.
    2. From the list of available stage types, drag the Greenplum Connector stage to the canvas.
    3. Optional: Rename the Greenplum Connector stage.
      Choose a name that indicates the role of the stage in the job.
  4. Create the necessary links and additional stages for the job:
    • For a job the reads data from a Greenplum database, create the next stage in the job, and then create an output link from the Greenplum Connector stage to the next stage.
    • For a job that writes data to a Greenplum database, create one or more links from other stages in the job to the Greenplum Connector stage.
    • For a job that looks up Greenplum data source, add a Lookup stage to the job design canvas, and then create a reference link from the Greenplum Connector stage to the Lookup stage.
  5. Save the job.