Outline of the Migration Process

This document lists the steps of a successful migration to Denodo 7.0.

Note

If you are migrating from Denodo 5.5 or earlier, you cannot migrate to Denodo 7.0 directly. See below Migrating from Denodo 5.5 or Earlier.

The upgrade process has four main steps:

  1. Install Denodo Platform 7.0 on a new location.

    We will refer to the platform that has just been installed as new version, installed at <NEW_DENODO_HOME>.

  2. Export all metadata from your current Denodo Platform installation.

    We will refer to the previously installed version of the Denodo Platform as the current version, installed at <OLD_DENODO_HOME>.

  3. Import the metadata from the “old” version to the new one.

  4. Configure the new Denodo Platform.

Note

We strongly recommend migrating and testing the non-production environments before the production environments.

Note

If you are going to upgrade from Denodo 5.0 or earlier, contact the Denodo Support Team.

Migrating from Denodo 5.5 or Earlier

To migrate the metadata of Virtual DataPort version 5.5 or earlier into version 7.0, you cannot import the VQL file of version 5.5 into 7.0, directly. You have to “go through” Virtual DataPort 6.0. This is because, among other things, several VQL statements of Denodo 5.5 are not supported by Denodo 7.0. Denodo 6.0 does support them and the VQL it generates is compatible with Denodo 7.0.

In this scenario, follow these steps:

  1. Install a Denodo 6.0 server and its latest update.
  2. Follow the steps of the following sections of the Migration Guide version 6.0, to export the metadata from the Virtual DataPort server version 5.5 or earlier:
    1. Export the Metadata of the Current Installation
    2. Modify the Virtual DataPort Metadata
    3. Import the Metadata to the New Installation
  3. Install a Denodo 7.0 server and its latest update.
  4. Follow the steps of this Migration Guide to export the metadata from Virtual DataPort 6.0 into Virtual DataPort 7.0.