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

user1059710

Anyone? If there some support document about this task for OBIEE 12c?