Changing column names in Kalido MDM 8.5

Kalido MDM introduced the functionality of ODBC loaders in their new release of their MDM product. Now the data can be loaded from the staging tables itself, which makes Kalido MDM a complete MDM tool.

But when we create the staging tables in MDM, and save the staging tables, we are stuck with it. We cannot go back and change the column names in the tables or do any modification in the staging tables. The only way to edit the staging tables is to drop the staging tables and re-create it from the scratch which is a process in most of the cases.

A better way to change the column names in the staging tables for MDM, is to export the whole model into an XML(which is done using MDM tool itself) and then modify that XML file and change the column names as required. Once editing the XML file is done, we can import the file back into the MDM tool and it would have the new column names and also it would contain any structural changes we have made to the MDM model.

The only disadvantage for this process would be: it requires the knowledge of XML file, which the MDM model would be exported.

Remember: Always take a back Up of the original XML file...

This is one of the way we can change the column names in MDM staging tables.

Kalido DIW 8.5

I was creating a new warehouse using Kalido and this warehouse was created on UNIX Database server. Now when we create a new warehouse Kalido gives an option of loading the initial data for TIME, Unit of Measure and Currency. I chose an option not to load the data, as i can always come back and reload the data.

But to my surprise there is no opion of coming back and reloading the data. Ideally there should be an option of coming back to the tool and reloading the data(Time,UOM and Currency). But to my surprise there is no such magic button.

The other option is always to generate the scripts and to re-run the scripts manually. But just in case if the scripts are not generated; we have to re-create the warehouse from the scratch.

Just Sharing my learning experiences...