Setting up an Oracle ODBC Driver and Essbase

2781453

Hi all,

I am trying to retrieve data directly from Essbase into SAS (Statistical Analysis Software) by setting up an Oracle ODBC Driver and Essbase.

I read this document in the below link and I was convinced that I could use ODBC to connect to Essbase, but our data administrator says that Essbase is an OLAP database and can NOT use ODBC.

http://docs.oracle.com/cd/E10530_01/doc/epm.931/esb_sqlint.pdf

I am a SAS programmer, but I have no background in technical configuration, so I was wondering if someone can help me if it is really possible or not to connect to Essbase using ODBC.

If it is possible, I have a follow up question...

I followed this link below to do a set up and did so successfully before the actual step to add a new data source to ODBC driver.

I should be able to select the TNS Service Name from the drop down list. This name will be that which I named in the TNSNAMES.ora file’s Alias = section, but I don’t see this option…

It would be great if someone knows why I do not see this option populated under drop-down in the screenshot.

Setting up an Oracle ODBC Driver and Data Source | Ten Six Consulting