Challenges - Data Migration

[Former Member]

Hi, could someone tell me the challenges that are commonly encountered during data migration?

[former_member189669 · Accepted solution]

Hi Ananth,

We can foresee numerous challenges in Data Migration. Few of the most important ones as below:

1) Ensure that we download/extract precise data from Source system( eg.ECC). We must configure fool proof extract mechanism to download it to right format.

2) Precise Import maps -

a) Lookup tables - Look up tables have to be refreshed with live data from source systems with valid remote keys. This is required for making auto value mapping happen during import.

b) Main table import map - Accurate import map for main table ;identify the right matching field 9 primary key)

c) Maps for Qualified /Hierarchy tables - Import maps Involves compound fields and field partioning, Right display fields to be decided and configured accordingy.

Ensuring table joins, splitting, partitioning are done accurately is very important.

3) Volume of imports - Bulk imports hinder import performance. Perform batch imports of smaller chunk size to speed up the process.

4) Data validation - Formulating a process/template to validate data in MDM with source system data. This is a complex process when validation is required for every field in data model.

Regards,

Vinay M.S

[rammmimpbm]

The challenges related to the data and its integration with the current systems is a huge task on hand with organization. The format of the data needs to be followed in order to integrate with the existing user data or Business Partner data in the system.

[Former Member]

Hi Anantharam,

One important aspect is to ensure a high data quality. Otherwise, you'll have a lot of effort (due to a lot of specialized business rules) and still low-quality data ("garbage in - garbage out").

Another problem is that the data to be migrated is typically "live data" - it hence changes over time. So you have to decide on a suitable cross-over approach (e.g. quick ETL at once, delta migration, phased approach, ...).

Best regards,

Dennis

[rajasekhar_reddy14]

Hi,

The Succes of migration project depends upon how well you know the content and bussiness rules.

search below term in google you wil find one really good pdf.

challenges that are commonly encountered during data migration in SAP MDM.

Regards,

Raj