MDM syndication to XI

[Former Member]

Hello,

I would like to get some ideas about how anybody is handling full load syndication of master data from MDM to XI to other system? ECC or downstream systems...We are using file syndications - each master data (product, customer. vendor) is sent as a file to XI and XI sends to any downstream systems. For full loads, we are sending 10000's of files to XI..which takes like 12 hours..

Has anybody done this without File syndication? I am interested to explore JMS, webservices or any other ways of communication..

I appreciate any ideas..Thank you..

[Former Member]

Hi Thanujja,

May i know what version of MDM and XI are you using in your scenario, because i have got the task to work on MDM 7.1 integration with XI 7.0.

If you have any idea on these, Please let me know.

Thanks in advance,

Saravanan.

[prasanna_shanmugasundaram]

Hi,

For integrating of MDM 7.1 to ECC using PI 7.0 I guess the follwoing are possible.

If it is PI 7.0 with SP15 or above you can go with MDM PI Adapter.

If it is less than SP15 then I guess FILE will be the best option.

With File adapter the follwoing are possible.

1. If there is FCC then go for the "Recordset per Message", mention the number of records to processed.

2. On the receiving side (ECC side) use abap proxy.

3. Im not sure if we can use Cursor option in the receiving ECC proxy, if so go for it.

[Former Member]

Thanujja,

Well, i believe you should have some mechanism in MDM to append the new values, what you will have to look for is probably delta load + ways of appending the new values (instead of sending the whole thing which is causing the bottleneck) to the existing records. you can also try sending chunks of data in batches. this seems to be an issue at the MDM side.

From PI point of view if it is outgoing from PI we have several options, but in your case its incoming to PI.

Gud luck,

Regards,

Pavan

[Former Member]

SAP has provided JAVA & ABAP API for MDM so that you can use them to connect to MDM Repositories.

Please refer to the following..

[Calling MDM JAVA-API application (executable) from ABAP|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/4565] [original link is broken] [original link is broken] [original link is broken];

[ABAP API for SAP NetWeaver Master Data Management - Webinar Powerpoint|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/601ddb01-e5c8-2910-d981-b190b51fca44]

[How to Configure Master Data Management ABAP Application Program Interface - Part 1|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e03247a3-2f2a-2b10-4987-a2d8b2ce2893]

[Working with SAP MDM Java API's|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70a7afe4-9e3e-2b10-de8d-b105d0b8c79e]

[Retrieving Data from MDM Using Java API - Part One|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/421718aa-0501-0010-d3b0-de6b02aa269b]

[How to Use the Master Data Management Java API for MDM SP05 Patch 2 (NW7.0)|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0eb1f75-136d-2a10-99b2-ea60f1dee9e8]

[SAP Network Blog: Getting Insight in the New MDM Java API|/people/markus.ganser/blog/2008/05/06/getting-insight-in-the-new-mdm-java-api]

[Using the SAP NetWeaver MDM 5.5 SP4 Web Service to Search the MDM Repository|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/30a97ac6-c884-2910-c6ad-bae0de29e67b]

You can find more info be searching for 'MDM API for JAVA' or MDM API for ABAP'

praveen

[Former Member]

In case of MDM 7.1, MDM adapter can be used rather than using file adapter ( PI 7.0 and 7.1).

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/604b3c0c-5b6c-2b10-cc83-a7af75c7...

The SCAs with the adapter & XI/ESR Content with MDM Interfaces can be downloaded from Service Marketplace.

Liang

[Former Member]

We are in MDM 5.5. Is there no other way for this release? Can we do a Java module to write this to MQ? so that XI can pickup in JMS?

[Former Member]

Hi, Thanujja:

I never worked MDM integration, so I can answer you questions at the moment.

Based on common sense, I think you need to do performance turning first, to see your performance can be improved before seeking other options.

Secondly, if the load is just for the initial one time load, then rest of the load is just delta load, it should not create such a loading condition any more, this is another consideration before you seek other technical approach.

The other technical approach you mentioned like JMS queue, technically they all can be implemented, but you have to consider the additional layer of message processing et...

Regards.

Liang

[Former Member]

Liang,

Thanks for the reply..We started with one time full load mind only but now as there are more and more recepients are coming online, everytime we do a full load for any of them its somewhere between 10 to 12 hours..So we are exploring other options for the full load and if it is effective, we might as well use for delta loads too...

I am looking for more suggestions and any implementation successes with different options other than file..

THank you..

[Former Member]

Thanujja:

Have you consider using ABAP proxy, make your scenario as proxy -> xi -> downstream system ?

Liang

[Former Member]

ABAP proxy from MDM? How can you do that?