R/3 to SQL to MDM

[Former Member]

I am loading master data (items) from R/3 to MDM. I was able to successfully move the basic data and get everything mapped correctly using Import Manager. This is going to be for initial data loads, roughly 1.6 million materials.

My problem is figuring out how to load the Classification data. If I have 1.6 million materials, I'll have about 46 million records of classification to load. I am able to extract from R/3 and land the data in SQL. I don't know how to map the Classification data due to the structure in MDM. My SQL output looks like this...

Material_Number Class_Name Class_Char Class_Value

-

---

1 0000000001 CLASS IC

2 0000000001 CHARS MM-PROD-CAT-IC 8BIT MPL

3 0000000001 CHARS MM-PRODUCT-GRADE COMM

4 0000000002 CLASS IC

5 0000000002 CHARS MM-PACKAGE CBGL3

...and so on. So there are multiple rows of the same material number with anywhere from 5 to 50 rows of characteristics.

Using XML would be poor performance and was designed for single records, but the mapping is possible that way.

Can I load the Classification data by copying it from my SQL table to MDM's SQL table directly? Do I have any other options?

Thanks for any help or ideas.

-Motley Drew

[Former Member · Accepted solution]

Hi,

I do not suggest you to directly copy the data into underlying tables of MDM. If you think that you have evry large volume of data, then you can try to split it into multiple files and Import number of times.

Regards,

Rajani Kumar

[Former Member · Accepted solution]

This is a very interesting topic

Maybe a seperate table for Classification:

- in the table have a field for each class

- Then a lookup of char. and char values

??. Is there any one out there who has done this? Would like to hear more

[Former Member]

I don't recommend you to copy directly.

[Former Member]

Hi,

I agree with Rajani..

You shouldnt go go for SQL mapping..

In case you have large amount, you can split the data in multiple files and then carry out the Import one by one..

Hpe that helps.

Regards,

Tanveer.

<b>Please mark helpful answers</b>

[Former Member]

Hi,

Indeed the MDM table structures change from release to release. That means that you should only use the standard mechanisms for importing data into MDM.

Nevertheless what other customers did was to use external "buffer" SQL Tables, and than to perform a normal import using the Import manager. That works fine for large ammounts of data, and you can even use XI´s JDBC adapter for connecting these "buffer" tables to your system landscape.

Regards, jc