Upgrading from 8.0GA or 8.0u20210209

The update 8.0u20210520 of the Denodo Platform 8.0 released a new version of the Data Catalog with great improvements: a new user interface, recommendations of views and web services, collaboration between users, and more. This new version requires changes in its database that are not compatible with the database of previous versions.

If you were using the Data Catalog of the Denodo Platform 8.0GA or the update 8.0u20210209, take into account that installing the update 8.0u20210520 (or any posterior update) will install the new version of the Data Catalog and remove the old version. The new version will be configured to use the embedded Derby database, which will be initially empty.

To keep the data from the old version of the Data Catalog you have two options:

  1. Do not update the Denodo Platform of the Data Catalog. You can install the update in all the Denodo Platforms of your organization, except for the one you use for the Data Catalog. This way, you will continue to use the old version of the Data Catalog. Since the Virtual DataPort servers keep backward compatibility with other products, within the same release, the old version of the Data Catalog will be able to connect to updated versions of the Virtual DataPort.

  2. Install the update and migrate your data. To preserve the metadata and the queries saved by the users of the previous version Data Catalog, you should export both of them before installing the update, and import them in the new version after installing the update. The following sections explain in detail how to proceed.

Preparation Tasks Before Installing the Update

  1. Connect to the Data Catalog with an administrator user before installing the update.

  2. Export the metadata of the Data Catalog.

    1. Go to Administration > Import / Export > Export.

    2. Select all the settings you want to preserve.

    3. Click on the Export button.

  3. Export the saved queries of the Data Catalog.

    1. Go to My Queries.

    2. Export the queries saved by all users by clicking on the export-queries icon next to the label Import/Export All Users Queries.

    3. Click on the Export button.

Migration Tasks After Installing the Update

  1. Connect to the Data Catalog with an administrator user after installing the update.

  2. If you were using an external database you should create a new database and configure the new Data Catalog to use it. You cannot use the same database as the previous version because the schema has changed.

  3. Import the metadata of the previous Data Catalog.

    1. Go to Administration > Import / Export > Import.

    2. Drag and drop the file with the metadata exported from the previous Data Catalog.

    3. Click on the Import button.

  4. Import the saved queries of the previous Data Catalog.

    1. Go to My Queries.

    2. Import the queries saved by all users by clicking on the Import all users queries button.

    3. Drag and drop the file with the saved queries exported from the previous Data Catalog.

    4. Click on the Import button.

How to Recover your Data from the Previous Data Catalog if You Have Already Installed the Update

If you have installed the update without exporting the metadata and/or the queries saved by the users from the previous version Data Catalog, you can still recover them.

If you were using the embedded Derby database:

  1. Find a backup of the database in the folder <DENODO_HOME>/metadata/data-catalog-database_back.

  2. Install the Denodo Platform 8.0 in another folder. Optionally, you can apply to it the update 8.0u20210209.

  3. Replace the folder <DENODO_HOME>/metadata/data-catalog-database of that new installation with the backup folder mentioned previously.

  4. Start the Data Catalog.

  5. Export the metadata and/or the saved queries as explained in Preparation Tasks Before Installing the Update.

If you were using an external database:

  1. Install the Denodo Platform 8.0 in another folder. Optionally, you can apply to it the update 8.0u20210209.

  2. Start the Data Catalog.

  3. Configure it to point to the external database where the metadata were stored.

  4. Export the metadata and/or the saved queries as explained in Preparation Tasks Before Installing the Update.

Once you have recovered your metadata and/or saved queries from the previous version, you should import them in the new Data Catalog. Follow the steps in Migration Tasks After Installing the Update.