Hi friends,
For Creating ODBC Database Connections for DAC Client, i need to create ODBC connection and for it i tried to give ODBC connection for oracle database and they adviced the below points in the docs like
To create ODBC connections for Oracle databases
1. On the Windows machine that will host the DAC Client, navigate to the ODBC
Data Source Administrator.
Use the System DSN tab of the ODBC Data Source Administrator to create an
ODBC connection to the Oracle Business Analytics Warehouse database using the
Oracle Merant ODBC driver that is supplied with Oracle BI Applications.
For example, you might create a database connection called Connect_to_OLAP.
2. Click the System DSN tab.
3. Click Add.
4. In the list of drivers, select the Oracle Merant ODBC driver that is installed with
DAC, for example, Oracle Merant ODBC Driver in DAC 10g_Oracle - OH1.
But i couldnt find Oracle Merant ODBC Driver in DAC 10g_Oracle - OH1 driver in my System DSN, hence i have installed DAC softwares successfully. Then how it is possible to establish a ODBC Connection to DAC like mentioned in docs.
The drivers that i found are below like
Oracle BI Server 11g_OH161304452
Oracle in OraClient11g_home1
Informatica Data Services ODBC Driver
MERANT OEM 5.3 32-BIT Btrieve
Whether it is possible to establish a ODBC connections using the above drivers or i need to install Merant ODBC driver inorder to establish ODBC Connection.
Kindly advice me.
Regards,
Saro