How to activate SQL Server in order to extract data using OracelWarehouseBuilder [message #109527] |
Fri, 25 February 2005 02:41 |
Saravanan V
Messages: 1 Registered: February 2005
|
Junior Member |
|
|
Hi! Can any one provide me step by step information to configure OWB for to have synchronization with SQL Server.
I could not able to create new SQL Server Source Module using OWB. In the new database link wizard, it is prompting to provide the following;
1> DB Link Name
2> SQL *Net Connect String
--------or---------------------
2> Host Name
3> Port Number
4> Oracle Service Name
5> User Name
6> Password
What are information that I need to provide for the above promting window and also provide me steps that should I need to configure TNSNAMES.ORA file for the SQL Server database connectivity?
Please provide me the soloution ASAP so that, I 'll be really thankful to you.
Regards,
Saravanan V
(www.ibexi.com)
|
|
|
|