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

Who can tell me the difference between MDM,BW and ODS

What's the difference between MDM/BW/ODS,and what aspect/domain does each of them emphasize.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 14, 2005 at 03:24 AM

    HI Jiansen;

    To say this in one sentence, BW is a complete data warehousing system where ODS and MDM are structures and process within the BW to handle and manupulate the data as your business needs. Please find the detail information on

    Hope this helps.


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      1. You may opt to replace all those DBs by SAP BW and MDM. On there are some presentations on the topic Enterprise DataWarehouse that go into this direction.

      A step in that direction would be to use the BW (not the MDM) as center data repository and one by one fill those databases from BW instead of the different OLTP systems. When it's time to replace the other systems you may look if you want to replace them by SAP or by other products.

      2. All master data will be synchronized in MDM, SAP and non-SAP.

      3. You should consider XI for actually transferring the data, BW for collecting and distributing transactional data and simple master data (with only one source system) and MDM for merging and cleansing of complex master data that is maintained in multiple systems.

      4. The Meta Data Model can be mapped to a subset of the CIM. But object oriented data is not a part of the BW model (apart from attributes, texts and hierarchies on InfoObjects).

      Best regards


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.