Database Ingestion and Replication > Database Ingestion and Replication sources - preparation and usage > Netezza sources

Netezza sources

To use Netezza sources in database ingestion and replication tasks, first prepare the source database and review the usage considerations.

Source preparation

•Download and install the Netezza JDBC driver.

1Download the Netezza JDBC driver from the IBM website.
2Copy the Netezza JDBC driver jar file, nzjdbc.jar, to the following directory:

<Secure Agent installation directory>/apps/Database_Ingestion/ext/

3Restart the Secure Agent.

•To deploy and run a database ingestion and replication 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

•Database Ingestion and Replication does not support the following Netezza data type:

- ST_GEOMETRY

Database ingestion and replication jobs either fail to deploy or propagate nulls for columns that have this data type.

For information about the default mappings of supported source data types to target data types, see Default data-type mappings.