Introduction¶

Data virtualization is a logical data layer that integrates all enterprise data siloed across the disparate systems, manages the unified data for centralized security and governance, and delivers it to business users in real time. Data virtualization is the modern approach to data integration. Unlike ETL solutions, which replicate data, data virtualization leaves the data in source systems, simply exposing an integrated view of all the data to data consumers. Find more information about this at https://www.denodo.com/en/data-virtualization/benefits.

The Denodo Platform is the leader in Data Virtualization.

General architecture of the Denodo Platform¶

The Denodo Platform is comprised of these modules:

These modules are provided in two installers:

1. The installer of the Denodo Platform, which includes Virtual DataPort, Data Catalog, Scheduler, Diagnostic and Monitoring Tool and ITPilot.

2. The installer of the Solution Manager.

Installation¶

The Solution Manager Installation Guide explains how to install the Solution Manager.

The Denodo Platform Installation Guide explains how to install the Denodo Platform.

Virtual DataPort¶

The documentation of Virtual DataPort is divided in three 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 programmatically almost any of the tasks that you can perform from the administration tool.

     VQL is highly compatible with SQL.

Data Catalog¶

The Data Catalog Guide explains how to set-up Data Catalog and use it.

Diagnostic & Monitoring Tool¶

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

ITPilot¶

The documentation of ITPilot 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.

Solution Manager¶

The documentation of the Solution Manager is divided in three documents:

1. Solution Manager Installation Guide.

2. Solution Manager Administration Guide

   • Explains how to manage clusters of Denodo servers using this tool.

   • Explains how to manage the licenses used by these servers from this tool instead of having to manage them server by server.

3. Web Panel Guide.

   • Explains how to use and configure the Web Panel Administration Tool.