How to Import a complex data structure from client system ???

[Former Member]

Hello

Defining a new Repository, imagine that we have two client systems which have complex data structure (more than 40 tables, relationships, etc…).We need to consolidate, and globalize those clients data in MDM. We know that is important to structure the new repository which will contain those data.

How to proceed?

• . Do MDM offer some features in order to copy the Schemas of those client systems into MDM?

• . Do we have to create the structure (tables, relationships…) one by one before importing and manage those clients’ data?

• . We understand that the XML SCHEMAS table allows saving an XML structure for import and syndication. When/how can I use this .xsd file .Is it the XML SCHEMA of a Client System ?

[Former Member]

Hi Stan,

You can create a new Repository if you have an proper xml file.

To have a look at proper xml file you can first go to Console and right click on any repository and then Select <b>Export Repository Schema</b> from the context menu.

Have a look at this file and then create your own xml file as per your requirements.

Now Perform the following steps:

<b>Step1.</b> Select MDM Server Right Click and select <b>Create Repository</b>.Specify the necessary credentials.

<b>Step2.</b>Then right click on the newly created repository and select <b>Import Repository Schema</b> and specify the name of the xml file containing the schema.

Let me know the result.

<b>Mark Helpful Answers</b>

Thanks and Regards,

<b>Sagar Sonje</b>

[Former Member]

MDM does NOT offer features to copy the Schemas of the client systems into MDM Console.

You have to create the tables, relationships one by one manually, before importing data from those client systems.

XML schmas table in Console is for saving the Schemas for Import and Export of data. This cannot be used for creating the tables, relationships etc in Console.

Ex:

If you will be syndicating data to a client system, and the map is not going to change, it makes sense to save the map for future syndication to the same client.

You can use the Port Concept of MDM and automate the exchange of data between MDM and the Client System.

Hope this helps,