Source preparation

Download and install the Netezza JDBC driver.
Download the Netezza JDBC driver from the IBM website.
Copy the Netezza JDBC driver jar file, nzjdbc.jar, to the following directory:
<Secure Agent installation directory>/apps/Database_Ingestion/ext/
Restart the Secure Agent.
To deploy and run a database ingestion task that includes a Netezza source, the source connection must specify a database user who has the privileges that are required to perform an initial load operation. Configure SELECT permissions for the Netezza user account on the following system views:
_V_JDBC_SCHEMA1
_V_JDBC_SCHEMA3
_V_ODBC_TABLES3
_V_ODBC_COLUMNS3
_V_ODBC_PRIMARYKEYS3

Usage considerations

Mass Ingestion Databases
does not support the following Netezza data type:
ST_GEOMETRY
Database ingestion
jobs either fail to deploy or propagate nulls for columns that have this data type.
For information about the default mappings of supported data types, see the Data Type Mappings Reference.