Import the Metadata to the New Installation

Follow the steps of this section to import the metadata of the previous installation to the new one.

  1. Stop all the servers and tools of the current installation.

  2. Start all the servers of the new Denodo Platform 6.0.

  3. Copy the external classes and libraries that you added to the directory <OLD_DENODO_HOME>/extensions/thirdparty/lib to <DENODO_HOME_6_0>/extensions/thirdparty/lib.

    Do not copy the following files to the new installation:

    • denodo-vdp-jdbcdriver-basic.jar
    • derbyclient-*.jar
    • jtds-*.jar
    • ojdbc14-10.2.0.3.jar
    • oracle-driver-*.jar
    • postgresql-*.jar

    The installer of the previous version of Denodo copied these files to that folder. Copying them to the Denodo 6.0 installation will cause interoperability problems.

    Some of the files of this list may not exist depending on the version of Denodo you are upgrading.

  4. Import the metadata to Virtual DataPort and IT Pilot’s Wrapper server. There are two options to do this. Both are equivalent so you can use the most convenient to you:

    1. Using the import script of the new installation. To do this, open a command line and execute the following:
cd <DENODO_HOME_6_0>/bin
import --file export.vql --server //localhost:9999/admin?<administrator user>@<password> --singleuser
  1. Or, using the File > Import wizard of the Virtual DataPort Administration tool.

The section Exporting and Importing the Server Metadata of the Virtual DataPort Administrator Guide provides more details about how to use the import script and the “File > Import” wizard.

  1. Import the metadata to ITPilot Wrapper Generation Tool: use the File > Import feature of the Wrapper Generation Tool. In this dialog, select the file exported in the step 6 of section Export the Metadata of the Current Installation.

    Read the section Migrating Wrappers Between Generation Environments: Import and Export of the ITPilot Generation Environment Guide for more information about this step.

  2. Import the metadata to Scheduler: use the import script located in <DENODO_HOME_6_0>/tools/scheduler.

    Read the section Use of the import/export scripts for backup of the Scheduler Administrator Guide for more information about this.

  3. Import the metadata to Aracne: use the import script located in <DENODO_HOME_6_0>/tools/arn-index.

    Read the section Use of the import/export scripts for backup of the Aracne Administrator Guide for more information about this step.