Upgrading from Denodo 7.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 7.0, including the Solution Manager.

To simplify the upgrade from Denodo 7.0 to Denodo 9, consider this:

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

• Install Denodo 8.0 in the same computer where you are going to run Denodo 9. Once you complete the upgrade to 9, remove the installation of Denodo 8.0 because you are not going to use it; it is only necessary to complete the upgrade. Note that you cannot start both versions at the same time but you do not need to for the upgrade.

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 JDBC drivers used by data sources and that are not included in the Denodo Platform. For example, if you have a Teradata data source, which requires the Teradata driver, the VQL file will include the Teradata driver itself so you do not have to copy it to the new installation.

   • The DenodoConnect components and other extensions you imported using the menu File > Extension management of the Administration Tool.

   • 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. Open the Administration Tool of Virtual DataPort 7.0 and log in 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 7.0 is installed, and execute this from the command line:

   • On Windows:

     cd <DENODO_HOME_7_0>
     cd bin
     export.bat --login "<user name>" --file resources_denodo.vql --server "localhost:9999" -P includeJars=yes -P replaceExistingElements=yes
     

   • On Linux:

     cd <DENODO_HOME_7_0>
     cd bin
     ./export.sh --login '<user name>' --file resources_denodo.vql --server 'localhost:9999' -P includeJars=yes -P replaceExistingElements=yes
     

   In this command, replace <user name> with the user name of an administrator user. This command will prompt for your password.

   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_7_0>
     cd bin
     .\export.bat --login "<user name>" --file metadata_denodo.vql --server "localhost:9999" -P cluster=yes -P includeStatistics=yes -P includeDeployments=yes -P replaceExistingElements=yes
     

   • On Linux:

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

   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 8.0 - 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 7.0 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. Edit the file <DENODO_HOME_7_0>/resources/apache-tomcat/webapps/denodo-data-catalog/WEB-INF/classes/ConfigurationParameters.properties and add the following line:

   com.denodo.exportMigrationCompatibility=true
   

9. Restart Data Catalog

10. Log in to Data Catalog 7.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.

11. Edit the file <DENODO_HOME_7_0>/resources/apache-tomcat/webapps/denodo-data-catalog/WEB-INF/classes/ConfigurationParameters.properties and remove the line

    com.denodo.exportMigrationCompatibility=true
    

12. Restart Data Catalog

Scheduler and Scheduler Index

13. Edit the file <DENODO_HOME_7_0>/conf/scheduler/ConfigurationParameters.properties and add the following line:

    com.denodo.exportMigrationCompatibility=true
    

14. Edit the file <DENODO_HOME_7_0>/conf/arn-index/ConfigurationParameters.properties and add the following line:

    com.denodo.exportMigrationCompatibility=true
    

15. Restart Scheduler and Scheduler Index.

16. Log in to Scheduler 7.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.

17. Connect to the computer where the Denodo Platform 7.0 is installed, and execute this:

    • On Windows:

      cd <DENODO_HOME_7_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_7_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 7.0.

18. Stop Scheduler and Scheduler Index.

19. Remove the line

    com.denodo.exportMigrationCompatibility=true
    

    from these files:

    • <DENODO_HOME_7_0>/conf/scheduler/ConfigurationParameters.properties

    • <DENODO_HOME_7_0>/conf/arn-index/ConfigurationParameters.properties.

20. Start Scheduler and Scheduler Index.

Solution Manager

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

22. Select Generate the export file to migrate to the Denodo 8.0 and click Ok.

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

23. Follow the steps of these pages of the Upgrade Guide of Denodo 8.0: Review the Virtual DataPort Metadata and Import Settings and Metadata in to the New Installation.

24. Once you do this, continue with the following stage of the upgrade: Upgrading from Denodo 8.0: Export the Settings and Metadata of the Current Installation.