Designing jobs by using the Netezza connector

You can use the IBM® Netezza connector to develop jobs that read, write, and load data, and that store components from one job in the repository so that you can reuse them in another job.

1. Import metadata from a Netezza source.
2. Define a Netezza connector job.
3. To set up the Netezza Connector stage to read data from a Netezza table:
   1. Configure the Netezza connector as a source.
   2. Set up column definitions.
   3. Define usage properties for reading data.
   4. Optional: Define how data is partitioned.
4. To set up the Netezza Connector stage to write data into a Netezza table:
   1. Configure the Netezza connector as a target.
   2. Set up column definitions if they are not already specified for the link.
   3. Define usage properties for writing data.
   4. Optional: Define how data is partitioned.
5. Look up data by using reference links.
6. Compile and run the job.