Denodo

 

Denodo Express 8.0 Quick Start Guide

Last modified on: 07 Aug 2020

 Download original document


Thank you for registering in the Denodo Community and downloading Denodo Express!

This quickstart guide will give you the first view about Denodo Express and how to start using it so you can quickly start building data virtualization solutions.

Denodo Express Architecture Overview

Denodo Express is derived from our enterprise-class product, the Denodo Platform, and they share the same main building blocks:

  • Virtual DataPort (VDP): this is the main data virtualization product that allows users to connect to a variety of data sources, combine their data and publish the results for client applications to consume. It’s composed of:
  • the VDP server or VQL server;
  • the VDP Administration Tool, a desktop client that you will use for both administration of the server and development of data virtualization solutions;
  • the Web Design Studio, a browser-based tool for developers; and
  • the Data Catalog, a browser-based tool that allows end users to easily consume data services.
  • Scheduler (SCHED): this is the batch processing tool that connects to data sources and the VDP server and allows to regularly run data exports, refresh and/or invalidate caches, etc. It is composed of:
  • the Scheduler Server;
  • and the Scheduler Administration Tool, a web application.
  • ITPilot (ITP): this is the semi-structured information module. It is normally used for web automation, mainly for accessing web pages and extracting information from them. The Denodo Express license does not include this module, but you can learn more about it in the ITPilot documentation and in the web automation tutorial.

Our recommendation is to always install all modules, even if they appear greyed out due to not being available for Denodo Express. That way you will not need to make any changes if you decide to upgrade to the Denodo Platform from the Express version.

Denodo Express Installation Process

To install Denodo Express follow these steps:

  1. Download the Denodo Express installer suitable for your operating system and CPU architecture. And download your Denodo Express license. Both the Denodo Express installer and the Denodo Express license are available to download from the Denodo Express Community page.
  2. Once you have them, unzip the installer file. That will create a folder with several files, which include “install.exe” and “install.sh”. Use the former to start the installation process in Windows systems, and the later for Linux systems. On Windows execute the installer with administrator privileges. If you did not log in as an administrator or User Account Control (UAC) is enabled, you will have to provide administrator credentials to launch the installer.
  3. The script will start the Denodo Express graphical installer. This installer will guide you step by step for installing the product. As mentioned before we recommend you to install all modules, and unless you have any specific need you can leave all the defaults for every product’s ports.
  4. During the installation you will be prompted for your Denodo Express license; make sure you have it available locally so you can select it from the installer interface.

There is additional information available in our detailed Denodo Platform Installation Guide.

Starting Denodo Express

Once the installation process is completed, Denodo Express will be available in the destination folder that you selected during the installation.

Now, you need to launch the Denodo Control Center following one of the following ways:

  1. through the Denodo Platform Control Center: use the desktop shortcut to the Denodo Platform Control Center; or
  2. browse to the folder <DENODO_HOME>/bin and open the file denodo_platform.bat in Windows systems or denodo_platform.sh in Linux systems.

After following one of those steps the Denodo Control Center will start. Then you can click on the left-hand “Virtual DataPort” button, which will show the controls for the Virtual DataPort module. There, you can start the VDP Server and launch the VDP Administration Tool.

User Credentials

The installation process creates by default the following user in both the VDP server and the Scheduler server:

Username: admin

Password: admin

Use these credentials to access your new Denodo Express installation. You can of course change the password for the admin user. Always be careful when modifying that password, as if for any reason you cannot remember or replicate it at a later point you will not be able to access your installation of Denodo.

Further steps

After your installation has finished and you are able to start the different VDP modules and connect to your server using the default credentials, you are ready to start building data virtualization solutions. Check out all the available information:

If you want to move on to professionally guided training you can always check our courses offering at our training site.

And if you have any questions or any specific assistance or help, don’t hesitate to ask your peers and experts within the Community.

Thank you!

The Denodo Team.






Comments

Post a Comment

Popular posts from this blog

Flutter for Single-Page Scrollable Websites with Navigator 2.0

Image
  Single page scrollable websites are everywhere. In this website design pattern, all the content is presented in one long-scrolling layout that contains multiple sections. Visitors can scroll or jump to a section by clicking buttons of a sticky menu. This pattern is a good fit for small content such as brochure websites, software library documentation, portfolios, and landing pages that are used to convert users [ 1 ]. Designers also love this pattern because it is simple, clean, and enables cool scroll animations. Jetbrains Mono single-page scrollable website Hive docs multi-page scrollable website In this series of articles, we will explore how to build a  single-page scrollable website  using Flutter. We will benefit from the Navigator 2.0 API to provide a good navigation experience to the users. You can find the source code of this series’ sample apps on my  Github page . The implementation details of the sample apps will be explained in the following articles: ...
Read more

A Data Science Portfolio is More Valuable than a Resume

Image
A Data Science Portfolio is More Valuable than a Resume Benjamin Obi Tayo Ph.D. Following Nov 20  · 5 min read D ata Science is a practical field. Hands-on skills are very important especially when you are interested in working outside academia as a practicing data scientist. In academia, you need more theoretical and research skills. While in-depth knowledge in the theoretical foundations of data science is important, as a practicing data scientist, hands-on experience is very crucial and one way to showcase you hands-on skills is via building a very great portfolio. Companies interested in hiring you would definitely be asking you for a portfolio, as it gives evidence of your strengths in fundamental data science concepts. While a data science resume is important, a data science portfolio is more valuable than a resume. This article will discuss 3 important platforms that can be used for portfolio buildi...
Read more

Better File Storage in Oracle Cloud

Image
Use Oracle Application Express with Oracle Cloud Infrastructure REST APIs to upload, download, and manage big files in Oracle Cloud. By Adrian Png November 27, 2019 Oracle Cloud Infrastructure  provides a comprehensive suite of REST APIs for accessing and managing cloud resources. For example, administrators can use REST APIs to create and manage autonomous databases and initiate backups. Oracle Application Express (Oracle APEX)  makes working with REST easy. The  APEX_WEB_SERVICE  package, available since Oracle APEX 4.0, provides developers with a function for consuming REST APIs. Oracle APEX 5.0 introduced the  APEX_JSON  package, allowing easy parsing of JSON responses. Oracle APEX 18.1 introduced the Web Source Module (WSM), which enables developers to access REST services and use the data in APEX components such as reports, interactive reports, and interactive grids. These features, when used together with Oracle Cloud Infrastructure REST ...
Read more