Merge several data sources in SAP FIM to use these in SAP BO FC

[Former Member]

Hi,

is it possible to merge data from several data sources (eg SAP ECC and MS SQL DB) via SAP FIM to generate a consolidated data base which can be used in SAP BO FC? I'm just able to connect one data source in a FIM-job and map the particular source and target dimensions...

Based on this, I have two suggstions:

1. Connect SAP BO FC via SAP FIM to the particular data sources, transform the meta data again and again and again to the same target format and thus, merge the data in SAP BO FC
2. This is simply not possible in SAP FIM and thus, I have to use SAP Data Service Designer

However, our customer wants to use SAP FIM...

It would be great, if anybody could answer my question!

King regards,

Matthias

[Marc_Kuipers · Accepted solution]

Hello Matthias,

A possible suggestion:

Use EPM-BFC as target and load the data in 'package data'. You can then use the consolidation engine in BFC to get consolidated data.

With this, you can define 2 FIM jobs, with 2 different sources, mapping to the same target.

When executing, you can specify how to treat existing data (merge or replace)

So, you could load data with job1 from ECC into package X

Then, with job2 you load from MS SQL again to package X, and merge the data.

Hope this helps

Marc

[Former Member · Accepted solution]

Hi Marc,

thank you very much for your reply, opinion and support!

So... I think, it is simply not possible to connect two different data sources in one FIM job - unfortunately.

King regards,

Matthias