OBIEE 12c Data Direct ODBC Drivers

Mike I.

After looking through the documentation and the forums, I couldn't find the new location for defining which version of Data Direct drivers the BI server uses so I am sharing my results here.

We were getting ODBC errors when querying a SQL Server 2014 with the 7.1.4 drivers that came with the default OBIEE 12c install. To confirm it was a driver issue, we wanted to roll back to the 7.0.1 drivers we were using in the 11g environment. Fortunately, several driver versions are bundled with the install (including 7.0.1) but only 7.1.4 is configured by default. Below are the steps I took; they are based on my own findings and you can perform them at your own risk.

Here is the location of the file I changed (after taking a backup):

<Oracle Home>/bi/modules/oracle.bi.cam.obis/env/obis.properties

Then, I looked for the variables LD_LIBRARY_PATH and LIBPATH and added the following line to the beginning of the variable assignments.

$BI_PRODUCT_HOME/common/ODBC/Merant/7.0.1/lib,

Next, I updated the odbc.ini file entry to use the 7.0.1 driver location.

Finally, I restarted the BI server component with the ./stop.sh -i obis1 and ./start.sh -i obis1 commands in bitools (<Oracle Home>/user_projects/domains/<biadmin>/bitools/bin)

The above method did resolve the errors (something related to 'with' must be preceded by a semicolon). I am interested in any feedback on experiences or alternate methods to change the ODBC drivers in OBIEE 12c.

Disclaimer: I am a long time viewer, first time poster. Criticism, questions, and comments are welcome.

--Mike I.

user11995147

Thanks so much! I had a similar issue in that the ODBC driver we were using, SEmsss23.so, wasn't working either.

Your solution of adding the lib directory to the obis.properties file was the perfect solution for us.

I just added $BI_PRODUCT_HOME/bifoundation/odbc/lib to LD_LIBRARY_PATH, restarted everything and it worked.

Thanks.