You must configure the MySQL database to use the DataDirect driver. If you are using a database that is already configured to use the DataDirect drivers, modify the database configuration's odbc.ini file to use the correct DataDirect drivers.
To configure MySQL for Oracle BI:
- Open the odbc.ini file located at the following location:
On UNIX operating system:
$DOMAIN_HOME/config/fmwconfig/bienv/core/odbc.ini
On Windows operating system:
%DOMAIN_HOME%\config\fmwconfig\bienv\core\odbc.ini
Replace the value of DOMAIN_HOME with the actual path to the 12c Domain home you created when you installed the 12c software.
- Update the ODBC entry to use the DataDirect drivers, as shown in the following example:
[DSN name in RPD]
Driver=ORACLE_HOME/bi/common/ODBC/Merant/7.1.4/lib/<7.1.4.so>
Description=DataDirect 7.1.4 MySQL Wire Protocol
ApplicationUsingThreads=1
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=DB name
DefaultLongDataBuffLen=1024
EnableDescribeParam=0
InteractiveClient=0
LoadBalancing=0
LogonID=DB username
Password=DB password
PortNumbeR=DB PORT
ReportCodepageConversionErrors=0
TreatBinaryAsChar=0
- Update all existing data source names (DSNs) that are configured with the 11g DataDirect version. For example, the data source name for MySQL should point to DataDirect 7.1.4 as shown in the following example:
[ODBC Data Sources]
AnalyticsWeb = Oracle BI Server
Cluster = Oracle BI Server
SSL_Sample = Oracle BI Server
DSN name in RPD = DataDirect 7.1.4
- Save and close the odbc.ini file.