Defining a Netezza connector job
Use the InfoSphere® DataStage® and QualityStage® Designer client to define a job by using the Netezza connector.
Procedure
- From the Designer client, select File > New from the menu.
- In the New window, select the Parallel Job or Server Job icon, and click OK.
- On the left side of the Designer client in the Palette menu, select the Database category.
- Locate Netezza Connector in the list of available databases, and click the down arrow to view the available stages.
- Drag the Netezza Connector stage icon to the job design canvas.
- Enter or modify the following attributes:
- Name of the Netezza Connector stage or link: Modify the default name of the connector or the link. You can enter up to 255 characters. Alternatively, you can modify the name of the stage or link in the job design canvas.
- Description: Enter an optional description of the stage or link.
- Click Save.
What to do next
Define properties to use Netezza connector as a source.
- Reading data
To read data from a Netezza table by using the Netezza connector, you need to configure the Netezza connector to process data as a source. The Netezza connector runs an SQL statement and returns the results as a set of zero or more rows. As a source, the connector extracts or reads data from an external Netezza data source. - Writing data
To write data to a Netezza table by using the Netezza connector, you configure the Netezza connector to process data as a target. The Netezza connector runs an SQL statement and connects to the external Netezza data source and inserts, updates, or deletes data as required. - Looking up data by using reference links
You can use the IBM Netezza connector to look up data directly from a Netezza table by using a reference link to link the Netezza Connector stage to a Lookup stage. The Lookup stage is a processing stage. It is used to perform lookup operations on a data set read into memory from any other Parallel job stage that can output data. You can specify a condition on each of the reference links, such that the stage will only perform a lookup on that reference link if the condition is satisfied. - Generating SQL statements in the connector at design time
You can configure the connector to generate SQL statements at design time in their statement properties. - Validating SQL statements in the connector at design time
After you generate or write a SQL statement, you can validate the statement during job design. - Data type conversions
IBM InfoSphere DataStage supports a set of SQL data types that are different from Netezza SQL data types. - Compiling and running Netezza connector jobs
You compile Netezza connector jobs into executable scripts that you can schedule and run. - InfoSphere DataStage Netezza jobs and NZCC_TT* tables
Why do some IBM InfoSphere DataStage Netezza® jobs create NZCC_TT* tables?
Parent topic: Designing jobs by using the Netezza connector
Related tasks: