Introduction
Welcome to Denodo 9! If you are currently using Denodo 8.0 and planning to upgrade, this guide will walk you through the essential steps to ensure a smooth transition. Whether you are a seasoned Denodo user or new to the platform, understanding the upgrade process is crucial to maintaining data integration efficiency and taking advantage of the latest features included in Denodo 9
Key Considerations
- Compatibility: Denodo 9 introduces new features, enhancements, and changes to existing functionality. While upgrading, keep in mind that some VQL statements generated by previous versions may not be directly importable into Denodo 9. Syntax errors could occur, so thorough testing is essential.
- Preparation: Before diving into the upgrade process, review the major steps involved. These include preparing your environment, addressing common tasks across modules, and ensuring compatibility with your existing setup.
- Post-Upgrade Tasks: Once Denodo 9 is up and running, there are additional configuration steps to perform. These tasks apply to all components and help optimize your deployment.
More information can be found in the Denodo Platform Upgrade Guide.
Remember, a well-executed upgrade ensures that your data virtualization environment remains robust, secure, and aligned with your organization’s needs.
Getting Ready
In this section, we list the preparation steps, hardware, and team required to start with the upgrade process.
Licensing
Requirement |
Comply (Y/N) |
Comments |
License for Denodo 9 |
|
A Denodo 9 license for the upgrade process can be requested from the Downloads > Licenses section of the Denodo Support Site. Denodo 9 installers will be available from the Denodo Support Site once the license is in place. This license file should be accessible from the Denodo Solution Manager Web Administration Tool for installation. |
Team Required
We would like to highlight that it is recommended to do the Upgrading to Denodo Platform 9 for Administrators training course to guarantee that the teams in charge of the upgrade have the required knowledge to execute a successful upgrade.
Requirement |
Comply (Y/N) |
Comments |
Denodo Platform Administration team |
|
Installing the latest Denodo Platform 8.0 and Denodo Solution Manager 8.0 updates before starting the upgrade is required. |
Active Directory Administration team |
If LDAP and/or Kerberos enabled |
|
Kerberos Administration team |
If Kerberos enabled |
|
Identity Provider Administration team |
If SSO using an Identity Provider is used |
|
Version Control System Administration team |
If the VCS is used in the Denodo Platform or the Denodo Solution Manager |
|
Database Administration team |
For the cache database For external metadata databases if used in any component |
|
Cloud Administration team |
If Denodo Platform or the Denodo Solution Manager are installed on the Cloud |
Hardware/Instances
Requirement |
Comply (Y/N) |
Comments |
New server for the Denodo Solution Manager 9 |
|
If the new installation is not performed on the same machine as Denodo Solution Manager 8.0 |
One new server for each Denodo Platform 9 instance |
If the new installation is not performed on the same machine as Denodo Platform 8.0 |
|
New schema or database for the cache database |
||
New schema or database for the Denodo Solution Manager external metadata database |
If an external database is used for the Denodo Solution Manager metadata |
|
New schema or database for the Denodo Platform external metadata database |
If an external database is used for the Denodo Platform metadata |
|
New schema or database for the Scheduler external metadata database |
If an external database is used for the Scheduler metadata |
|
New schema or database for the Data Catalog external metadata database |
If an external database is used for the Data Catalog metadata |
|
New repository for the Denodo Solution Manager Version Control System |
If a Version Control System is used the save the backup of deployments |
|
New repository for the Denodo Platform Version Control System |
If a Version Control System is used (in the Development environment) |
Cost considerations
If new cloud instances or on-premise servers are going to be created, the costs of those new instances or servers should be taken into consideration before starting the upgrading process.
Software
Requirement |
Comply (Y/N) |
Comments |
Installers for the Denodo Solution Manager 9 and Denodo Platform 9 |
Denodo 9 installers will be available from the Denodo Support Site once the Denodo 9 license for the upgrade is in place. |
|
External libraries that are not included in the VQL |
|
e.g. SAP JCo connector |
Denod Custom Extension developed in Java should be compatible with Java 17 |
Denodo Platform 9 uses Java 17 |
|
Denodo Connects for Denodo Platform 9 should be downloaded |
Despite the Denodo Connects are included in the VQL, they are for Denodo Platform 8.0, so it is recommended to download the ones for Denodo Platform 9 to update them |
Connections
Requirement |
Comply (Y/N) |
Comments |
Connections between Client applications and Denodo Platform 9 |
|
Connectivity to the new servers where Denodo 9 will be installed should be verified. Default Ports Used by the Denodo Platform Modules — Installation Guide |
Connections between Denodo Platform 9 and the cache database |
||
Connections between Denodo Platform 9 and external metadata database |
||
Connections between Scheduler 9 and external metadata database |
||
Connections between Data Catalog 9 and external metadata database |
||
Connections between Denodo Platform 9 and Version Control System repository |
||
Connections between Denodo Solution Manager 9 and Version Control System repository |
||
Connections between Denodo Solution Manager 9 and Denodo Platform 9 |
||
Connections between Denodo Solution Manager 9 and Scheduler 9 |
||
Connections between Denodo Solution Manager 9 and Data Catalog 9 |
Security
Requirement |
Comply (Y/N) |
Comments |
Create the user account with the right permissions to install the Denodo Solution Manager 9 |
|
|
Create the user account with the right permissions to install the Denodo Platform 9 |
||
SSL certificates are available |
Authentication
Requirement |
Comply (Y/N) |
Comments |
LDAP |
|
Get the parameters to execute the search of users and groups |
Kerberos |
Create the user account, create the Service Principal Name, and the keytab |
|
OAuth |
Configure OAuth in the Identity Provider |
|
SAML |
Configure SAML in the Identity Provider |
Timeline
The process of upgrading to the Denodo Platform 9 consists of six steps:
- In the current installation of the Denodo Platform and the Solution Manager, install the latest update.
- Install the Denodo Platform 9 and the Solution Manager 9 and install their latest update.
- In the new installation, change some settings. E.g. enable the cache if it was enabled in the previous version.
- Export the settings and metadata of all the components of the Denodo Platform, including the Solution Manager.
- Import the settings and metadata into the new version.
- Test the upgraded version.
Execution
Once we have all the requirements in place we can start with the execution of the upgrade.
Team Required
Requirement |
Comply (Y/N) |
Comments |
Denodo Platform 9.0 Administration Team |
Export the Denodo Platform 8.0 and Denodo Solution Manager 8.0 |
|
|
Install Denodo Platform 9.0, install Denodo Solution Manager 9.0, and install the latest update |
|
|
Install the Denodo 9.0 license file in the Denodo Solution Manager |
|
Connect to the new Denodo Platform 9.0 instances |
||
Import the export VQL to the Denodo Platform 9.0 |
||
Test the Denodo Platform 9.0 |
Security
Requirement |
Comply (Y/N) |
Comments |
Configure SSL in Denodo Solution Manager 9 and Denodo Platform 9 |
Authentication
Configure LDAP authentication |
|
Configure LDAP in Denodo Solution Manager and Denodo Platform |
Kerberos |
Configure Kerberos in Denodo Solution Manager and Denodo Platform |
|
Configure SSO in Denodo Solution Manager 9 and Denodo Platform 9 if required |
||
OAuth |
Configure OAuth in Denodo Solution Manager and Denodo Platform |
|
SAML |
Configure SAML in Denodo Solution Manager and Denodo Platform |
Go Live
Once Denodo 9 is installed and configured and the Denodo 8 metadata has been imported into the new Denodo 9 installation we are ready to complete the final steps of the upgrade process.
Team Required
Requirement |
Comply (Y/N) |
Comments |
Denodo Platform Administration team |
|
Start the Denodo Solution Manager 9 and the Denodo Platform 9 |
Denodo Platform Administration team |
Test the connection to the Denodo Platform 9 |
Testing
Once everything is in place and the new Denodo Platform 9.0 instances are up and running, executing tests against the new instances is strongly recommended.
You can review the Test the New Denodo Platform Installation section of the Denodo Platform Upgrade Guide.
Denodo provides the Denodo Testing Tool to easily automate the testing of the data.
For general testing recommendations see Testing in Denodo.
Also, execute performance tests can be performed using the Denodo Load Testing with Apache JMeter
Denodo services available to help in the process
Upgrade Assessment
- The Denodo Upgrade Assessment provides expert advice to current customers who are seeking to quickly, safely, and effectively upgrade their existing Denodo installation.
- An experienced Denodo engineer will consult with your IT staff to understand your architecture and configuration and will provide the most up-to-date information on the latest product features, making recommendations that are crucial in preparing for your upgrade.
- Contact your Denodo Customer Success Manager if you are interested in an Upgrade Assessment.
Professional Services for the Upgrade
Based on the results of the Upgrade assessment, Professional Services can be used to complete the upgrade process.
References
Laying down the upgrade path for your existing enterprise software (On-demand) | Denodo
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.
Recommended resources
Questions
