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,

Regarding migration of data, I would advise you let an ETL tool (such as the one that Business Objects has) do the job.

Cleansing: For initial cleansing while migration, many ETL tools have connectors to cleansing. Again, Business objects has cleansing capabilities as well (Data Services XI).

Matching: same as cleansing, do it as part of migration. Many tools offer that.

Another point to think of, is that cleansing and matching is needed not only when data is migrated.

As we see it as an on going process, I would recommend that if you have your master data in MDM, you should consider ongoing cleansing, using MDM capabilities to obtain cleansing from tools. Such a connector exists between MDM and different tools, as well as with Business Objects.

If you do not have your master data in MDM, maybe it's about time to think of it.

Edna