Manually moving system objects from an XML database to a relational database - 6.1

Talend MDM Platform Migration Guide

EnrichVersion
6.1
EnrichProdName
Talend MDM Platform
task
Installation and Upgrade
EnrichPlatform
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend DQ Portal
Talend ESB
Talend Identity Management
Talend Installer
Talend JobServer
Talend Log Server
Talend MDM Server
Talend MDM Web UI
Talend Project Audit
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio

Prerequisites: You can carry out this operation with both MDM servers up and running provided you have a connection to each of them in the Server Explorer panel in Talend Studio, or you can perform the export operation from the server with the XML database, stop this server, start up the server with the relational database and complete the import operation. Also note that if you want to migrate from 5.6.1 or 5.6.2 to 6.0.1 or later, you have to install a patch. To obtain this patch, contact Talend support.

Warning

If you need to migrate between two databases on a single machine, you must run the two MDM servers side by side. You can do this by setting a different port binding on the target server.

For further information about running multiple instances of Tomcat on the same machine, see Talend Installation Guide.

To manually move your system objects, including the definitions of your Views, Triggers, Processes, the AUTO_INC counter and the MDM users, from an existing XML database to a relational database, you need to export the following system containers from your existing installation and reimport them in your new installation:

  • System/CONF: AUTO_INCREMENT counters

  • System/PROVISIONING: MDM users

  • System/SearchTemplate: saved searches and hierarchies.

Warning

Before performing this procedure, make sure you process the ACTIVE and FAILED queue, since the migration procedure will cause ACTIVE, FAILED and COMPLETED queues to be lost.

To export these system containers, do the following:

  1. In the MDM Repository tree view of Talend Studio that is connected to the server with the XML database, click the Import Server Objects from MDM button in the repository icon bar.

  2. In the [Import Server Objects from MDM Server] window that opens, click the [...] button to specify the server from which you want to import the system containers.

  3. Click the Deselect all button, expand Data Container > System, and select the CONF, PROVISIONING and SearchTemplate containers, and then click Finish to import these containers into your repository.

  4. In the MDM Repository tree view of Talend Studio, expand Data Container and System, right-click the CONF container, and then click Export content from MDM Server.

  5. Specify the server from which you want to perform the export action.

  6. Browse to the location where you want to export the container, provide a file name for your .zip file, and then click Save.

  7. Repeat the above steps for the two other containers, PROVISIONING and SearchTemplate.

  8. In the MDM Repository tree view of Talend Studio that is connected to the server with the relational database, expand Data Container and System, right-click the CONF container, and then click Import content to MDM Server.

  9. Browse to the location where you saved the .zip file containing your system containers, select the file you want to import, and then click Open.

  10. Repeat the above steps for the two other containers, PROVISIONING and SearchTemplate.