You can translate the document:

Overview

Scope

This document guides readers through the different steps of the installation and configuration of the Denodo Platform.

Terminology

VDP: Virtual DataPort

VCS: Version Control System

Pre-installation checklist

Requirement

Comply (Y/N)

Comments

COMMON

 

 

Is the license available and valid for the new deployment?

Does the number of processors meet the license requirements (if applicable)?

Does computer IP meet the license requirements (if applicable)?

Does Solution Manager server IP meet the license requirements (if applicable)?

Does the computer meet minimum system requirements?

Is Memory assigned to that virtual machine and actually reserved for it in case of virtual machine installation?

Does the computer meet software requirements?

 

 

Is a support account available to download software or is the software already downloaded?

 

 

Is there a user to run the Denodo services?

 

 

License Manager

Is the License Manager port open and accessible from the Denodo Platform servers?

Check the port 10091 port is open in the Solution Manager installation.

VDP

 

 

Is a cache database available?

 

 

Are the VDP ports available and open for external access?

 

Check all the VDP ports are open:

  • 9999
  • 9997
  • 9996
  • 9995 (starting with Denodo 8.0)
  • 9994 (starting with Denodo 9.1 for Arrow Flight SQL)

Are Excel and Access ODBC drivers installed?

(Only if there are plans to extract data from Excel and Access files)

Scheduler

 

 

Are the Scheduler ports available and open for external access?

 

Check all the ports for all the Scheduler server (default 8000 and 7998)

Web Container

 

 

Are the Web Container ports available and open for external access?

 

Check all the ports for all the Web Container server

Installation checklist

Requirement

Comply (Y/N)

Comments

Is the correct distribution of the Denodo Platform downloaded?

Is there a user with Administrator privileges to perform the installation?

 

 

Is the installer unzipped?

 

 

Is the installation correctly launched?

 

It can be started:

  • using the wizard.
  • using the silent start.

Is the installation path set to the correct destination?

On Windows, using C:\Program Files or C:\Program Files x86 is not recommended as it will require Administrator privileges for the installation and also to run the Denodo servers and tools (Denodo Admin and Development Best Practices)

Is the correct default locale selected?

Post-installation checklist

Requirement

Comply (Y/N)

Comments

COMMON

 

 

Replicate the Encryption Key

Is the license installed?

 

This can be done:

  • Solution Manager Administration Tool
  • Using Denodo Platform Control Center
  • Copying file to %DENODO_HOME%/conf folder

Register the Denodo Servers in the License Manager

If Windows, have Denodo Windows Services been configured to run with the new user account? (optional)

 

Add to the Windows Services, the login information of the user.

It may require creating a system account to run the Denodo server with full privileges on the installation folder.

If Linux, has the linux service been configured? (optional)

Linux startup scripts for the Denodo Platform

Have the JVM parameters been configured appropriately for each Denodo application?

Denodo Platform Configuration

Solution Manager

Change the Default Password

If Windows, have the Solution Manager Services been configured? (Optional)

Configure Windows Services

Installing the Solution Manager Web Applications as Windows Services

VDP

Change the Host name in the VDP Server (if applicable)

Change the Host Name in the Virtual DataPort Server

Change the Default Password

Virtual DataPort, Data Catalog

CACHE

 

 

Is the cache database configured?

 

Configuring the Cache

Is the maintenance task configured?

 

This can be configured to be executed:

  • From the server with the Maintenance On.
  • From the scheduler using the CLEAN_CACHE_DATABASE() stored procedure.

Security and LDAP

 

 

Has the admin user password been changed? (by default “admin”)

Virtual DataPort Admin Tool.

Solution Manager Admin Tool

Note: Starting with version 8.0u20230914, the passwords have to meet certain policies.

Password Policies in the Denodo Platform and Solution Manager

Is the LDAP data source defined? (if applicable)

 

Virtual DataPort Admin Tool/Web Design Studio

Is LDAP configured at server level?

This may be done during deployment instead of during installation.

Is the database configured to delegate authentication to LDAP? (if applicable)

 

If configured at server level, this may not apply.

This may be done during deployment instead of during installation.

Are roles defined/imported from LDAP?

 

This may be done during deployment instead of during installation.

Are privileges assigned?

 

This may be done during deployment instead of during installation.

VCS

 

(recommended for multiple developers in a development server)

Is the VCS server configured? (if applicable)

 

Virtual DataPort Admin Tool/Web Design Studio

Is the environment configured? (if applicable)

 

Virtual DataPort Admin Tool/Web Design Studio

Is the database configured to synchronize with the VCS server? (if applicable)

 

Virtual DataPort Admin Tool/Web Design Studio

JMS listener

 

 

Are the JMS Connectors installed for the appropriate version? (if applicable)

 

 Virtual DataPort Admin Tool/Web Design Studio

SSL

 

 

Is there a SSL certificate self-signed or from a CA for the Denodo server? (if applicable)

 

Only if SSL is required on VDP Servers

Is SSL configured in the Denodo servers? (if applicable)

 

Only if SSL is required on VDP Servers

Enable SSL/TLS in the Denodo Platform

Is SSL configured in the Denodo Platform tools? (if applicable)

 

Only if SSL is required on VDP Servers

Is SSL configured in the Embedded Web Container? (if applicable)

 

Only if https is required

Is SSL configured for external clients? (if applicable)

 

Only if SSL is required on VDP Servers

Are the certificates of Data Sources imported in the Denodo truststore? (if applicable)

 

Only if the VDP server needs to use SSL to connect to Data Sources.

Is SSL configured in the Solution Manager?(if applicable)

Enable SSL/TLS in the Solution Manager

Kerberos

Setting-up Kerberos Authentication (if applicable)

Setting-up Kerberos Authentication

Setting-up Kerberos Authentication in the Data Catalog

Setting-up Kerberos Authentication in the Data Catalog

Scheduler

Is SMTP settings configured? (if required)

Is the VDP server configured to grab roles information if permissions are required?

Installation validation

Requirement

Comply (Y/N)

Comments

COMMON

 

 

Does the Denodo Control Center start?

 

If GUI available in server

Have you validated license information?

 

Automatically done using the License Manager. (if used)

Are all the modules included in the license enabled?

Solution Manager

Does the Solution Manager Server start?

Does the Solution Manager Admin tool start?

Does the Solution Manager Admin tool connect to the Solution Manager Server?

VDP

Does VDP Server start?

Does the VDP Admin tool start?

Does the VDP Admin tool connect to the admin database? (if applicable)

Scheduler

Does the Scheduler Server start? (if applicable)

Does the Scheduler Administration Tool start? (if applicable)

Update checklist

Requirement

Comply (Y/N)

Comments

Is the update to be installed downloaded from the Support Site?

 

 

Is there a user with Administrator privileges to install the update?

Are all the Denodo Servers and tools closed before launching the update?

Are all the MSIE instances closed before launching the update?

 

 

Does the RELEASE NOTES of the update point to any additional pre-installation task?

 

Read pre-installation requirements

Is the installation of the update finished successfully?

 

This can be done:

  • Using Denodo Platform Control Center
  • Using silent installation

Does the RELEASE NOTES of the update point to any additional post-installation task?

 

 

Disclaimer
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.

Questions

Ask a question

You must sign in to ask a question. If you do not have an account, you can register here