Upgrading from Denodo 8.0: Export the Settings and Metadata of the Current Installation¶

This section explains how to export the settings and metadata of each module of the Denodo Platform 8.0, including the Solution Manager.

If you do not use a module, you do not need to export its metadata and settings.

Virtual DataPort

When exporting the metadata and settings of Virtual DataPort, you are going to obtain two files:

1. The metadata file. This file contains the CREATE commands for the data sources, views, web services, etc.; the commands to change the settings, etc.

2. The resources file. This is a file that contains the “resources” of Virtual DataPort. That is:

   • The DenodoConnect components, JDBC Drivers and other extensions you imported using the menu File > Extension management of Design Studio.

   • If you enabled Kerberos, the keytab file and the krb5 file.

   • If you imported the SAP Java Connector (JcO), it will also be included within this file.

   • Other resources like these.

   This file includes these resources encoded in Base64.

   To upgrade to previous versions of Denodo, you had to manually copy the drivers that were not included with Denodo, to the new installation. By generating the resources file, the process of upgrading to Denodo 9 is easier.

1. Log in to Design Studio 8.0 with an administrator account.

2. Execute this from the VQL Shell:

   SET 'com.denodo.exportMigrationCompatibility' = 'true';
   SET 'com.denodo.exportOnlyResourcesAndJars' = 'true';
   

   You do not need to restart to apply this change.

3. Connect to the computer where the Denodo Platform 8.0 is installed, and execute this from the command line:

   • On Windows:

     cd <DENODO_HOME_8_0>
     cd bin
     .\export.bat --login "<user name>" --metadatapassword "<metadata_password>" --server "localhost:9999" --file resources_denodo.vql -P includeJars=yes -P includeResources=yes -P includeScanners=yes -P includeCustomComponents=yes -P replaceExistingElements=yes
     

   • On Linux:

     cd <DENODO_HOME_8_0>
     cd bin
     ./export.sh --login '<user name>' --metadatapassword '<metadata_password>' --server 'localhost:9999' --file resources_denodo.vql -P includeJars=yes -P includeResources=yes -P includeScanners=yes -P includeCustomComponents=yes -P replaceExistingElements=yes
     

   In this command, replace this:

   • <user name> with your user name (an administrator account). This command will prompt for your password.

   • <metadata_password> with a password to encrypt the sensitive values. You can indicate the password encrypted to avoid entering it in plain text. To do this, use the script encrypt_password to obtain the encrypted password and prefix the value with encrypted.

   Important

   You must use the parameter --metadatapassword <metadata_password> to export. Without this parameter, the files obtained may not be compatible with Denodo 9.

   Write down this password; you will need it later, when importing this file in to Denodo 9.

   This script will generate the resources file (resources_denodo.vql) in the folder <DENODO_HOME>/bin. Copy this file to your computer.

4. Go back to the VQL Shell and execute this:

   SET 'com.denodo.exportOnlyResourcesAndJars' = NULL;
   SET 'com.denodo.vdb.catalog.exportMigrationCompatibilityIncludeResources' = 'false';
   

5. Execute this from the command line (note that the value of the parameter --file is different than in step #3):

   • On Windows:

     cd <DENODO_HOME_8_0>
     cd bin
     .\export.bat --login "<user name>" --metadatapassword "<metadata_password>" --server "localhost:9999" --file metadata_denodo.vql -P cluster=yes -P includeScanners=yes -P includeCustomComponents=yes -P includeStatistics=yes -P includeDeployments=yes -P replaceExistingElements=yes
     

   • On Linux:

     cd <DENODO_HOME_8_0>
     cd bin
     ./export.sh --login '<user name>' --metadatapassword '<metadata_password>' --server 'localhost:9999' --file metadata_denodo.vql -P cluster=yes -P includeScanners=yes -P includeCustomComponents=yes -P includeStatistics=yes -P includeDeployments=yes -P replaceExistingElements=yes
     

     Important

     You must use the parameter --metadatapassword to export. Without it, the files obtained may not be compatible with Denodo 9. You will need to enter this password later, when importing this file in Denodo 9.

   This script will generate the metadata file (metadata_denodo.vql) in the folder <DENODO_HOME>/bin. Copy this file to your computer.

6. If, after executing the script “export”, you see this message:

   MIGRATION TO 9 - WARNINGS SUMMARY
   

   Copy the messages that appear right below. You will need this information in the next step of the upgrade process.

   If you do not get this warning, this VQL file can be imported into Virtual DataPort 9 without modifying it.

7. Execute this from the VQL Shell:

   SET 'com.denodo.exportMigrationCompatibility' = NULL;
   SET 'com.denodo.exportOnlyResourcesAndJars' = NULL;
   SET 'com.denodo.vdb.catalog.exportMigrationCompatibilityIncludeResources' = NULL;
   

Data Catalog

8. Log in to Data Catalog 8.0 with an administrator account and export all. To do this, click the menu Administration > Import/Export > Export. In this dialog, select all the options.

Scheduler and Scheduler Index

9. Log in to Scheduler 8.0 with an administrator account and export all. To do this, go to Configuration > Server configuration and then, click Export. In this page, do this:

   1. Select all projects

   2. Select all the options.

10. Connect to the computer where the Denodo Platform 8.0 is installed, and execute this:

    • On Windows:

      cd <DENODO_HOME_8_0>
      cd tools\arn-index
      
      .\export.bat -h localhost -p 9000 -l "<user name>" -P "<password>" -f scheduler-index_upgrade.zip
      

    • On Linux:

      cd <DENODO_HOME_8_0>
      cd tools/arn-index
      
      ./export.sh -h localhost -p 9000 -l '<user name>' -P '<password>' -f scheduler-index_upgrade.zip
      

    In this command, replace <user name> and <password> with the credentials of an administrator user.

    This script will generate the file scheduler-index_upgrade.zip (folder <DENODO_HOME>/tools/arn-index). This file will contain the configuration and indexes of Scheduler Index. Copy this file to the computer where you installed Denodo Platform 9.

Solution Manager

11. Log in to embedded VDP server using Design Studio 8.0 with an administrator account.

12. Execute this from the VQL Shell:

    SET 'com.denodo.exportMigrationCompatibility' = 'true';
    

    You do not need to restart to apply this change.

13. Log in to Solution Manager with an administrator account. Then, right-click on the tree, on the left side, and click Export.

14. Go back to the VQL Shell and execute this:

    SET 'com.denodo.exportMigrationCompatibility' = NULL;
    

You will obtain a file that you will import later into Denodo 9.