How To: Configure ArcGIS for Server on Linux to consume data from Netezza databases
ArcGIS for Server on Linux is capable of publishing query layers from Netezza Data Warehouse appliances as services. To do this, however, there are some unique system requirements from IBM that apply only to Linux clients.
Note: This workflow is only for ArcGIS for Server on Linux. It does not apply to ArcGIS for Server on Windows operating systems.
These steps combine both Esri and IBM help documents, and are intended to simplify the workflow for configuring ArcGIS for Server to work with Netezza.
• On this page, step 4c says to place the .odbc.ini and .odbcinst.ini into the home directory of the ArcGIS user. It is critical to do this, as the Netezza system is programmed to look in the home directory of the user, per the following IBM the documentation: ODBC driver search behavior and ODBC driver considerations
Warning: When registering, it is critical that the Data Source Name (DSN) is identical across all client connections. This includes the .odbc.ini file on the ArcGIS for Server Linux machine and any connections made in Windows ODBC driver manager that are used by ArcGIS for Desktop.