Search This Blog

Saturday 10 November 2018

OBIEE 12c with MySQL Community Edition Connectivity

This post brings the workaround on How to connect OBIEE 12c Environment with MySQL Server Community Edition.
This is Tested on OBIEE

Assumption :

OBIEE 12c comes with DataDirect Connections and support only for Enterprise Edition. But our requirement is to connect Community Edition as our DW is developed in there.

MySQL Community Edition ( i.e. FREE edition )
Server OS is Redhat 7 64-bit

Import tables in OBIEE Admin Tool

Download latest ODBC Driver and Install, set up DSN,  , Create connection pool, Import metadata, Define business and presentation layers.


Data Direct Drivers are shipped to connect OBIEE to MySQL.  Unfortunately these do not work as you get a message "[nQSError: 16001] ODBC error state: S1000 code: 0 message: [DataDirect][ODBC MySQL Wire Protocol driver]Connections to MySQL Community Servers are not supported.  Please contact MySQL to obtain a MySQL Enterprise or Commercial version.."


Use MySQL native ODBC instead of DataDirect ODBC.

You can get these from

This is an rpm download and install, you need root privileges to do this.  DO NOT DOWNLOAD THE ANSI driver as it does not work.  
We have to download for Redhat 64bit Server:

Update the configuration in ODBC.ini
Go to the following directory and update the ODBC.ini file like below:


Note: We can use either OBDC Driver (libmyodbc8w) or ANSI Driver(libmyodbc8a).

Driver         = /usr/lib64/
Description  = Connector/ODBC 8.0 ANSI Driver DSN
SERVER       =
PORT          = 3306
USER          = username
Password     = password
Database     = dbname
OPTION       = 3

Go to the following directory and update the file for LD_LIBRARY_PATH to point OBDC Driver.


"LD_LIBRARY_PATH" value="/usr/lib64:$ORACLE_HOME/common/ODBC/Merant/6.0SP1/lib$:$ORACLE_HOME/bifoundation/server/bin$:$ORACLE_HOME/bifoundation/web/bin$:$ORACLE_HOME/clients/epm/Essbase/EssbaseRTC/bin$:$ORACLE_HOME/bifoundation/odbc/lib$:$ORACLE_INSTANCE$:$ORACLE_HOME/lib"

Import Points to Note:
Connection Pool Name, ODBC.ini configuration in OBDC Data Sources name and MYSQL configuration name has to be same.

E.g: MySQLConnTest


What is Oracle Database Link and How to create database link (DB Link)

Recent Posts