Max no of Vendors at a time

[Former Member]

Hi All,

I am trying to send vendor from R/3 to MDM via XI.

Can anyone tell how many vendors we can send from R/3 to MDM at a time without effecting the performance?

Regards,

Nikhil

[michael_theis · Accepted solution]

Hi Nikhil,

I think that it is hardly possible to give you a valid number of vendors you can send from R/3 via XI to MDM as there are three different systems (most probably running on three different servers with different settings, and so on) involved. There are some things you should consider for this kind of distribution:

1) in R/3 System

I assume that you are using MDM_CLNT_EXTR (or something similar) to send IDocs to XI?! If yes, I want to give you a short explanation how the extractor is working. Before sending the IDoc to XI, it selects all vendor data and stores it internally for processing within an "internal table". Those internal tables are usually part of the systems memory - which depends on the correspoding hardware and is of course limited. The more records you define to be extracted within one single message, the more memory will be aquired by the extraction process. Note that this has impacts on the whole system (e.g. if you extract the data during working time, all other users would have less memory available). Furthermore the size of the used memory depends on your data selection, too. Do you distribute the complete vendor with all of its segments? Or do you distribute only parts of the vendor? This impacts the IDoc size as well. If you limit the segments, you could distribute more records.

2) in XI System

The IDoc/File Adapter in XI limit the IDoc/XML file size to 500MB. This has mainly performance and memory reasons. Your IDoc/XML file size should not be to huge.

3) in MDM

Generally the import manager can handle files that contain many records better than many files containing one record. The import performance depends on

a) the number of records per file

- you can check the corresponding guides (Import Manager, Sizing) for details

b) the structure of the map respectively the record to be imported

- import into main table and/or qualified look up table

- sometimes it makes sense to import maintable records first and the update the qualified tables

c) the number of records already available in the repository

- the import usually include a match against existing records to find out if the new records should be created or if it's an update of existing records. Depending on the amount of available records, this matching can take more and more time.

Conclusion:

You should really do some performance tests in your environment. I'd start with 1000 records per IDoc and would then increase it slowly (5000, 10000, and so on) and do some performance measurements. You should get a good picture about the performance in your system this way.

BR Michael

[Former Member]

Hi Nikhil,

There is no such limit to send vendor nos to mdm from r3 via mdm, but yes your performance goes down if you will use a huge xml file.

Although SP05 doesn't have any monitoring tool, still you can check it, while loading repositories, mounting, having such big data.

But for your information, soon with SP06 MDM could have a monitoring tool named as Solution Manager to monitor system performance.

Hope this will help, pls reward with points if found helpful.

Regards,

Alok Sharma

[Former Member]

Hi Nikhil,

R/3 sends out data in format of Idocs and there are standard idocs debmas to be used in XI and then the fields has to be mapped in XI to send the dat to the target system (MDM)using standard XSD provided by standard business content in MDM.

I can also sent u alink in this regard.

Deepankar.[https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/4363] [original link is broken] [original link is broken] [original link is broken];

Please reward points if useful.

Regards..

Edited by: Deepankar Pandit on Jan 22, 2008 10:58 AM

[Former Member]

Hi Nikhil,

There is no specific amount of data that you can send at a time. It can be from thousands to lacs.

What you can do is send some vendors and see the performance.

You can refer to this link for performance tuning

http://help.sap.com/bp_bpmv130/Documentation/Operation/TuningGuide.pdf

http://help.sap.com/saphelp_nw70/helpdata/en/9e/6921e784677d4591053564a8b95e7d/frameset.htm

Hope this is helpful.

Regards,

Merrilly

[Former Member]

Hi Nikhil,

on the MDM 5.5 server you have to store the XSD file of the Vendor in the ready folder of the remote systems Inbound folder. That XSD file will automatically goes into archive folder through which it will import the map.

In the import manager you will have to define the type,port number and Remote system of which data you will import.

Once this has been finished you are able to do the automatic importing of data in the Data Manager.

hope dis helps you,

feel free to Ask,

Regards,

Swapnil