community

Q&A
KB
USER MANUALS
VIDEOS
TUTORIALS
EXPRESS
DRIVERS
- Overview
- JDBC
- ODBC
FREE TRIAL

SIGN IN

community

Denodo Platform 7.0

Denodo Platform Installation Guide
- Legal Note
- Preface
- Introduction
- Preinstallation Tasks
- Using the Graphical Installation Wizard
- Using the Command Line Installer
- Unattended Installation of the Denodo Platform
  - Modifying the Denodo Platform Installer to Include the Latest Update
- Postinstallation Tasks
- Installing Updates and Hotfixes
  - Installing an Update or Hotfix Graphically
  - Installing an Update or Hotfix from the Command Line
- Denodo Platform Control Center
- Appendix
Denodo Platform Migration Guide
- Preface
- Outline of the Migration Process
  - Migrating from Denodo 5.5 or Earlier
- Before Beginning the Migration
- Export the Metadata of the Current Installation
- Modify the Virtual DataPort Metadata
- Import the Metadata to the New Installation
- After Importing the Metadata into the New Installation
  - Migrate Salesforce Base Views to Use the New Data Source
- Test the New Denodo Platform Installation
- Backward Compatibility
- Features Deprecated in Virtual DataPort 7.0
Denodo Platform New Features Guide
- Preface
  - Scope
  - Audience
- New Features Common to All Modules
- New Features of the Installer
  - Other Changes
- New Features of Virtual DataPort
- New Features of Scheduler
- New Features of the Embedded Web Container
Virtual DataPort Administration Guide
- Preface
  - Scope
  - Who Should Use This Document
  - Summary of Contents
- Introduction
- General Architecture
  - Physical Layer
  - Logical Layer
    - Data Module: Cache
  - User Layer
- Installation and Execution
  - Launching the Virtual DataPort Server
  - Launching the Virtual DataPort Administration Tool
- Creating Data Sources and Base Views
  - JDBC Sources
    - Importing JDBC Sources
    - Database Specific Information
    - Connecting to a JDBC Source with Kerberos Authentication
    - Creating Base Views from a JDBC Data Source
    - Importing Graphically Stored Procedures from a Database
    - Creating Base Views from SQL Queries
  - ODBC Sources
    - Creating Base Views from an ODBC Data Source
  - SOAP Web Service Sources
    - Importing SOAP Web Service Sources
    - Creating Base Views from a SOAP Web Service
  - Multidimensional Database Sources
    - Creating a Base View Over a Multidimensional Data Source, Graphically
    - Creating a Base View Over a Multidimensional Data Source with an MDX Query
    - Multidimensional Data Sources to Oracle Essbase
  - Path Types in Virtual DataPort
    - Local Path
    - Path From Variable
    - HTTP Path
    - Denodo Browser Path
    - FTP / SFTP / FTPS Path
    - Compressed or Encrypted Data Sources
    - Custom Input Filters
    - Paths and Other Values with Interpolation Variables
  - XML Sources
  - JSON Sources
  - Delimited File Sources
    - Examples of How to Define a Tuple Pattern
    - Paths Using Date Ranges
  - Excel Sources
  - Web Sources (WWW)
  - Google Search Sources
  - Aracne Sources
  - LDAP Sources
  - BAPI Sources
  - Salesforce Sources
    - Registering Denodo as a Connected Application
    - Creating a Salesforce Data Source
    - Creating Base Views from a Salesforce Data Source
    - Creating Base Views from SOQL Queries
    - Binary Fields
    - Limitations of Salesforce
  - Custom Sources
    - Using Interpolation Variables as Custom Sources’ Input Parameters
  - Viewing the Schema of a Base View
    - View the VQL of an Element
    - Used By…
    - Source Type Properties
  - Data Source Configuration Properties
    - ORDER BY Properties of the Source Configuration
  - Source Refresh
  - Working with Blob Fields of Base Views
- Creating Derived Views
  - Creating Union Views
    - Creating Standard Union Views
    - Creating Partitioned Union Views
  - Creating Join Views
    - Join Conditions with Similarity Operators
  - Creating Selection Views
    - Creating Conditions with the Compound Values Editor
    - Parameters of Derived Views
  - Creating Flatten Views
  - Creating Intersection Views
  - Creating Minus Views
  - Creating Interface Views
  - Viewing the Schema of a Derived View
  - Tree View
  - Data Lineage
  - Advanced Configuration of Views
  - Materialized Tables
  - Temporary Tables
  - Querying Views
    - Execution Trace of a Statement
  - Editing / Replacing a View
    - Views Affected by Modifications
- Stored Procedures
  - Importing Stored Procedures
  - Executing Stored Procedures
  - Use of Stored Procedures in Creating Views
- Publication of Web Services
  - Publishing SOAP Web Services
  - Publishing REST Web Services
  - XSLT Transformations
  - Web Services Authentication
  - How Web Services Query the Virtual DataPort Server
  - Connection from the Web Services to the Server
  - Web Service Container Status Table
  - Invoking Denodo Web Services
    - Invoking Web Services with SAML Authentication
    - Types Conversion Table for REST / SOAP Published Web Services
- Publication of Views as Widgets
  - Publish a View as a Widget
  - Auxiliary Web Services
  - Export to JSR-168 or JSR-286 Portlet
  - Export as Microsoft Web Part
  - Deployment of a Microsoft Web Part
- RESTful Architecture
  - Primary Keys of Views
  - Associations
  - RESTful Web Service
  - Denodo OData 4.0 Service
- JMS Listeners
  - Creating a New JMS Listener
  - Who Can Create JMS Listeners
  - Advanced JMS Configuration
    - Acknowledge Mode
    - Acknowledge On Query Finish and Serialized Processing
  - Enabling Advanced Logging for JMS Listeners
- Remote Tables
  - Managing Remote Tables
- Server Administration - Configuring the Server
  - Server Connectivity
  - Threads Pool
  - Configuring the Cache
  - Limiting the Number of Concurrent Requests
  - Default Configuration of HTTP Proxy
  - Configuring the Memory Usage and Swapping Policy
  - Queries Optimization
  - Configuring Runtime Parameters for Stored Procedures
  - Configuring the Default Internationalization
  - Identifiers Charset
    - Restricted Mode
    - Unicode Mode
  - Kerberos Authentication
  - OAuth Authentication
    - Setting-Up the OAuth Authentication in the Virtual DataPort Server
    - Creating the Roles of the Virtual DataPort Users
  - SAML Authentication
    - Validation of the Response Signature
  - Privileges
    - The FILE Privilege
- Memory Management
  - Streaming Vs Non-Streaming Operators
  - Swapping Parameters
  - Limit the Maximum Amount of Memory of a Query
  - Edge Cases in Streaming Operation
  - Cache Load Processes
- Resource Manager
  - Defining a Plan
  - Defining a Rule
- Exporting and Importing the Server Metadata
  - Exporting the Server Metadata
  - Exporting and Importing Elements Across Different Environments
    - Exporting Environment-Dependent and Independent Elements to Different Files
    - Export to a File with Properties
  - Importing Metadata into a Server
- Importing Extensions
- Cache Module
  - Generic Support for Other Databases
  - Cache Modes
  - Cache Maintenance Task
    - Maintaining the Underlying Database
- Specific Information about Cache Databases
  - Azure SQL Data Warehouse
  - Presto
  - Spark
  - Databases with HDFS Storage
- Version Control Systems Integration
  - VCS Configuration
  - VCS Integration Features
  - Scenarios and Recommended Uses
  - Best Practices When Using the Integration with a VCS
    - Tagging and Branching Releases
    - Recommendations for the Testing Environment
  - Uniqueness Detection
    - Enabling Uniqueness Detection
    - Examples
  - LS Optimization for Subversion
    - Activating the LS Optimization
    - Tested Environments
- Databases, Users and Access Rights in Virtual DataPort
  - Databases in Virtual DataPort
  - User and Access Right in Virtual DataPort
  - Administration of Databases, Users, Roles and Their Access Rights
- Monitoring the Virtual DataPort Server
  - Monitoring with a Java Management Extensions (JMX) Agent
  - Denodo Monitor
- Cluster Architectures / Server Backup
  - Denodo Tools
  - How to Check If a Virtual DataPort Server Is Alive
  - Using the Import/Export Scripts for Backup And/or Replication
    - Export Script
    - Import Script
  - Configuring Several Instances of a Virtual DataPort Server
    - How to Configure the Slave Instances
- Bulk Data Load
  - Amazon Redshift
  - DB2
  - Hive
  - Impala
  - MySQL
  - Oracle
  - PostgreSQL
  - Presto
  - Snowflake
  - Spark
  - Microsoft SQL Server
  - Teradata
  - Settings of the Generation of the Temporary Files
    - Databases with HDFS Storage
- Optimizing Queries
  - Optimizing DF Data Sources
  - Optimizing Join Operations
  - Automatic Simplification of Queries
  - Cost-Based Optimization
  - Data Movement
  - Parallel Processing
    - Use of a MPP Engine as Cache
    - Force Movement of Views to the MPP Engine Using the CONTEXT Clause
- Appendix
  - Supported JDBC Data Sources
  - Backward Compatibility Between the Virtual DataPort Server and Its Clients
  - Mapping Multidimensional Data to a Relational Model
    - Creating a Multidimensional Base Views Over a Multidimensional Data Source
    - Mapping the Result of MDX Queries
  - Considerations When Configuring Data Sources with Pass-Through Credentials
  - Configuring the Logging Engine
  - Installing the Denodo Solution for Microsoft SharePoint
  - Customizing Events and Public Render Parameters of JSR-286 Portlets
  - Transforming Incoming/Outgoing Soap/Rest Messages with XSLT Stylesheets
  - JMS Connection Details: JNDI Properties
  - Execution Trace Information
  - Web Services Created with Previous Versions of the Denodo Platform
  - Useful Tools to Debug Issues with Active Directory or Other LDAP Servers
  - Single User Mode
    - Explicit Single User Mode
    - Automatic Single User Mode
  - Resource Manager: Available Fields to Evaluate a Rule
    - Examples of Resource Manager Rules
  - Values of the Attribute “Access Interface”
  - Avoiding SQL Injections
  - Enabling the Support for ODBC Sources When an External JRE is Used
Virtual DataPort Developer Guide
- Preface
- Introduction
  - Examples
- Access Through JDBC
- Access Through ODBC
- Access Through an ADO.NET Data Provider
  - Using Kerberos Authentication
- Access Through OLE DB
- Developing Extensions
- Custom Policies
  - Developing a Custom Policy
- Appendix
Virtual DataPort VQL Guide
- Preface
  - Scope
  - Who Should Use This Document
  - Summary of Contents
- Introduction
- General Overview of Virtual DataPort
  - Creating or Defining Data
  - Executing Statements
- Language for Defining and Processing Data: VQL
  - Data Types
    - Data Types for Dates, Timestamps and Intervals
    - Internationalization
  - Statements
  - Unicode Identifiers
  - Logical Operators
  - Comparison Operators
    - Comparing Literals
    - Three-valued Logic
  - Functions for Conditions and Derived Attributes
  - Syntax Conventions
    - Syntax of Functions and Condition Values
  - Comments
- Generating Wrappers and Data Sources
  - Creating Data Sources
  - Creating Wrappers
  - Valid Conversions Between Types in Wrappers and VDP Types
    - Native-type Conversions of a Wrapper to Java Types
    - Filters
  - QUERY WRAPPER Statements
- Creating a Base View
  - Query Capabilities: Search Methods and Wrappers
  - Modifying a Base View
- Queries: SELECT Statement
  - FROM Clause
  - WITH Clause
  - SELECT Clause
    - Derived Attributes
  - WHERE Clause
    - Conditions with Compound Values
  - Group BY Clause
    - Use of Aggregation Functions
  - HAVING Clause
  - UNION Clause
    - Enabling the Standard SQL Union
  - ORDER BY Clause
  - OFFSET, FETCH and LIMIT
  - CONTEXT Clause
  - TRACE Clause
  - CASE Clause
- Defining a Derived View
  - Modifying a Derived View
  - Defining an Interface View
- Defining the Statistics of a View
- Materialized Tables
  - Creating Materialized Tables
  - Inserting Data into Materialized Tables
- Temporary Tables
  - Creating Temporary Tables
- Inserts, Updates and Deletes Over Views
  - INSERT Statement
  - UPDATE Statement
  - DELETE Statement
  - Return Modified Rows
    - Limitations
  - Use of WITH CHECK OPTION
- Remote Tables
  - CREATE REMOTE TABLE Command
- Transactions in Virtual DataPort
- Stored Procedures
  - Importing a Stored Procedure
  - Use of Stored Procedures
  - Predefined Stored Procedures
- Defining Other Elements of the Catalog
  - Creating Folders
  - Defining a Data Type
  - Defining a Map
  - Defining JAR Extensions
  - Defining JMS Listeners
- Creating Databases, Users, Roles and Access Privileges
  - Creating and Modifying Virtual DataPort Databases
  - Managing Users
- Describing Catalog Elements
  - Exporting Metadata
  - Importing Metadata
- Listing Elements in the Catalog
- Removing Elements from the Catalog
- Publication of Web Services
  - Creating SOAP Web Services
  - Modifying SOAP Web Services
  - Creating REST Web Services
  - Modifying REST Web Services
  - Connection Parameters
  - Web Services Authentication
    - Basic and Digest
    - OAuth 2.0
    - SAML
    - VDP
    - WSS
  - Embedded Web Container Management
  - Deploying and Exporting SOAP and REST Web Services
- Publication of Widgets
  - Create New Widgets
  - Export a Widget
  - Deployment and Export of Auxiliary Web Services
- RESTful Architecture
  - Associations
  - Navigational Queries
- Help Command
- Version Control Systems Integration Commands
  - Statements to Work with Centralized Version Control Systems
    - VCSCOMMIT
    - VCSUPDATE
    - VCSCONTENTS
    - VCSSHOW
    - REVISIONS
  - Statements to Work with GIT
  - Commands for Environment Management
  - Other Version Control Commands
    - VCSDISCARD
- Resource Manager
  - Managing the Plans of the Resource Manager
  - Managing the Rules of the Resource Manager
- Advanced Characteristics
  - Management of Compound Values
    - Processing of Compound Types: Example
  - Dynamic Choice of Join Strategy
  - Using the Cache
    - Cache Invalidation
    - Displaying the Contents of the Cache
  - Configuring Swapping Policies
  - Managing Internationalization Configurations
    - Replacing an I18n Map
    - Deleting an I18n Map
  - Execution Context of a Query and Interpolation Strings
  - Adding Variables to Selection Conditions (GETVAR and SETVAR)
- Appendix
  - Syntax of Condition Functions
  - Syntax of Search Expressions for the Contains Operator
  - Support for the Contains Operator of Each Source Type
  - CASE Clause Examples
  - Date and Time Pattern Strings
  - Web Services Created with Previous Versions of the Denodo Platform
Data Catalog Guide
- Preface
- Introduction
- Installation and Execution
  - Launching the Data Catalog
- Authentication and Authorization
- Administration
- Configuration
- Browse
- Saved Queries
  - Deploying Saved Queries
  - Copying Saved Queries
- Search
- Appendix
Diagnostic & Monitoring Tool Guide
- Preface
- Introduction
- Installation and Execution
  - Launching the Monitoring and Diagnostic Tool
- Architecture
- Authentication and Authorization
  - Kerberos Authentication
- Creating Servers and Environments
  - Creating Servers
  - Creating Environments
- Monitoring
- Creating Diagnostics and Diagnostic Intervals
  - Creating Diagnostics
  - Creating Diagnostic Intervals
- Diagnosing
- Export and Import
  - Export
  - Import
- Configuration
  - User Configuration
  - Server Configuration
    - Informative Message
Virtual DataPort API Javadoc
Scheduler Administration Guide
- Preface
- Introduction
- General Architecture
- Installation and Execution
- Administration
- Creating and Scheduling Jobs
- Developer API
  - Scheduler Client API
  - Extensions (Plugins)
- Appendix
Scheduler API Javadoc
ITPilot User Guide
- Preface
- Introduction
  - Denodo ITPilot Environments
- Distribution of Environments
- Installation and Initial Configuration
- Execution
- Web Administration Tool
- Verification Server Graphical Configuration and Monitoring Tool
- Wrapper Execution Trace Logs
ITPilot Generation Environment Guide
- Preface
- Introduction
  - Presentation
  - Development of Component-Based Wrappers
- Installation and Execution
  - Introduction to the Tools
- Generation Environment Tools - Part I
- Generation Environment Tools - Part II
- Generating Navigation Sequences
- Appendix A: ITPilot Operators
  - Logical Operators
  - Comparison Operators
- Appendix B: ITPilot Functions
- Appendix C: Catalog of Components
- Appendix D: Constraints of the Simplified DOM
- Appendix E: List of Reserved Words
ITPilot Developer Guide
- Preface
- Introduction
- ITPilot Development API
- Connecting to the Server
- Creating Custom ITPilot Functions
ITPilot DEXTL Guide
- Preface
- Introduction
- An Overview of DEXTL
- Basic Syntax
- Advanced Syntax
- DEXTL Quick Reference Sheets
- Putting All Together
ITPilot NSEQL Guide
- Preface
- Introduction
- Basic Concepts of NSEQL
- List of NSEQL Commands
- Util Functions
  - EncodeSEQ
ITPilot API Javadoc
Solution Manager Installation Guide
- Preface
  - Who Should Use This Document
- Preinstallation Tasks
- Using the Graphical Installation Wizard
- Using the Command Line Installer
- Unattended Installation of the Solution Manager
  - Modifying the Solution Manager Installer to Include the Latest Update
  - Unattended Installation of the Solution Manager
- Postinstallation Tasks
- Denodo Platform Control Center
- Appendix
Solution Manager Administration Guide
- Preface
- Introduction
  - General Architecture
- Launching the Solution Manager Components
- Introducing the Solution Manager Administration Tool
- Authentication and Authorization
- Environments
  - Creating Environments
  - Configuring Environments
- Clusters
  - Creating Clusters
  - Configuring Clusters
- Servers
  - Creating Servers
  - Configuring Servers
    - Configuring Server Load Balancing Variables
    - Configuring Server Logging Level
- Load Balancing Variables
  - Creating Load Balancing Variables
  - Assigning Values to Loading Balancing Variables
- Promotions
- License Management
- Monitoring
  - Monitoring Configuration
  - JDBC Logging Configuration
- Configuration
- Import and Export Catalog
- Appendix
Web Panel Guide
- Preface
- Installation and Execution
  - Launching the Web Panel Administration Tool
- Accessing Denodo Web Tools
- Administration
Denodo4E User Guide
- Preface
- Installing Denodo4E
- VDP/ITP Server Tutorial
- Wrapper Generation Tool Tutorial
- Reference of the Dialogs of the Denodo4E Plugin
DenodoConnect Components
- Custom Handler Email Exported Files - User Manual
- Denodo Cloud Cache Load Bypass Stored Procedure - User Manual
- Denodo Distributed File System Custom Wrapper - User Manual
- Denodo Dynamics 365 Business Central Templates - Quick Use Guide
- Denodo Dynamics 365 Customer Engagement Templates - Quick Use Guide
- Denodo FileSystem CustomWrapper - User Manual
- Denodo GeoJSON Service - User Manual
- Denodo Google Sheets Tool - User Manual
- Denodo Governance Bridge - User Manual
- Denodo HBase CustomWrapper - User Manual
- Denodo Hibernate Dialect - User Manual
- Denodo Incremental Cache Load Stored Procedure - User Manual
- Denodo Kafka Custom Wrapper - User Manual
- Denodo Log Custom Wrapper - User Manual
- Denodo Model Bridge - User Manual
- Denodo MongoDB Custom Wrapper - User Manual
- Denodo Monitor Reports - User Manual
- Denodo OData 2.0 Service - User Manual
- Denodo OData2 Custom Wrapper - User Manual
- Denodo OData4 Custom Wrapper - User Manual
- Denodo Power BI Custom Connector - User Manual
- Denodo RFCReadTable Custom Wrapper - User Manual
- Denodo Replicator - User Manual
- Denodo SSH Custom Wrapper - User Manual
- Denodo SalesForce REST Custom Wrapper - User Manual
- Denodo ServiceNow Templates - Quick guide
- Denodo Tableau Scheduler Exporter - User Manual
- Denodo Templates for Twitter - Quick Use Guide
- Denodo Testing Tool - User Manual
- Denodo XSLT Mapper - User Manual
- Denodo XtraFuncs - User Manual
- Generic XML Exporter - User Manual
Denodo Express Quick Start Guide
Denodo Platform Container QuickStart Guide
Denodo Platform For AWS Free Trial BYOL Quick Start Guide
Denodo Platform For Azure Free Trial BYOL Quick Start Guide
Denodo Platform for AWS Quick Start Guide
Denodo Platform for Azure Quick Start Guide

User Manuals /
Denodo Platform New Features Guide

Denodo Platform New Features Guide¶

Table of Contents

Preface
- Scope
- Audience
New Features Common to All Modules
New Features of the Installer
- Other Changes
New Features of Virtual DataPort
New Features of Scheduler
New Features of the Embedded Web Container

Preface Features Deprecated in Virtual DataPort 7.0

Denodo Site
Support Site
Partner Portal
Contact Us
Terms of Use
Privacy & Cookies Policy
© Denodo Technologies