Migrating from Talend Data Preparation 1.X/2.0 installed with an embedded MongoDB - 6.4

Talend Data Management Platform Migration Guide

EnrichVersion
6.4
EnrichProdName
Talend Data Management Platform
task
Installation and Upgrade
EnrichPlatform
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend DQ Portal
Talend Installer
Talend JobServer
Talend Log Server
Talend Project Audit
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio

Warning

If you have installed and used Talend Dictionary Service to create custom semantic types or update the predefined ones, you must migrate Talend Dictionary Service before migrating Talend Data Preparation. See Migrating from Talend Dictionary Service version 6.3.x to 6.4.x.

Before you begin:

  • You have downloaded Talend Data Preparation 2.1.

  • You have stopped Talend Data Preparation 1.X/2.0.

  1. Install Talend Data Preparation 2.1 with the embedded MongoDB, and do not start the instance.

    For more information about the Talend Data Preparation installation and configuration procedures, see the Talend Installation Guide.

    If you have installed Talend Data Preparation 2.1 in service mode, stop the instance and MongoDB and delete the database as follows:

    1. Open a mongo shell as Talend Data Preparation database user and execute the following commands:

      cd <install_dir>/mongodb/bin

      ./mongo dataprep -u dataprep-user -p dprep --port 27017

    2. Switch to Talend Data Preparation database:

      use dataprep

    3. Drop the database:

      db.runCommand( { dropDatabase: 1 } )

    4. Exit mongo shell:

      exit

  2. Start Talend Data Preparation version 2.1.

  3. Stop Talend Data Preparation version 2.1.

    These two steps are necessary for the migration process to work.

  4. If you have performed any custom configuration to the 1.X/2.0 version of the <Data_Preparation_Path>/config/application.properties file, you can port them to the 2.1 version of the file.

  5. To retrieve the content of the dataset storage folder used for Talend Data Preparation 1.X/2.0, and migrate it to version 2.1, complete the next step according to the your situation:

    • If you have never modified the value of the dataset.content.store.file.location property, copy the content of the <Data_Preparation_Path>\data\store\datasets\content folder used in 1.X/2.0, and paste it in the 2.1 installation folder, following the same path.

    • If you have set a custom value for the dataset.content.store.file.location property, make sure that you set the same value in the application.properties file for the 2.1 version.

  6. Start the MongoDB instance of Talend Data Preparation 1.X/2.0.

  7. Back up the MongoDB instance used for Talend Data Preparation 1.X/2.0.

    To backup your MongoDB, open a command prompt window and execute the following command:

    mongodump -h <source_mongodb_host>:<source_mongo_port> -d <source_database> -u <source_mongodb_user> -p <source_mongodb_password> -o <dump_output>

    The default value for the embedded MongoDB properties are the following:

    Table 3. 

    PropertyValue
    mongodb.hostlocalhost
    mongodb.port27017
    mongodb.databasedataprep
    mongodb.userdataprep-user
    mongodb.passworddprep

  8. Stop MongoDB of Talend Data Preparation 1.X/2.0 and start MongoDB of the 2.1 version.

  9. Drop the database of the Talend Data Preparation 2.1 MongoDB.

    1. Open a mongo shell as Talend Data Preparation database user and execute the following commands:

      cd <install_dir>/mongodb/bin

      ./mongo dataprep -u dataprep-user -p dprep --port 27017

    2. Switch to Talend Data Preparation database:

      use dataprep

    3. Drop the database:

      db.runCommand( { dropDatabase: 1 } )

    4. Exit mongo shell:

      exit

  10. Restore the backup performed on the 1.X/2.0 MongoDB, on the 2.1 MongoDB instance.

    To restore your MongoDB, open a command prompt window and execute the following command:

    <mongo_path>/bin/mongorestore -h <mongo_host>:<mongo_port> -u <mongo_tdp_username> -p <mongo_tdp_password> -d <mongo_tdp_database> <backup_location>

  11. Start Talend Data Preparation 2.1.

You are now ready to use Talend Data Preparation 2.1.