SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

How to Connect Oracle 9i from SAS DI 4.2

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 86
Accepted Solution

How to Connect Oracle 9i from SAS DI 4.2

Hi Friends,

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

Thx,

Suresh


Accepted Solutions
Solution
‎05-07-2012 04:51 AM
Super Contributor
Posts: 349

Re: How to Connect Oracle 9i from SAS DI 4.2

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

View solution in original post


All Replies
Respected Advisor
Posts: 4,173

Re: How to Connect Oracle 9i from SAS DI 4.2

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

Frequent Contributor
Posts: 86

Re: How to Connect Oracle 9i from SAS DI 4.2

Thank you so much Patrick Smiley Happy

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 Smiley Sad  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

Super Contributor
Posts: 349

Re: How to Connect Oracle 9i from SAS DI 4.2

Hi Suresh,

What is error message you are getting when configuring.

Thanks,

Shiva

Frequent Contributor
Posts: 86

Re: How to Connect Oracle 9i from SAS DI 4.2

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

Solution
‎05-07-2012 04:51 AM
Super Contributor
Posts: 349

Re: How to Connect Oracle 9i from SAS DI 4.2

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

Frequent Contributor
Posts: 86

Re: How to Connect Oracle 9i from SAS DI 4.2

Hi Shiva,

I got it Smiley Happy

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 892 views
  • 3 likes
  • 3 in conversation