Data Model Exporting - MDM to Erwin or another data model tool

[Former Member]

I would like to export the latest MDM physical data model in production to any erwin modelling tool or any othe data modelling tool

[Former Member · Accepted solution]

To export the schema of an MDM repository to an XML file:

1. In the Console Hierarchy tree, right-click on the MDM repository whose schema you want to export and choose Export Repository Schema from the context menu, or select the tree node and choose Repositories ® Export Schema from the main menu.

If the top-right pane is currently displaying the list of MDM repositories, you can also right-click on the repository in the grid and choose Export Schema from the context menu.

2. Click Save to close the dialog and export the schema.

Schema files are stored in XML format in a user-defined location using a user-defined filename. The file contains the schema definition only; no table or field content.

http://help.sap.com/saphelp_mdm550/helpdata/en/f2/2f21039e9146098e7b238f1a4c8e5e/content.htm

Thanks,

Shambhu.

[Former Member]

HI Subin,

As discussed in above post you can get the schema in your desired location and use xml schema in other tools.

Just a curious question,are you trying to compare Data model or generate DDL script?

Thanks,

Ravi

[Former Member]

Appreciate your replies.

We are trying to make the erwin data model in sync with latest MDM data model in production. I would like to use the mdm data model xml to update the Erwin model.

Is it possible to update Erwin using that xml?