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.

The following figure shows an example of using the Netezza connector to write data. In this case, the sequential file stage reads data from the file Sequential_File_1 and then the Netezza c

onnector stage inserts, updates, or deletes data into Netezza database as required.

Figure 1. Example of writing data