Skip to main content Skip to complementary content

Migrating the database for Talend MDM Server (deprecated)

Availability-noteDeprecated
Information noteDeprecation: Talend Master Data Management (MDM) is deprecated and will reach end of life on December 31, 2024. For more information on migrating from Talend MDM, contact Qlik Professional Services.

Procedure

  1. Stop Talend MDM Server. For more information, see Cheatsheet: start and stop commands for Talend server modules.
  2. Remove the related database foreign keys. The foreign key names may vary with the Talend MDM Server version.
    MySQL
    alter table srcrecords drop foreign key FK3012B7DEF33FEA26;
    alter table tgtcolumns drop foreign key FKA373D85CF84CB18;
    alter table taskcollayout drop foreign key FK6B328CC5BA76F0CB;
    alter table tasklinelayout drop foreign key FK8707B763BA76F0CB;
    
    MSSQL
    alter table srcrecords drop constraint FK3012B7DEF33FEA26
    alter table tgtcolumns drop constraint FKA373D85CF84CB18
    alter table taskcollayout drop constraint FK6B328CC5BA76F0CB
    alter table tasklinelayout drop constraint FK8707B763BA76F0CB
    
    Oracle, DB2, Postgres
    alter table srcrecords drop constraint FK3012B7DEF33FEA26;
    alter table tgtcolumns drop constraint FKA373D85CF84CB18;
    alter table taskcollayout drop constraint FK6B328CC5BA76F0CB;
    alter table tasklinelayout drop constraint FK8707B763BA76F0CB;
  3. Restart Talend MDM Server.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!