The SAS Output Delivery System and reporting techniques

interface among multiple data platforms

Reply
N/A
Posts: 0

interface among multiple data platforms

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.
SAS Super FREQ
Posts: 8,868

Re: interface among multiple data platforms

Posted in reply to deleted_user
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
Ask a Question
Discussion stats
  • 1 reply
  • 109 views
  • 0 likes
  • 2 in conversation