interface among multiple data platforms

deleted_user — Wed, 28 Mar 2007 15:43:23 GMT

We are running SAS 8.2 on the z/OS platform. I'd like to know if it's possible to access ORACLE data which resides on the UNIX platform.
Thank you.
Lana.

Re: interface among multiple data platforms

Cynthia_sas — Wed, 28 Mar 2007 18:11:02 GMT

Hi, Lana:
This is not really an ODS/Reporting question, so much as it is a data access question.

The answer is "it depends" -- on how SAS is licensed on your various servers and whether/where you have SAS/Access for Oracle licensed.

Generally speaking, if you have all the right pieces in the right places, then you could use the LIBNAME statement:[pre]
libname oralib oracle user=johndoe password=xxxxx path=YYYYYYYY;
[/pre]
OR, you could get to the ORACLE data using SAS/Access to ODBC or SAS/Access to OLE DB.

For more information, consult this documentation:
support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/access_oracle_7367.pdf

In order to find out the definitive way, given your site license and configuration, your best bet is to contact Tech Support: http://support.sas.com/techsup/contact/index.html
Good luck!
cynthia

topic Re: interface among multiple data platforms in ODS and Base Reporting

interface among multiple data platforms

Re: interface among multiple data platforms