connect to odbc with tables nested within server subdirectory

tellmeaboutityo — Thu, 21 Oct 2021 15:39:30 GMT

I'm sorry this is possibly a silly question, but I've always had IT people to set this up for me.

I'm trying to connect SAS to an ODBC server. I have both a user DSN and system DSN working.

I can access the tables in Oracle SQL Developer. However, and I don't know if this is relevant, but in the navigating pane to the left, where there is a sort of 'drop down file structure', the tables are located: server_name/other_users/libraries/table(s). As far as SAS code to access those tables, this is as far as I've gotten:

libname my_library odbc user=username password="password" datasrc=server_name;

This creates a library, but with no tables.

I don't know what other commands or info I am missing, but recognize many people used a schema and I do not know what that is. Can anyone please help?

Thanks in advance!

Re: connect to odbc with tables nested within server subdirectory

SASKiwi — Thu, 21 Oct 2021 19:09:02 GMT

You are on the right track. It looks like you have successfully created an Oracle database connection but are missing the SCHEMA option on the LIBNAME. The hierarchy for a database server is as follows: Server, Database, Schema, Table. I'm assuming your ODBC DSN includes the server and database. Oracle SQL Developer should give you details of the required schema which may be displayed as a prefix on table names.

topic Re: connect to odbc with tables nested within server subdirectory in Administration and Deployment

connect to odbc with tables nested within server subdirectory

Re: connect to odbc with tables nested within server subdirectory