MDMGX - After Data Extraction

[Former Member]

Hi,

I am new for MDM Generic Extraction concept and understand the process up to generation of XSD and XML file generation. Below are the doubts in my mind. Please help me to get clear.

1. What is the use of XSD file generation. Is it used for source template for MDM import manager?

2. What is the use of Time out option in 'Define Repositories and FTP Server Details'.

3. How will import generated multiple XML files into MDM server via Import Manager. For Ex

1. Repository Fields :

Product ID -- UNIQUE Key FIELD

Product Desc

Country

Counry Description

ISO Code

Field1

Field2

2. Extracted XML files from MDMGX will be

File1 --> Product ID & Desc

File2 ---> Country & Country Desc

Please take the above ex or any valid examples and explain.

Thanks in advance.

[Former Member · Accepted solution]

Hi Rakesh

Please see replies below-

1. What is the use of XSD file generation. Is it used for source template for MDM import manager?

Correct. xsd generated is the structure which will be sued for generating the xml files. The same xsd we need to import in console and assign to the port for automated import to work.

2. What is the use of Time out option in 'Define Repositories and FTP Server Details'.

The timeout defines the time period until the extractor stops when it is waiting for the extracted file in a port to be handled.

If you set the timeout to the value 0, it is deactivated and all data is extracted immediately.

3. How will import generated multiple XML files into MDM server via Import Manager.

Once we maintain multiple ports with relevant table, field details to be extracted and the same is saved as variant for running the MDMGX- Start Extraction different xml files will be generated and written to different ports as specified in MDM via FTP. In your example we need to maintain 2 separate table entries in Maintain ports and check tables one for MARA- product Id and Description and another for Country, table T005.

Hope this helps.

Thanks-Ravi

[Former Member]

Hi Rakesh,

SAP has delivered standard extraction for Reference Data and for Master Data

The T-Code MDMGX is for Reference Data and it is used to load the Sub Table of MDM

The MDM business content contains the standard ports and maps which is required for reference data

The below thread explains the procedure to configure the MDMGX

There are sequences in extarcting the data.You can load only the revelant sub tables which is used in your repository using the selection creteria.

There is no XI/PI required as you can configure FTP or you can download it your desktop and manually load

Master Data Extraction

The T-Code MDM_CLNT_EXTR is used for the Master Data Extraction.

The distribution model is required for this and the configuration at PI is required

Follow the below link for more details

Regards,

Antony

[Former Member]

Replies please.