3.7 Configuring MySQL for Oracle BI

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:

1. Open the odbc.ini file located at the following location:
   (UNIX) 12c_DOMAIN_HOME/config/fmwconfig/bienv/core/odbc.ini
   (Windows) 12c_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.
2. Update the ODBC entry to use the DataDirect drivers, as shown in the following example:

   [DSN name in RPD] 
   Driver=NEW_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 
   

3. 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
   

4. Save and close the odbc.ini file.