Help using Base SAS procedures

Accessing an Oracle Database from SAS on Microsoft Windows

Reply
Frequent Contributor
Posts: 77

Accessing an Oracle Database from SAS on Microsoft Windows

This paper describes three ways to access ORACLE tables: SAS/Access Interface to Orace, ODBC, OLE DB.
http://support.sas.com/techsup/technote/ts703.pdf

Is there a performance difference among these three methods?
Super User
Posts: 10,044

Re: Accessing an Oracle Database from SAS on Microsoft Windows

Yes.There are some different.
I recommend to use SAS/Access which is more efficient because you can pass sql code to Oracle DBMS by Pass-Through method to use highly oracle resource, and you can also have several sessions at one time, However ODBC has only one session at one time .
About OLE DB ,not familiar.


Ksharp
Frequent Contributor
Posts: 77

Re: Accessing an Oracle Database from SAS on Microsoft Windows

Doesn't ODBC also allow pass-through query?
Super User
Posts: 10,044

Re: Accessing an Oracle Database from SAS on Microsoft Windows

ODBC also allow pass-through query.
But I still prefer to SAS/Access.
whatever ,if you want to know more about these, the best way is to chech documentation.

Ksharp
Ask a Question
Discussion stats
  • 3 replies
  • 138 views
  • 0 likes
  • 2 in conversation