Help using Base SAS procedures

Accessing OBIEE with ODBC

Reply
N/A
Posts: 1

Accessing OBIEE with ODBC

Does anyone have experiences they could share about successfully accessing the presentation layer (or underlying data) from OBIEE with SAS?

PROC Star
Posts: 1,088

Re: Accessing OBIEE with ODBC

I can give you some general comments on connecting to an ODBC source.

1. Assuming that SAS is running on your PC

i) Ensure that the ODBC connection software for obiee is installed on your PC (when you create a new ODBC data source, you should see your obiee as one of the options).

ii) Create a new data source for your obiee data using the Windows odbc facility.

iii) In SAS, connect to your new data source using a LIBNAME statement. Documentation for this is under SAS/Access.

If it works, great. If it doesn't, I suggest trying to connect to your ODBC data from another product, like Excel or Access, to see if the problem is with the ODBC or with SAS.

2. If you're running SAS on a server

Same process, except that you'll have to install the ODBC data source on your server. This may involve you doing a remote desktop connection to your server, or getting your server admin. to do it. The rest of the steps are the same.

Good luck!

Tom

Ask a Question
Discussion stats
  • 1 reply
  • 1352 views
  • 0 likes
  • 2 in conversation