Performance while loading data using IODC in SAP CRM

dataservices sap-erp-bw
1

Hello,

Performance bottle neck while loading BP in SAP CRM using IDOC via Business Objects Data Services XI 3.2 SP3.

Rate of posting and idoc is One idoc per min. Where replication to ECC is not considered.

Is LSMW is better way to go forward.??

or we can apply some optimization in BODS or at Database end.??

many thanks

sjain :india: (BOB member since 2009-04-17)

2

The performance on the Data Services side will depend on a number of factors when passing in IDocs to the target ERP / CRM system. The factors below can all play a part in slow performance.

  1. Network speed between DS and SAP target
  2. Depth and compexity of the NRDM structure (in the case of BP can be complex)
  3. Processing capabilities of the DS box, i.e. number of processors, memory, etc.
  4. What kind of processing is being triggered on the SAP side.

In the case of 1 and 3 there is not much I can advise on other than the better the network round trip and better the hardware clearly improvements can be made.

With regard to point 2 ensure that you do not have redundent schemas within you BP model (i.e. all fields are null) and ensure that you have specified all of the required where clauses and from clauses correctly to ensure you are not creating duplication at the lower level schemas. You can test this by dropping in a template XML file as an output to the data flow also to look at the structure of the output IDoc.

With regard to point 4 you need to look at whether you are triggering the IDocs immediately or holding for background processing. If the former is true them in WE20 switch the IDoc processing to background and then use program RBDAPP01 to allow you to setup parallel processing of the IDocs on the SAP side making use of all application servers available.

jongreen (BOB member since 2010-05-14)

3

Sandeep

Ever tried solving these issues with loading CRM using BDoc’s?

ganeshxp :us: (BOB member since 2008-07-17)

4

Extremely old topic mate :wink:

I was not aware that bods could send bocs. I thought that they were only for replication from and to ECC?

Johannes Vink :netherlands: (BOB member since 2012-03-20)

5

I gonna do lay some work on this front…so I wanted to get a experience share on this…

ganeshxp :us: (BOB member since 2008-07-17)