Installation & Bootstrapping - Installation steps

Installation Steps


Before you start, be sure you have your development environment set up. You need to:

  • Install Denodo into a directory (avoid using the %Program Files% folder). This directory will be referred to as <DENODO_HOME> throughout this tutorial.
  • Copy the MySQL Connector/J to <DENODO_HOME>/extensions/thirdparty/lib
  • Install & configure the database:
    • Install MySQL server.
    • Start MySQL and launch the MySQL Workbench application.
    • Connect to your MySQL server and then open the <tutorial_directory>/MySQL/schema.sql script by choosing "Open SQL Script" from the File menu.
    • Once the script has been opened, click on Execute (you can use any other method to load the database).
    • After doing this you should see a new database schema called "acme_crm" with three tables defined (address, client and client_type). Test MySQL by logging in to the acme_crm database with the credentials: acme_user / acme_user
  • Install a web server:
    • We are going to use Jetty to run some of the examples in the tutorials.
    • Go to <tutorial_directory>/jetty and run: java -jar start.jar from the command line. If you do not have a Java Virtual Machine installed on your system you can use the JVM installed with the Denodo Platform under <DENODO_HOME>/jre/bin.
    • Test the billing Web Service to see if it has been properly deployed, direct the web browser to: http://localhost:8080/billing/services. If successfully deployed, you will see there a list of available services "BillProvider", "AdminService", and "Version", along with their exposed methods and an option to view the WSDL descriptor.

This tutorial will incrementally build a set of views in Denodo to learn the basic concepts about Data Virtualization, it is important to follow each step.

Denodo installation

At this point, you should have already downloaded the Denodo Express installation package from your user account.

The installation package is not the only file to download, you have to get your personal license too.


The installation package is a .zip file. After decompressing the package you will see the files shown in the image below:

To start the installation GUI:

  • Windows OS: double-click the executable (install.exe file). You will need Administrator privileges.
  • Linux OS: execute

The installer then shows up.

After accepting the terms of the license, you have to select the installation directory (for example: C:/Denodo/5.5 or /opt/denodo/5.5).

If you already have a Denodo license file, you can select it clicking on the "Browse" button. Otherwise, you can install the license later from the Denodo Control Center

In the next step you have to select the modules to be installed.

You can leave the rest of the options with their default values and complete the installation.

Once the installation completes, the installer creates a shortcut in the desktop. You can use it to start the Denodo Control Center.

If you did not select any Denodo license during the installation process, you can do it from the Denodo Control Center. Clicking on "Install license", a new dialog will be opened to select the license file and complete its installation.

The installer includes a Java Runtime Environment (JRE), so a previously installed Java is not necessary.


That's all!
Thanks for installing Denodo! Now it's time to start to play with Denodo.