ODBC Connection for Oracle
Posted: Wed Apr 18, 2007 6:59 am
Hi
I have installed Oracle and just wondering how to use the tables in oracle ,
This is what I tried
Manager- Import- table definations - ODBC tables
it prompts me for DSN name , User Name and password
Now when I go to administrative tools and try to add DSN
During the Oracle 8 ODBC drivers Set Up I am suppose to enter DataSource Name ,Service Name and User ID
Can Anybody explain what am I suppose to enter ?
This may be very basic question but I am new to Datawarehousing and just started with Datastage.
Please let me know if I can find all the above information in the online documentation as I tried searching it but could not find these details
Thanks a lot in advance .
I have installed Oracle and just wondering how to use the tables in oracle ,
This is what I tried
Manager- Import- table definations - ODBC tables
it prompts me for DSN name , User Name and password
Now when I go to administrative tools and try to add DSN
During the Oracle 8 ODBC drivers Set Up I am suppose to enter DataSource Name ,Service Name and User ID
Can Anybody explain what am I suppose to enter ?
This may be very basic question but I am new to Datawarehousing and just started with Datastage.
Please let me know if I can find all the above information in the online documentation as I tried searching it but could not find these details
Thanks a lot in advance .