Not sure if this is the right place to ask but.... Can someone tell me the steps I need to follow in order to establish connectivity to an Oracle database? I've never done this before, so if whoever responds can put things into really simple terms, that would be greatly appreciated.
I also looked in SAS Tech Support, but not being sure of what to search for, found nothing.
Thank you to all who reply....looking forward to hearing from you!
Also, if I remember correctly from previous posts, you have the Enterprise Intelligence Platform installed. So you might wish to read the Platform Administration documentation on configuring your servers and setting up LIBNAME statements for data base files -- generally, your data base files should be visible (defined to) the metadata server.
The Enterprise Intelligence Platform is not necessary to use SAS/Access for Oracle (or, at least, I don't think that we have it installed).
SASman, you will need to work with your Oracle DBA to get the information to use SAS/Access for Oracle. The schema name is defined in the tnsnames.ora file (a file that the DBA manages). You also need to have the appropriate Oracle client (or at least some pieces) installed on the machine that SAS is running on.
You are correct. The Enterprise Intelligence Platform is NOT necessary to use SAS/Access to Oracle. However, SASMan has posted in the Stored Process forum previously (where I have answered his SP questions and emailed code to him -- so I know that he is using the Enterprise Intelligence Platform -- unless he's changed job duties since his Stored Process postings).
So, in addition to reading the SAS/Access doc and working with his DBA for schema and password info, etc; he may also have metadata server definitions that he needs to do, which requires reading the Enterprise Intelligence Platform Admin doc.
As long as you have SAS/Access to Oracle, you can access Oracle tables. However IF you ALSO have the SAS Enterprise Intelligence Platform, that adds another twist to the question -- because the Metadata server also needs to be taken into account.
SAS/Access to Oracle existed long before the Enterprise Intelligence Platform. However SAS/Access to Oracle also can run within the context of the Enterprise Intelligence Platform. I did not mean to confuse the issue for folks who do not have the "platform".
Thank you to all who replied....it's appreciated! What I'm trying to do, with zero experience in doing it, is to set up a new library. I have gone through the steps of sdefining a database server metadata object, defining a database schema metadata object and defining a database library metadata object.
Where I am running into a problem is in EG 3, when I try to double-click on the newly created library, I get a message that says the userid and password I'm using are invalid. I also tried creating a new group that points to the newly created libray and then getting in to the library, to no avail.
If anyone has an idea as to why I can't click onto the library and explore the library, I'd love to hear it. Thanks so much!