How to Connect OBIEE 12c to Microsoft SQL Server ?

Rohit Trehan

I am working on connecting OBIEE 12c to Microsoft SQL Server but i am confused with what i found on the oracle support site.

Here is what i found:

https://docs.oracle.com/middleware/12212/biee/BIEMG/GUID-C03C12DB-50AA-4ED5-B5B0-A32EA0E73D92.htm#datadirect_sql_srvr

which is a bit confusing to me. Could someone dummy it down for me OR explain the steps in an easier way.

Thanks a lot !

[Deleted User]

Which part? You need ODBC driver to get to MSSQL and Oracle ships DataDirect drivers for that. Where's the confusion?

Also: How To Ask Questions The Smart Way

Rohit Trehan

I am unable to find the  ARsqls27.so file in any of the ORACLE_HOME or anywhere in the server.

So apparently, it didn't ship with my Oracle 12c.

What should be my next step ?