USER MANUALS

  • User Manuals /
  • Welcome to the Denodo Platform 9 Documentation

Welcome to the Denodo Platform 9 Documentation

Welcome to the user manuals of the Denodo Platform and Solution Manager version 9.0.

Note

The user manuals were updated on Nov 12, 2024.

See the latest changes in the Denodo Platform New Features Guide.

Important

To upgrade to Denodo 9 from Denodo 8.0, 7.0…, follow the instructions of the Upgrade Guide. The VQL statements generated by previous versions of Denodo cannot be imported directly into Denodo 9; some of them may fail due to syntax errors.

In the user manuals of Denodo, you will find the information you need to install and configure Denodo, and perform all the administrative and users tasks.

You can browse the contents on the left or use the search box at the top to search specific topics and also, to search on the entire Denodo Community.

Getting Started

If you are new to Denodo, here are some resources that are useful:

  • Watch the video Data Virtualization: An Overview: a high level of explanation of what Data Virtualization is and what Denodo does.

  • Denodo Express: a free version that includes most of the features of the Denodo Platform. You can install it on your machine, an AWS EC2 instance…

  • You can request a 30-day free trial of Denodo Professional (find below the differences between Denodo Professional and the different Denodo Platform bundles).

  • Test Drives: with the Test Drives you can quickly and easily explore the benefits of using data virtualization with Denodo Platform on the cloud. It is free of charge for demonstration, education and evaluation purposes. You do not need to install anything; everything is provisioned automatically for you on the cloud.

  • Tutorials: step-by-step tutorials that cover several topics: how to develop Data Virtualization projects with Denodo, how to build data combinations that come from different data sources, how to expose virtualized data as a service, and more.

  • Expert Trails: they cover different specific topics from start to finish. They include information related to this topic through all the resources that we have in Denodo, including user manuals, KB articles, webinars, tutorials, blog posts, training courses, etc. The Expert Trails will guide the path for anyone interested in self-paced learning.

  • Training: the Denodo training courses provide training for data professionals, including administrators, architects, and developers. These courses are specifically designed to help our customers build leading-edge data solutions that address your organization’s data integration and information management needs. There are on-demand and live courses. To sign up for these courses, go to the Training page.

  • Knowledge Base: find here articles, how-to-guides and FAQs about the Denodo Platform.

  • Success Resources: additional resources to help you succeed with Denodo Platform.

What is Denodo?

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/data-virtualization/benefits.

The Denodo Platform is the leader in Data Virtualization.

These guides explain how to install and use:

  1. The Denodo Platform and its FeaturePacks

  2. Denodo Professional

  3. Denodo Standard

  4. Denodo Express

They are all built on the same engine but Denodo Professional and Denodo Express have some restrictions (see Denodo Platform - Subscription Bundles and Restrictions of Denodo Express).

Modules of the Denodo Platform

Modules of the Denodo Platform

Modules of the Denodo Platform

The Denodo Platform has these 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 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

  • An OData service, a GraphQL service and a RESTful web service

Data Catalog

Aimed at business users, to query and search data and metadata of your organization.

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.

Diagnostic and Monitoring Tool

Provides two main features:

  • Monitor the current state of Virtual DataPort servers

  • Analyze its state in the past in order to identify the cause of a problem.

Solution Manager

The Solution Manager helps you manage your deployment of Denodo servers. It consists of two components:

  • The License Manager: a centralized point from where administrators manage the Denodo licenses of the organization.

  • The Solution Manager: web tool for developers and administrators to promote changes from development to the other environments. For example, to propagate new views or changes to views of Virtual DataPort from the development server to the testing servers and then, to production.

These modules are provided in two installers (i.e. two different packages you have to download from the Denodo Support Site):

  1. The installer of the Solution Manager.

  2. The installer of the Denodo Platform, Denodo Professional or Denodo Express. These include Virtual DataPort, Data Catalog, Scheduler, and the Diagnostic and Monitoring Tool.

That is, you will have to perform at least two installations: one installation of the Solution Manager and one or more installations of the Denodo Platform. Unless you are doing an evaluation, you will install the Solution Manager in one computer and the installation of each Denodo Platform in other computers.

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.

Structure of the Documentation

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.

Solution Manager

The documentation of the Solution Manager is divided in two 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.

Add feedback