Comparision

[Former Member]

Hi,

My company is upgrading to the latest ECC from SAP older version, in such a case we need to migrate all the data from old to new.

In such situation one would use migration tools available out in the market to cleanse and remove duplicates and import into ECC(both master and transaction).

1. Is it advisable to use SAP MDM in such a situation to migrate all the data handling the conversions instead of a standard migrating tool? I am not sure if MDM would be as expected to do a good migration job.

2. If MDM is preferred, then what is the best way to migrate the transaction data?

3. If SAP MDM is not prefered as a migration tool, rather use a standard migration mechanism, then I would say all the cleansing efforts would have already been completed by the migration tool, then we wouldn't require MDM to do the cleansing efforts.

Please correct me if I am analysis it the wrong way.

Appreciate all your responses.

Rgds,

Peter.

[Former Member]

Hi Kris,

Is it advisable to use SAP MDM in such a situation to migrate all the data handling the conversions instead of a standard migrating tool? I am not sure if MDM would be as expected to do a good migration job.

- SAP MDM is not designed to perform good Data migration activities.

As it is a tool for data Deduplication.Data cleansing is a vast area and there are many specific tool for data cleansing.

MDM is rather prefered when you need to eliminate duplicates in your master data for an Ongoing process (Steady state) and for harmonising this cleansed data.

If MDM is preferred, then what is the best way to migrate the transaction data?

- MDM is Master data management tool ,so it does not work for transactional data.

However using MDM we can find out the duplictae records and then identify them using a single global key and from then on future transactions can run on the global data record instead of the individual duplicate records and gradually open transactions can thus be analyses and closed for future transactions on the duplicate records.

If SAP MDM is not prefered as a migration tool, rather use a standard migration mechanism, then I would say all the cleansing efforts would have already been completed by the migration tool, then we wouldn't require MDM to do the cleansing efforts.

- This is a good question.

Firstly MDM is not a data migration tool.When we rae migrating data besides cleansing them by eliminating duplicates we also need to perform several transformation,conversions etc which is any ways not designed to be handled by MDM effectively.

But however when you are going for migration of data from SAP to ECC it will be a one time activity.What about the masters created in ECC after that.

You need a mechanism where by every new material or customer or vendor master created in/for the company needs to be sure that it is not a duplicate record.This is taken care by MDM.

Besides thsi we can use workflows to cobtrol the process of master creation and thus employ governance mechansim.

This will ensure that the quality of our master will always be good ,Then MDM can be used to syndiacte these correct records back to ECC.

So your workprocess would be

SAP->MDM (Workflows)-> ECC

Hope it helped

Kindly reward points if found useful

Thanks

Simona