1 Reply Latest reply on Feb 22, 2016 9:58 AM by user1059710

    How to configure ODBC driver on Linux for Netezza data source?




      I have requirement to add Netezza NPS ver.7.2 as new data source in OBIEE 12c on Linux. I am trying to follow OBIEE documentation for ODBC data source on linux:


      but there is no example for Netezza data source ODBC driver configuration. I have tried to do standard Netezza driver for Linux setup:

      - added netezza data source  to /app/oracle/biee/user_projects/domains/bi/config/fmwconfig/bienv/core/odbc.ini

      - added path to netezza driver libraries to LD_LIBRARY_PATH & PATH in /app/oracle/biee/user_projects/domains/bi/config/fmwconfig/bienv/OBIS/obis.properties

      - restarted OBIEE services, but when i try to test ODBC connection with nqcmd.sh i am getting the error that driver could not be loaded:


      /app/oracle/biee/user_projects/domains/bi/bitools/bin/nqcmd.sh -d NZSQL -u etl -p etletl

      Feb 03, 2016 3:04:19 PM oracle.bi.endpointmanager.impl.bienv.BIEnvComponents loadFromInputStream

      INFO: Reading components from: /app/oracle/biee/user_projects/domains/bi/config/fmwconfig/bienv/core/bienv-components.xml ...



                Oracle BI ODBC Client

                Copyright (c) 1997-2015 Oracle Corporation, All rights reserved




      [DataDirect][ODBC lib] Specified driver could not be loaded

      Connect open failed


      Connection open failed:

      [DataDirect][ODBC lib] Specified driver could not be loaded


      Can someone help me to configure ODBC connection properly.


      Thank you in advance,