Extractind data from Oracle into SQL Server !!

• Prakash Alladi

  Grasshopper

  Points: 13

  More actions

  November 16, 2005 at 1:02 pm

  #68510

  Hi Gurus,

   

  We have Oracle ERP systems and are planning to implement the Data warehousing using Microsoft Business suite(Analysis,Reporting).Can you please suggest me ,once I extract the data in Oracle way to load into SQL Database tables.

  Presently we run our programs(Processes) in Oracle applications which extracts the data and dumps into staging table.And later we initiate our DTS process(from SQL side) to copy the data into SQL server.This way we are having logistic issues like space and performance in Oracle side so instead of dumping into staging table in oracle side we wanted to dump directly into SQL server table as soon as the data is extracted through scheduled processes.

  Is is possible to directly insert the data into SQL server?

  If above is not efficient(not possible) can I use DTS?How does the DTS knows to start the process since both are in different databases.Can I have a logic to start DTS soon after my process completes in Oracle?

  Your suggestions are greatly appreciated.

  Thanks in advance.

  Prakash

  prakashalladi@yahoo.com

• rsharma

  SSCarpal Tunnel

  Points: 4865

  More actions

  November 16, 2005 at 2:23 pm

  #604294

  Yes, it is possible to do this in DTS...open up DTS designer and look at the transform data task, DDQ etc.

  http://www.sqldts.com

  will be a good site to start from.