MDM Console Table and Field Creation

[Former Member]

Hi,

Is there a way to automate or fast track creation of tables with MDM Server? Instead of creating each table with many fields one by one, manually.

Can we use XML to create many at once within a repository?

Or if I have few tables in MS Access, How can I recreate these tables in MDM quickly?

[Former Member · Accepted solution]

Hello:

Right now on MDM SP04 you can import XML as a repository structure, instead of manually creating the tables/fields.

Importing the structures from other forms (such as MS Access) is not possible by standard.

We do have the Java API, which allows you to manipulate MDM. It should be possible to write an small Java routine to read the structure from somewhere, and then recreate it on MDM

I hope that helps

Alejandro

[Former Member · Accepted solution]

Hi Alejandro ,

For a Master Data Management Tool, to have such a poor Data Modelling environment is really absurd. It is so frustrating, again a simple tool like MS Access beats MDM hands down.

What's the point in having good analysis abilities when it takes ages to create the analysis environment and also any changes to the data model makes a huge impact to the rest of the MDM process.

So you are saying that within the MDM Console I have to manually create all my tables and fields. There isn't any copy and paste functionality to speed things up either.

Any ideas to speed creation of Tables and fields would be really really appreciated.

ciao,

[Former Member · Accepted solution]

Ray,

Could you give a concrete example of where you would like to "copy and paste" from? MDM is a sophisticated data management tool, which uses standard relational databases as its data store (MS SQL, Oracle, etc.). It is not, in itself, a standalone database, nor is it meant to replace standalone databases in functionality. So comparisons with MS Access, Excel, etc., are not to the point.

As Alejandro pointed out, you can export the structure of an existing MDM repostitory, and create a new repository based on that schema by using the <b>Export/Import Repository Schema</b> functions in the MDM Console.

Regards,

Walter

[Former Member · Accepted solution]

Walter

At the moment I have bunch of data in excel sheets coming from 3 different sources, I am trying to load the data in MDM so I can use MDM as the data source for the 3 files. And I am using MS SQL as the database for the repository. Each of these excel files have 70 columns, now it is painful trying to recreate these in 3 separate tables in MDM. A very long manual process. Is there a way to do this quickly, XML perhaps.

Ultimately, I will be comparing the data records between these 3 tables, and the result of the analysis will then again be pushed out as an excel file.

Is there a much better way of doing this?

[Former Member · Accepted solution]

Hi Ray,

I don't fully understand the role of MDM in your scenario. Nevertheless, at present MDM does not have built-in functionality for building schema from external sources (other than another MDM schema which was exported via the Export Schema menu item in the Console).

However, once you do have a schema, MDM can import data into the repository from a number of sources (including Excel and Access) via the MDM Import Manager.

Walter