3.5 Configuring the SQL Server

After configuring the 12c system, you must configure the SQL Server settings in the odbc.ini file.

To configure the SQL Server:

1. 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.
2. 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 SQL Server Wire Protocol 
   Address=DB HOST\SQLSERVER NAME
   Port=PORT NUMBER
   AlternateServers= 
   AnsiNPW=Yes 
   ConnectionRetryCount=0 
   ConnectionRetryDelay=3 
   Database=DB name 
   LoadBalancing=0 
   LogonID=DB username
   Password=DB password
   QuotedId=Yes 
   SnapshotSerializable=0 
   ReportCodePageConversionErrors=
   

3. Update all existing data source names (DSNs) that are configured with the 11g DataDirect version. For example, the data source name for SQL Server 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.