Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on May 31, 2013 at 01:07 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.