Need a Data Integration for multiple ERP systems

[#1]

We are doing some research into a data integration layer to our BW 7.3/BOBJ 4.0 from multiple ERPs.  Of course we are looking at Data Services and Information Steward in the BOBJ suite but just looking for anybody's recommendations on the topic.

What technology platform do you use to do the extract, transform, load processes from multiple backend sources into BW?  Any you would advise us to avoid? 

[Former Member]

Hello Edward,

The answer depends on multiple factors.

Some pointers:

• Volume and growth of db in scope planning (Federation vs replication )
• If data federation is where you want to move data services / BO tools will be ideal
• If your data is coming from multiple ERP systems you can utilize there delta queue to load data via data services (in case of SAP)
• Use native DB connect/UD connect functionalities in BW as with BW 7.3 its delta capable.
• Moving to BW 7.4 you will have SDA to solve that problem of integration to Non - SAP data into your EDW landscape

These are pointers but I would say talk to enterprise architects and look into the foresight of wheyare you want to move your EDW platform.

Cheers!

Suyash