Data retrieval from MDM 5.5 using Java API

[Former Member]

Hi,

Does anyone have a sample Java code snippet that can be called via XI to retrieve data from a repository in MDM 5.5 ?

Cheers

Colin.

[Former Member · Accepted solution]

Colin,

If you want the Release note, send me a mail.

Regards,

Ravi

[Former Member]

Colin,

What exactly do you want to do?

If you want to retrieve data from MDM, you need to have Java application call the API's provided.

Where is XI coming into picture?

Other way of doing it is to develop a web service and call that via XI and send the data.

Here is quick snippet to get some data.

Sample code for FreeForm search:

SearchParameters sparam = search.GetParameters ();

FreeFormTableParameter fftParam =

sparam.NewFreeFormTableParameter(ProductsTable);

FreeFormParameterField ffParamField =

fftParam.GetFields().New(PartNumberField);

ffParamField.GetValues().NewString(

partNoValue,FreeFormParameter.PrefixSearchType);

search.Add(fftParam);

Regards,

Ravi

Note : Please reward the posts that help you.

[Former Member]

Hi,

The scenario is this :

Agent is logged into CRM - Web client. They wish to check customer details that are not held in CRM but are held on the master MDM record. So they click on a button which does a sync call from CRM sending to XI via an ABAP proxy and the receiver is a Java proxy which invokes the search in MDM and sends a response back to XI and finally back to CRM.

The reason we are using XI is the monitoring etc provided by XI. We could just call the Java API direct from CRM but the user requires traceability etc that XI provides.

Does this make sense to you ?

Kind regards

Colin.

[Former Member]

Colin,

This situation is little tricky, atlease till the time SAP releases SP04. We are expecting some web services to come as a part of SP04.

Till then, all we have are the Java API's exposed. So, what we will have to do is wrap these API's in a web servce and host these Web Service on a J2EE engine or even SAP WAS. Once this is done, XI can interact with MDM using these Web Services.

I am not aware of any other way.

Let me know if you find any.

Regards,

Ravi

Note : Please reward the helpful posts.

[Former Member]

Colin,

I was thining while i was travelling over the weekend and what I remembered was that SAP has not only Java and COM API's, they also have some ABAP API's. However, these are not for general release and I read that they are project specific.

So, if you can approach SAP and ask them for ABAP API's that might make your job very easy as you can call the RFC's directly from XI.

Regards,

Ravi

Note : Please reward the helpful posts.

[Former Member]

Hi,

The official documentation does not mention ABAP APIs only Java & COM.

However this has given me food for thought to approach SAP with.

Thanks

Colin.

[Former Member]

Colin,

Did you look into the release notes of SP03? Here is copied statement from the same.

ABAP APIs

Starting with this support package, it will be possible to access MDM repositories directly from ABAP. The enhancement is included in Web AS Kernel 6.40 and in the MDM ABAP Add-On. The ABAP API is only available on a project basis.

Regards,

Ravi

Note : Please mark as helpful answers if they have helped you.

Message was edited by: Ravikumar Allampallam

[thomas_jung]

The OSS Note with details about the ABAP APIs is: 903387. They are not generally released, and therefore subject to undergo no-compatible changes in the next support package. There is a PDF attached to the OSS note with documentation about the APIs.

[Former Member]

Ravi,

Your code is very mush helpful.

I have a business scenario like...

I have 3 diff fields in a table eg SKU,NAME,STATUS

I need to search a text "abc" in SKU and NAME field with STATUS Active.

I mean text to be search must be either in SKU or NAME field .

Search should be like

(SKU OR NAME)AND (STATUS="Active")

Can you help me reg that?

Thanks,

Amar

[Former Member]

Hi Amar,

Check this weblog. Very nice blog and descriptive information about FreeFormSearch in MDM using Java API.

/people/andreas.seifried/blog/2006/03/26/performing-free-form-searches-with-mdm-java-api

Hope this helps.

Thanks and Regards

Subbu

[Former Member]

Hi Subbu,

Thanks for helping.Its a good article.But it do't solve my problem.In this either

we can search on a single field like

(FIND(Name,"Contractor")OR FIND(Name, "Blade"))AND FIND (Name,"Standard").

OR for diff fields ,we can use only one operator AND/OR.

I need to search for Diff fields with And/OR like

(SKU OR NAME)AND STATUS

Thanks,

Amar

[Former Member]

(FIND(SKU,"abc")OR FIND(NAME, "abc"))AND FIND (STATUS,"Active").

would this work?