Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Configuring ODBC connection to MariaDB Database

Question
112
Views
0
Comments
Rank 3 - Community Apprentice

Hi all,

I'm trying to set up a connection to a MariaDB Database so I can use the database in OBIEE. I've been able to import the metadata and build a Presentation Area in the RPD with Windows, but now I'm trying to configure the Data Source in the server and it's not working for me, when I try to test connection using nqcmd.sh, I get always the error [DataDirect][ODBC lib] Specified driver could not be loaded.

Has someone installed this driver (or the one for mysql open source database) and can point me out what I'm doing wrong or which log could I look to get more information?

OBIEE Version: 12.2.1.2.0

Server: Oracle Linux 7.3 x64

MariaDB version: 10.1.22

I've taken a look to the oficial Oracle Documentation, particularly al the part about using Native ODBC Drivers, as MariaDB is not supported to use Data Direct: http://docs.oracle.com/middleware/1221/biee/BIEMG/deploy_rpd.htm#BIEMG1181

Besides, I've looked at these two documents in support, that are refering to other ODBC connections, so I guess it will be a similar set up:

https://support.oracle.com/epmos/faces/DocumentDisplay?&id=2114441.1

https://support.oracle.com/epmos/faces/DocumentDisplay?&id=2126396.1

So these are the steps I've followed:

1) I have downloaded the MariaDB ODBC driver (version 3.0.0) there are different versions of the driver for linux, I've chosen the one corresponding to CentOS7, and installed it in the OBIEE server, I've just unzipped it in a specific location, I get the /usr/local/mariadb-odbc/lib64/libmaodbc.so library.

2) I've modified the $DOMAIN_HOME/config/fmwconfig/bienv/obis/obis.properties, adding the driver path to the beginning of the LD_LIBRARY_PATH variable:

LD_LIBRARY_PATH=/usr/local/mariadb-odbc/lib64:...

3) This part is not clear in the documentation, and I've tried various settings. The documentation mentions in step 4 to add the driver path to the PATH variable in obis.properties file. Now, this variable doesn't exist in the file above, but one of the aditional documents I've linked mentions the file $ORACLE_HOME/bi/modules/oracle.bi.cam.obis/env/obis.properties. This file has both the PATH and the LD_LIBRARY_PATH variables, so I've tried various configurations, initially without setting it, and then adding the driver path to the PATH variable, the LD_LIBRARY_PATH variable or both.

4) I've modified odbc.ini file in $DOMAIN_HOME/config/fmwconfig/bienv/core, adding in the [ODBC Data Sources] part the line:

MY_MARIADB_DATABASE=libmaodbc.so

, and at the end of the file, the following:

[MY_MARIADB_DATABASE]HostName=myhostPortNumber=myportDriver=/usr/local/mariadb-odbc/lib64/libmaodbc.soDescription=DataDirect 3.0.0 MariaDB Wire ProtocolLogonID=myuserPassword=mypasswordDatabase=MY_MARIADB_DATABASE

5) This part isn't mentioned in the oficial documentation, so initially I haven't modified it, and then I have tried modifying it (without luck, always the same error). Modify the file odbcinst.ini in $DOMAIN_HOME/config/fmwconfig/bienv/core, doing the same modification as to odbc.ini.

6) Restart OBIEE

7) Test the ODBC connection with ./$DOMAIN_HOME/bitools/bin/nqcmd.sh -d MY_MARIADB_DATABASE -u myuser -p mypassword

I've tried different combinations of steps 3 and 5 files, without luck, I always get the error:

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

Connect open failed

I've even added the file dbfeatures.ini in $DOMAIN_HOME/config/fmwconfig/biconfig/OBIS taken from the 2126396.1 document, although I don't think it's necessary, just to test.

I've checked the logs in $DOMAIN_HOME/servers/obis1/logs, but nothing is written related to this connection, the last modification date corresponds to the server start. Is there another log I should be checking?

Regards

Welcome!

It looks like you're new here. Sign in or register to get started.