OBIEE 11g: Connectivity Issue With MYSQL DB (Doc ID 2168292.1)

Last updated on SEPTEMBER 04, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.9.5 and later
Information in this document applies to any platform.

Symptoms

On : Oracle Business Intelligence Enterprise Edition version(11.1.1.9.5 (Build 151016.1633 64-bit)

 

Using OBIEE and trying to connect to MYSQL DB.

steps followed

1.Install MySQL ODBC connection on OBIEE linux server

As Root User, run following command: yum install mysql-connector-odbc

2.Configure OBIEE ODBC.ini file.

locate odbc.ini file: /wls_domains/instances/<Instance_Name>/bifoundation/OracleBIApplication/coreapplication/setup/odbc.ini

Add required MySQL ODBC configuration:

Add - Piwik_32 = MyODBC 3.51 Driver DSN to [ODBC Data Sources] section.

Add following below:

[Piwik_32]
Driver=/usr/lib64/libmyodbc3.so
Description=PROD_Piwik
SERVER=xx.xx.xxx.xx
PORT=3306
USER=
Password=
Database=Piwik
OPTION=
SOCKET=

3. RPD Physical layer data source specified as xxxx_xx

Got below error

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 16001] ODBC error state: IM003 code: 0 message: [DataDirect][ODBC lib] Specified driver could not be loaded. (HY000)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms