Welcome to the Denodo Platform 6.0 Documentation

In the documentation of the Denodo Platform you will find all the information you need to build Data Virtualization solutions.

Note

These user manuals were updated on Jul 29, 2017.

Introduction

The Denodo Platform is a data virtualization system that allows applications to use data from multiple, heterogeneous data sources.

Data is accessed and integrated in real-time across distributed data sources without copying or moving data from its source.

General architecture of the Denodo Platform

General architecture of the Denodo Platform

The Denodo Platform is comprised of this modules:

Virtual DataPort

The main module of the Denodo Platform. This is the module where developers create “virtual views” that integrate data from multiple sources: databases, SAP BW servers, XML files, JSON files, CSV files, etc.

Virtual DataPort provides several ways to query these virtual views:

  • A JDBC and an ODBC driver
  • By publishing SOAP and REST web services
Aracne Crawls and indexes any non-structured data: web sites, e-mail servers, file systems, etc.
ITPilot Provides an easy way to access, structure and query data present in the Web.
Scheduler Enables you to schedule jobs to interact with the other modules of the Denodo Platform. For example, send queries to Virtual DataPort at a particular moment and process its result.

Installation

The Installation Guide explains how to install the Denodo Platform.

Important

If you are upgrading from a previous version of the Denodo Platform, read the Migration Guide. It explains how to import the existing configuration to the new version. In addition, it provides information about backward compatibility and changes in the new release.

Virtual DataPort

The documentation of Virtual DataPort is divided in five documents:

  1. Virtual DataPort Administration Guide

    • It presents the fundamental concepts of the Data Virtualization.
    • It explains how to use the Virtual DataPort administration tool to build unified views of data from distributed and heterogeneous sources.
    • It explains how to configure and manage the Virtual DataPort server.
  2. Virtual DataPort Developer Guide

    • How to access a Virtual DataPort server using the Denodo JDBC and ODBC drivers to query Denodo from your applications.
    • How to use the API provided Virtual DataPort to develop custom extensions: stored procedures, wrappers to new sources, functions, security policies and filters.
  3. Virtual DataPort VQL Guide

    • It is a reference manual for the VQL language (Virtual Query Language).

      VQL and is the language provided by Virtual DataPort to query views, manage elements in Virtual DataPort (data sources, views, web services, etc) and perform programatically almost any of the tasks that you can perform from the administration tool.

      VQL is highly compatible with SQL.

  4. Information Self-Service Tool Guide

    • The Information Self-Service Tool is a web application targeted at business users to query, search and browse information and metainformation of a Virtual DataPort server.
  5. Diagnostic & Monitoring Tool Guide

    • Explains how to use the Diagnostic & Monitoring Tool to:
      1. Display the real time status of one or more Virtual DataPort servers
      2. Diagnose past issues by processing the log files generated by Virtual DataPort.

Scheduler

The Scheduler Administration Guide explains how to use the Denodo Scheduler.

Aracne

The Aracne Administration Guide explains how to use Denodo Aracne.

ITPilot

The documentation of Virtual DataPort is divided in five documents:

  1. Generation Environment Guide

    • Describes how to use the ITPilot Wrapper Generation Tool. With this tool you can graphically create wrappers that extract data. These are flows comprising different components; each component applies a specific function on a group of inputs and produces one output.
    • Explains how to deploy the generated wrappers in the ITPilot running environment.
  2. Developer Guide:

    • Explains how to develop applications that use the wrappers generated with Denodo ITPilot.
    • Describes how to use the API offered by Denodo ITPilot.
    • Explains how to create custom ITPilot functions.
  3. ITPilot DEXTL Guide

    • Provides a reference of the DEXTL (Data Extraction Language) language, which allows you to extract data from HTML pages.

      Usually you do not need to create DEXTL programs manually because with the ITPilot Generation Environment, you can create DEXTL programs graphically in a simpler way. Nevertheless, this manual provides an exhaustive description of the language for advanced users.

  4. ITPilot NSEQL Guide

    • Describes in detail the automated NSEQL language (Navigation SEQuence Language) used in Denodo ITPilot.
  5. ITPilot User Guide:

    • Provides an introduction to Denodo ITPilot.
    • Describes the functioning environments of Denodo ITPilot
    • The configuration of each of the Denodo ITPilot components in the execution and verification environments.