What are steps invovlved in connecting OLTP system to DATAWARE HOUSE to get the souce from OLTP system

Showing Answers 1 - 3 of 3 Answers

vizaik

  • Mar 22nd, 2007
 

Mr.,
Go to source analyzer
select sources tab.
select import from databases.
it opens a child window which asks for username,password and connection name.
there will be a button with '...' you press it .
create a userdsn with using username,password and hostname(system name) and name it as you like.
select that name as connection name in child window.
give username and password here.
press connect button.
if your username,password match with the OLTP system, the structure comes here.
you can select which ever objects you require and press ok.
it takes some time to load into the right pane of designer.
press ctrl+s.
now the source definitions are loaded from OLTP system.
Thank u in advance

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions