BookmarkSubscribeRSS Feed
Ckazin
Calcite | Level 5

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

1 REPLY 1
TomKari
Onyx | Level 15

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 2685 views
  • 0 likes
  • 2 in conversation