I need access Oracle from SAS.
1) Oracle database is in another server computer,
2) local computer has SAS, but no Oracle;
3) local computer use Windows7(64 byte).
4) Now I can access Oracle from Toad, but I need access from SAS!.
Do I need install Oracle on my local computer? Or just install ODBC driver? What's dsn mean in the code below?
Proc sql ;
connect to ODBC (dsn = 'XXXX' user = gzhang password = XXXX) ;
create table CTable as
select * from connection to ODBC
(
select ....
Can anyone help me, I will appreciate it.
No, you don't need Oracle installed locally, but you do need some method of your computer talking to Oracle.
Try following the instructions here:
https://support.sas.com/techsup/technote/ts714.pdf
What SAS product do you have to connect to Oracle?
SAS/ACCESS to ODBC, SAS?ACCESS to OLEDB or SAS/ACCESS to Oracle? One of these must be installed and licensed to connect to Oracle. You can check your licence by running: proc setinit noalias; run;
I got these:
---SAS/ACCESS Interface to PC Files
---SAS/ACCESS Interface to ODBC
---SAS/ACCESS Interface to OLE DB
So I do need install Oracle on my local computer?
Thanks.
No you do not need Oracle installed on your local computer.
I don't have ODBC driver. How can I configure it? I remember I need ...ora file? I cannot remember the exact file name.
I think these are getting to be Windows/Oracle questions not really SAS related.
Regardless, you do need an ODBC driver - see your IT team or the Oracle page to download the correct one for your system.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!