Defining a job that includes the Cognos TM1 connector

To read data from or write data to Cognos TM1 databases that Cognos TM1 uses, you can create a job that includes the Cognos TM1 connector. 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 Cognos TM1 connector to the job:
    1. In the palette, select the Database category.
    2. Drag the Cognos TM1 Connector stage to the canvas.
    3. Optional: Rename the Cognos TM1 Connector stage.
      Choose a name that indicates the role of the stage in the job.
  4. Create the necessary links and add more stages for the job:
    • For a job that reads Cognos TM1 data, create the next stage in the job, and then create an output link from the Cognos TM1 connector to the next stage.
    • For a job that writes data to Cognos TM1 databases that Cognos TM1 uses, create an input link from the previous stage in the job to the Cognos TM1 connector.
  5. Save the job.