how do you import/migrate initial data into MDM, is it using PI.

[Former Member]

we have a requirement as below:

there are around 500,000 records in a customer master in SAP R/3.

this data need to be imported into SAP MDM. (after this step, SAP R/3 will be removed/scrapped from the landscape)

after importing to MDM, the records need to be updated to SAP ECC.

so the requirement is something like:

SAP R/3 -

---

> MDM -

---

> ECC.

the R/3 to MDM import is one time, initial, activity, to be done for around 5 lac records.

to migrate these much data, is it recommended to use PI.

thanks in advance.

Ganesh

[Former Member]

Hi Miles

You can use the generic extractor to retrieve customizing entries from SAP remote systems

such as SAP Enterprise Resource Planning (ERP) and to send them as reference data to

the MDM Server.

The extractor can retrieve any customizing data such as check tables and domain fixed

values needed for consolidating SAP master data objects. The extractor is generic because

its use is independent of the type of SAP remote system and the master data object type.

You can set up and execute the extraction using transaction MDMGX. The generic extractor

is imported to the remote systems using SAP Note.

The generic extractor hands over the customizing tables to the MDM folder system in XML

format. From there you can load the reference data to MDM either automatically using the

Import Server or manually using the Import Manager. In addition the extractor can generate

XML schemas (XSD files) to set up the import to MDM.

For more information about the overall process, see section Loading Reference Data in the

MDM 5.5 - IT Scenario Configuration Guide at service.sap.com/installMDM.

Thanks

Kolusu

Edited by: Kolusu on May 20, 2009 9:47 PM

[Former Member]

Hi Ganesh,

It is better to do initial upload by using

1. excel files if data can be extracted from different remote systems.

2. import using XML files by using MDM_CLNT_EXTR T cod if the remote system is R/3.

Regards,

Pramod

[Former Member]

HI,

Generally PI is not used for Single time(one time) Upload.So Initially Use MDM Import Manger and import the records into MDM and if the records has to be automated(like when a record is created in ECC, it has to be created in MDM),then you need to use PI.

From MDM , records can be syndicated to ECC using PI.

Thanks

[Former Member]

Hi Ganesh

Data import from R/3 into MDM for one time job, you can perform without PI by extracting the data as XML files (Using MDMGX and MDM_CLNT_EXTR).

But for data synchronization and sindication you would need PI, MDM generates XML files whic will be fed to PI and gets concerted into IDOC's.

These IDOS's will be used in SAP ECC for posting data.

To answer your question: Yes you would need XI for data syndication.

Hope this is useful to you...

Gaurav