topic How to Connect Oracle 9i from SAS DI 4.2 in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/How-to-Connect-Oracle-9i-from-SAS-DI-4-2/m-p/105640#M1170 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>Can any one please tel me how to '<STRONG>Connect and extract the Oracle 9i data from SAS DI 4.2</STRONG>'</P><P></P><P>Thx,</P><P>Suresh</P></BODY></HTML> Sun, 06 May 2012 18:42:07 GMT Grandhi4 2012-05-06T18:42:07Z How to Connect Oracle 9i from SAS DI 4.2 https://communities.sas.com/t5/SAS-Data-Management/How-to-Connect-Oracle-9i-from-SAS-DI-4-2/m-p/105640#M1170 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>Can any one please tel me how to '<STRONG>Connect and extract the Oracle 9i data from SAS DI 4.2</STRONG>'</P><P></P><P>Thx,</P><P>Suresh</P></BODY></HTML> Sun, 06 May 2012 18:42:07 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-Connect-Oracle-9i-from-SAS-DI-4-2/m-p/105640#M1170 Grandhi4 2012-05-06T18:42:07Z Re: How to Connect Oracle 9i from SAS DI 4.2 https://communities.sas.com/t5/SAS-Data-Management/How-to-Connect-Oracle-9i-from-SAS-DI-4-2/m-p/105641#M1171 <HTML><HEAD></HEAD><BODY><P>You need SAS/Access to Oracle or at least SAS/Access to ODBC licensed.</P><P></P><P>You then need to define in Metadata an Oracle Server and once done also a Library pointing to the Oracle Schema you need.</P><P>Step by step instructions here (chapter 2): <A href="http://support.sas.com/documentation/cdl/en/bidsag/61236/PDF/default/bidsag.pdf">http://support.sas.com/documentation/cdl/en/bidsag/61236/PDF/default/bidsag.pdf</A></P></BODY></HTML> Sun, 06 May 2012 21:48:20 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-Connect-Oracle-9i-from-SAS-DI-4-2/m-p/105641#M1171 Patrick 2012-05-06T21:48:20Z Re: How to Connect Oracle 9i from SAS DI 4.2 https://communities.sas.com/t5/SAS-Data-Management/How-to-Connect-Oracle-9i-from-SAS-DI-4-2/m-p/105642#M1172 <HTML><HEAD></HEAD><BODY><P>Thank you so much Patrick <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P><P></P><P>This is book is very helpful for me !</P><P>Well am following the 'Oracle connection Topic'&nbsp; Page # 37 in this book ...but in some point i was struck up <img id="smileysad" class="emoticon emoticon-smileysad" src="https://communities.sas.com/i/smilies/16x16_smiley-sad.png" alt="Smiley Sad" title="Smiley Sad" />&nbsp; can you help please ? (This oracle thing am trying in my personal laptop) so wil u can help me by skype or TeamViewer please!</P><P></P><P></P><P>Thx,</P><P>Suresh</P></BODY></HTML> Mon, 07 May 2012 07:41:42 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-Connect-Oracle-9i-from-SAS-DI-4-2/m-p/105642#M1172 Grandhi4 2012-05-07T07:41:42Z Re: How to Connect Oracle 9i from SAS DI 4.2 https://communities.sas.com/t5/SAS-Data-Management/How-to-Connect-Oracle-9i-from-SAS-DI-4-2/m-p/105643#M1173 <HTML><HEAD></HEAD><BODY><P>Hi Suresh,</P><P></P><P>What is error message you are getting when configuring.</P><P></P><P>Thanks,</P><P>Shiva</P></BODY></HTML> Mon, 07 May 2012 08:00:56 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-Connect-Oracle-9i-from-SAS-DI-4-2/m-p/105643#M1173 shivas 2012-05-07T08:00:56Z Re: How to Connect Oracle 9i from SAS DI 4.2 https://communities.sas.com/t5/SAS-Data-Management/How-to-Connect-Oracle-9i-from-SAS-DI-4-2/m-p/105644#M1174 <HTML><HEAD></HEAD><BODY><P>Hi Shiva,</P><P></P><P>It's not a error exactly my question is where i have to enter Oracle user name &amp; Password and what is 'Database schema name' what we have to enter here ?</P><P></P><P>Please add me here <STRONG><A class="jive-link-email-small" href="mailto:4gsureshk@gmail.com">4gsureshk@gmail.com</A></STRONG></P><P></P><P>thx,</P><P>Suresh</P></BODY></HTML> Mon, 07 May 2012 08:32:09 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-Connect-Oracle-9i-from-SAS-DI-4-2/m-p/105644#M1174 Grandhi4 2012-05-07T08:32:09Z Re: How to Connect Oracle 9i from SAS DI 4.2 https://communities.sas.com/t5/SAS-Data-Management/How-to-Connect-Oracle-9i-from-SAS-DI-4-2/m-p/105645#M1175 <HTML><HEAD></HEAD><BODY><P>Hi Suresh,</P><P></P><P>Ok then you require complete configuration document.</P><P></P><P>Check this...step by step configuring oracle server/schema and process.Follow this document.</P><P></P><P><A class="active_link" href="http://support.sas.com/techsup/technote/ts771.pdf" title="http://support.sas.com/techsup/technote/ts771.pdf">http://support.sas.com/techsup/technote/ts771.pdf</A></P><P></P><P>Thanks,</P><P>Shiva</P></BODY></HTML> Mon, 07 May 2012 08:51:55 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-Connect-Oracle-9i-from-SAS-DI-4-2/m-p/105645#M1175 shivas 2012-05-07T08:51:55Z Re: How to Connect Oracle 9i from SAS DI 4.2 https://communities.sas.com/t5/SAS-Data-Management/How-to-Connect-Oracle-9i-from-SAS-DI-4-2/m-p/105646#M1176 <HTML><HEAD></HEAD><BODY><P>Hi Shiva,</P><P></P><P>I got it <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P><P>Thank you so much for your help!</P><P>Well i have one more (may be this is big task) will you can help !?</P><P>Can i have your email id please!</P><P></P><P>Have a great day.</P><P></P><P>Thx,</P><P>Suresh</P></BODY></HTML> Mon, 07 May 2012 11:32:46 GMT https://communities.sas.com/t5/SAS-Data-Management/How-to-Connect-Oracle-9i-from-SAS-DI-4-2/m-p/105646#M1176 Grandhi4 2012-05-07T11:32:46Z