Data extraction from MDM

[former_member954801]

Hi Experts,

I would like to extract all the data available in MDM data manager, includes tuple data for verification purpose. What are the possible ways I can do this?

- Export to Excel in MDM (doesn't supports tuple data) - correct?

- Directly from Oracle database

- Any other possibilities.

Also I would like to get tuple data, each filed in separate column.

Thanks,

Bob

[former_member954801]

Thanks for all your comments.

Bob

[former_member198938]

I would suggest syndication of data in notepad flat file to your local machine.This is much faster then exporting your data to excel from data manager and also using data manager not many records can be extracted in one go...server may stop responding.....

[Former Member]

if u extract data in excel for verification process - that may not be a wise idea !

why dont u use a tool meant for the job - like for verfication - some Data Quality tools / BoBJ DS / Enrichment Controller framework ? - then you could probably use the EC adapters to pull data for verification / profiling !

hth

thanks

-Adrivit

[cweissheimer]

Consider using the Syndication as Lucas suggested.

However, refer to the MDM Syndicator Reference Guide, available at:

http://help.sap.com/saphelp_nwmdm71/helpdata/en/4b/711def8a722593e10000000a42189b/content.htm

BR,

Carlos

[Former Member]

You can perform syndication to extract the data from the MDM or use the MDM Java/.NET API to access the data using an external custom application. For more information about both, check the help pages below

http://help.sap.com/javadocs/MDM71/syndication.html

http://help.sap.com/saphelp_nwmdm71/helpdata/en/13/041975d8ce4d4287d5205816ea955a/content.htm