Need a Data Integration for multiple ERP systems

[Eniedfeldt]

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

[Eniedfeldt]

We're still evaluating vendors, SAP DS/IS of course, also Informatica and SSIS.  Any thoughts on these?

[Former Member]

Hi Edward,     About Informatica and SSIS no idea, just about DS in this case, I highly recommend. Regards.

[Former Member]

Hi Edward,      Did you find the correct ETL-integrator tool? Regards

[Former Member]

Hi Edward,     I am agree with Sebastian, if you want to load high sizes of data, i'd choose Data Services, but if it is just needed to integrate the information on real time, I recommend SAP PI. Regards.

[former_member136842]

Hi,

in your scenarion Data Services and Information Steward would be the products of choice as they have the best integration into the SAP World.

Especially when your work with Extractors on the ERP Site Data Services is highly recommended.

Regads

-Seb.