Installation & Bootstrapping - Installation steps

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

  1. Install Denodo into a directory (avoid using the %Program Files% folder). This directory will be referred to as <DENODO_HOME> throughout this tutorial.
  2. Copy the mysql-connector-java-.jar to <DENODO_HOME>/lib-external/jdbc-drivers/mysql-5
  3. Install & configure the database:
    1. Install MySQL server.
    2. Start MySQL and launch the MySQL Workbench application.
    3. Connect to your MySQL server and then open the <tutorial_directory>/MySQL/schema.sql script by choosing "Open SQL Script" from the File menu.
    4. Once the script has been opened, click on Execute (you can use any other method to load the database).
    5. 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
  4. Install a web server:
    We are going to use Jetty to run some of the examples in the tutorials:
    1. 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.
    2. 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, make sure you have your personal license too.

TIP

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: right-click the install.exe file and select Run as administrator.
  • Linux OS: execute install.sh.

The installer will show up.

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

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. This tutorial covers every module so we suggest installing them all, but you only need Virtual DataPort to get started.

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

Once the installation is complete, you can choose to create a desktop shortcut that can be used 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 when you first start the program. (By first clicking on the Configure button and then selecting Use a license file, a new dialog will be opened to select the license file and confirm its installation.

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

TIP

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