Question Re: Need a Data Integration for multiple ERP systems in Technology Q&A

Need a Data Integration for multiple ERP systems

Eniedfeldt — Mon, 09 Jun 2014 19:55:10 GMT

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?

Re: Need a Data Integration for multiple ERP systems

former_member136842 — Wed, 11 Jun 2014 10:42:26 GMT

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.

Re: Need a Data Integration for multiple ERP systems

Former Member — Wed, 11 Jun 2014 14:08:28 GMT

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.

Re: Need a Data Integration for multiple ERP systems

Former Member — Tue, 17 Jun 2014 06:58:23 GMT

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

Re: Need a Data Integration for multiple ERP systems

Eniedfeldt — Thu, 03 Jul 2014 13:53:14 GMT

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

Re: Need a Data Integration for multiple ERP systems

Former Member — Fri, 04 Jul 2014 09:14:30 GMT

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

Re: Need a Data Integration for multiple ERP systems

Former Member — Mon, 04 Aug 2014 17:45:23 GMT

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