ODBC Setup

Netezza readers and writers connect to Netezza databases via ODBC. Therefore, Netezza’s ODBC driver needs to be installed. Ensure that the driver version is compatible with the NPS version you are connecting to.

Once the ODBC driver is installed, Data Source Names (DSNs) can be configured from the ODBC Control Panel located under Administrative Tools. If you are running 32-bit FME on 64-bit Windows, you will need to run a different version of the control panel located here.

C:\Windows\SysWOW64\odbcad32.exe

IMPORTANT When configuring DSNs, ensure that the Optimize for ASCII character set setting is checked. Otherwise, geometry data can be corrupted. If your data contains non-ASCII strings, then consider using nchar/nvarchar field types to store them.