•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.