Upgrading the administration database - 8.0

Talend Migration and Upgrade Guide

Version
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend ESB
Talend Identity and Access Management
Talend JobServer
Talend LogServer
Talend MDM Server
Talend MDM Web UI
Talend Runtime
Talend SAP RFC Server
Talend Studio
Content
Installation and Upgrade
Last publication date
2024-03-06

This section describes how to upgrade the Talend Administration Center database. Note you can skip the database backup, for data security reasons or other important circumstances.

Warning: Skipping the backup may lead to database loss if migration fails. Only skip the backup for necessary reasons.

The source and target databases must be of the same type. To migrate from a database X to a database Y, for example from H2 to MySQL, first see Backing up the administration database.

Before you begin

  • Back up your database.

  • Make sure the drivers of the databases are installed on the machine where the migration is performed.

Procedure

  1. Stop the Apache Tomcat server.
  2. To avoid errors during the migration process, increase the memory of Tomcat.
  3. Delete the old Talend Administration Center application .war file and/or the org.talend.administrator folder in <TomcatPath>/webapps to undeploy it.
  4. Delete the <TomcatPath>/work directory to empty Apache Tomcat cache.
  5. Download the new Talend-AdministrationCenter-YYYYMMDD_HHmm-VA.B.C.zip from the link listed in your license email.
  6. Unzip Talend-AdministrationCenter-YYYYMMDD_HHmm-VA.B.C.zip.
    This will give you access to the different components needed to benefit from all the Talend Administration Center capabilities:
    • org.talend.administrator.war, the archive containing the actual Talend Administration Center Web application.

    • Artifact-Repository-Nexus-VA.B.C.D.zip, the archive containing an artifact repository software, based on Sonatype Nexus, that will be used to handle software updates, DI artifacts and also ESB artifacts.

    • Artifact-Repository-Artifactory.zip, the archive containing Talend scripts to initialize users in the artifact repository, that will be used to handle software updates, DI artifacts and also ESB artifacts.

  7. Copy the Web application, org.talend.administrator.war, into the webapps directory of Tomcat.
    Once you have copied this war file, you can either unzip it manually under the same directory, or let Tomcat unzip the web application at startup.
  8. Start Apache Tomcat.
  9. Open a Web browser and type in the application URL. The database configuration page opens and a message indicates that the database version needs to be updated.
  10. Click Proceed migration to start the migration process. A dialog box opens:
  11. In the backup settings area, check your database connection information and enter the path to your folder where the backed up database will be stored in the Dump Path field.
    The command used to migrate the database can be updated according to your needs. If you are migrating an Oracle database from an earlier version of the Talend Administration Center to the latest version of Talend Administration Center, make sure the -Dtalend.schema=<schemaName> parameter is present in the migration command.
    Select skip backup if you do not want to perform the backup. A confirmation message is displayed.
    Warning: Only skip the backup for necessary reasons.
  12. Click Proceed to start the database backup and migration operation.
  13. When the message Database migration completed successfully shows, click Finish.
    The database is migrated and a .zip file holding the backed up database is created in the folder you have defined previously.
  14. On the database configuration page, set your new license then log in the Web application. The database migration process is finished.