#IBM NETEZZA ODBC SETUP HOW TO CONFIGURE ODBC#
#IBM NETEZZA ODBC SETUP DRIVER IS INSTALLED#

Ibm Netezza Odbc Setup How To Configure ODBC

To use ODBC, you must install an IBM Netezza ODBC driver, configure the driver and data sources, and test for connectivity to Netezza appliance data sources, as described in this section. The generation of an efficient INSERT FROM. The following steps show how to configure ODBC driver for Netezza.The major disadvantage of DB2 ODBC drivers compared to SDAP is that they are slightly more difficult to install. Data Sources (ODBCODBC driver for Netezza is not a MicroStrategy-branded driver. From the Microsoft Windows Control Panel, click Administrative Tools.

Ibm Netezza Odbc Setup Driver Is Installed

An example of this is as follows:If the original path is: Driver = //lib64/libnzodbc.soThen the modified path will be: Driver = /usr/odbc/ netezzahome /lib64/libnzodbc.so 4Open the odbc.ini.example file and search for the section that starts with. To modify the odbcinst.ini file 2In a Linux console window, browse to HOME_PATH, where HOME_PATH is the directory you specified as the home directory during installation.Edit the odbcinst.ini file and replace all instances of with the location of the directory where the Netezza ODBC Driver is installed. For information on installation, refer to the product documentation provided directly by the database vendor.The directory where Netezza is installed should always be accessible to MicroStrategy Intelligence Server. To configure ODBC driver for Netezza 1Install the ODBC Driver for Netezza for the correct operating system.

This can often be found along with the driver installation.For details on these DSN parameters, refer to the product documentation provided by the database vendor. For information on the available parameters, refer to your third-party Netezza driver documentation. Change the database, server name, user name, and password, and any other relevant parameters to match the information for your database. You should paste the contents of the DSN exactly as they appear in the example file.Make the following changes to the copied sample file:Modify the driver location to match the location of the installed Netezza ODBC Driver.

Ibm Netezza Odbc Driver Setup