How to Connect Oracle 9i from SAS DI 4.2

[Grandhi4]

Hi Friends,

Can any one please tel me how to 'Connect and extract the Oracle 9i data from SAS DI 4.2'

Thx,

Suresh

[Patrick]

You need SAS/Access to Oracle or at least SAS/Access to ODBC licensed.

You then need to define in Metadata an Oracle Server and once done also a Library pointing to the Oracle Schema you need.

Step by step instructions here (chapter 2): http://support.sas.com/documentation/cdl/en/bidsag/61236/PDF/default/bidsag.pdf

[Grandhi4]

Thank you so much Patrick

This is book is very helpful for me !

Well am following the 'Oracle connection Topic'  Page # 37 in this book ...but in some point i was struck up   can you help please ? (This oracle thing am trying in my personal laptop) so wil u can help me by skype or TeamViewer please!

Thx,

Suresh

[shivas]

Hi Suresh,

What is error message you are getting when configuring.

Thanks,

Shiva

[Grandhi4]

Hi Shiva,

It's not a error exactly my question is where i have to enter Oracle user name & Password and what is 'Database schema name' what we have to enter here ?

Please add me here 4gsureshk@gmail.com

thx,

Suresh

[shivas · Accepted solution]

Hi Suresh,

Ok then you require complete configuration document.

Check this...step by step configuring oracle server/schema and process.Follow this document.

http://support.sas.com/techsup/technote/ts771.pdf

Thanks,

Shiva

[Grandhi4]

Hi Shiva,

I got it

Thank you so much for your help!

Well i have one more (may be this is big task) will you can help !?

Can i have your email id please!

Have a great day.

Thx,

Suresh