Introduction to Netezza Connector

Netezza is a data warehousing appliance that organizations use to store large volumes of data. Netezza provides high-performance analytics and fast querying capabilities.

Netezza Connector uses the Netezza ODBC driver to connect to the Netezza database. The Secure Agent reads and writes Netezza data through a Netezza external table. An external table definition is stored within the Netezza database but the data is saved externally in a location that is accessible to the Netezza host or the client system.

To read data from a Netezza database, the Secure Agent creates an external table and named pipe in the pipe directory path that you specify for data extraction. It then reads the data from the named pipe.

To write data to a Netezza database, the Secure Agent creates an external table in the pipe directory path that you specify for data loading. It writes the data first to the external table and then to a staging table. The Secure Agent then writes the data from the staging table to the Netezza target.

Your organization is a retail chain with sales outlets across multiple countries. You store the historical sales information in a Netezza database. You can use Netezza Connector to read sales information from the Netezza database and use it for business analysis and decision making.