topic Accessing OBIEE with ODBC in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Accessing-OBIEE-with-ODBC/m-p/101642#M28534 <HTML><HEAD></HEAD><BODY><P>Does anyone have experiences they could share about successfully accessing the presentation layer (or underlying data) from OBIEE with SAS?</P></BODY></HTML> Wed, 22 Aug 2012 12:13:29 GMT Ckazin 2012-08-22T12:13:29Z Accessing OBIEE with ODBC https://communities.sas.com/t5/SAS-Procedures/Accessing-OBIEE-with-ODBC/m-p/101642#M28534 <HTML><HEAD></HEAD><BODY><P>Does anyone have experiences they could share about successfully accessing the presentation layer (or underlying data) from OBIEE with SAS?</P></BODY></HTML> Wed, 22 Aug 2012 12:13:29 GMT https://communities.sas.com/t5/SAS-Procedures/Accessing-OBIEE-with-ODBC/m-p/101642#M28534 Ckazin 2012-08-22T12:13:29Z Re: Accessing OBIEE with ODBC https://communities.sas.com/t5/SAS-Procedures/Accessing-OBIEE-with-ODBC/m-p/101643#M28535 <HTML><HEAD></HEAD><BODY><P>I can give you some general comments on connecting to an ODBC source.</P><P></P><P>1. Assuming that SAS is running on your PC</P><P></P><P>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).</P><P></P><P>ii) Create a new data source for your obiee data using the Windows odbc facility.</P><P></P><P>iii) In SAS, connect to your new data source using a LIBNAME statement. Documentation for this is under SAS/Access.</P><P></P><P>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.</P><P></P><P>2. If you're running SAS on a server</P><P></P><P>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.</P><P></P><P>Good luck!</P><P></P><P>Tom</P></BODY></HTML> Wed, 22 Aug 2012 14:21:41 GMT https://communities.sas.com/t5/SAS-Procedures/Accessing-OBIEE-with-ODBC/m-p/101643#M28535 TomKari 2012-08-22T14:21:41Z