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

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

    user1059710

      Hi,

       

      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:

      https://docs.oracle.com/middleware/1221/biee/BIEMG/deploy_rpd.htm#BIEMG1177

      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,

      Ivan