community

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

SIGN IN

community

Denodo Platform 8.0

Denodo Platform Installation Guide
- Legal Note
- Preface
- Introduction
- Pre-Installation 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
- Post-Installation 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 Upgrade Guide
- Preface
- Introduction to Upgrading the Denodo Platform
- Preparing to Upgrade
- Pre-Upgrade Tasks for the New Installation
- Export the Settings and Metadata of the Current Installation
  - Configuration Properties of Virtual DataPort for Upgrades: “exportMigrationCompatibility” and “exportOnlyResources”
- Review the Virtual DataPort Metadata
- Import Settings and Metadata in to the New Installation
  - Common Errors when Importing the Metadata of Virtual DataPort 7.0 to 8.0
- Post-Upgrade Tasks for the New Installation
- Test the New Denodo Platform Installation
- Backward Compatibility
- Features Deprecated for Denodo Platform 8.0
Denodo Platform New Features Guide
- Preface
  - Audience
- New Features of the Solution Manager 8.0
- New Features of Virtual DataPort 8.0
- New Features of Scheduler 8.0
  - User Interface
- New Features Common To All Modules of 8.0
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
- Starting Virtual DataPort
  - Starting the Virtual DataPort Server
  - Launching the Administration Tool
  - Starting the Design Studio
- Creating Data Sources and Base Views
  - JDBC Sources
  - ODBC Sources
  - SOAP Web Service Sources
    - Importing SOAP Web Service Sources
    - Creating Base Views from a SOAP Web Service
  - Multidimensional Database Sources
  - Path Types in Virtual DataPort
  - XML Sources
  - JSON Sources
  - Delimited File Sources
    - Examples of How to Define a Tuple Pattern
    - Paths Using Date Ranges
  - Excel Sources
  - Web Sources (WWW)
  - LDAP Sources
  - BAPI Sources
  - Salesforce Sources
  - Custom Sources
    - Using Interpolation Variables as Custom Sources’ Input Parameters
  - Viewing the Schema of a Base View
  - 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
- 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
- RESTful Architecture
  - Primary Keys of Views
  - Associations
  - RESTful Web Service
  - Denodo OData 4.0 Service
  - Denodo GraphQL 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
  - Remote Tables vs Other Mechanisms for Persisting Data
- Server Configuration
  - Configuring the Cache
  - Limiting the Number of Concurrent Requests
  - Configuring the Default Internationalization
  - Default Configuration of HTTP Proxy
  - Identifiers Charset
    - Restricted Mode
    - Unicode Mode
  - Configuring the Memory Usage and Swapping Policy
  - Privileges
    - The FILE Privilege
  - Queries Optimization
  - Server Authentication
  - Server Connectivity
  - Configuring Runtime Parameters for Stored Procedures
  - Threads Pool
  - Storing the Metadata on an External Database
- 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
  - Importing a JDBC Driver
  - Importing Other Types of Elements
- Cache Module
  - Cache Modes
  - Cache Maintenance Task
    - Maintaining the Underlying Database
  - Specific Information about Cache Databases
  - Generic Support for Other Databases
- 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 Ping Script
    - Alternatives to the Ping Script
  - Using the Import/Export Scripts for Backup And/or Replication
    - Export Script
    - Import Script
- Bulk Data Load
  - Amazon Athena
  - Amazon Redshift
  - DB2
  - Databricks
    - Mounting External File Systems on DBFS
  - Hive
  - Impala
    - Built-in Implementation
    - External Hadoop Installation
  - MySQL
  - Oracle
  - PostgreSQL
  - Presto
  - Snowflake
  - Spark
  - Microsoft SQL Server
  - Teradata
  - Yellowbrick
  - 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 an MPP Engine as Cache
    - Force Movement of Views to the MPP Engine Using the CONTEXT Clause
  - Smart Query Acceleration Using Summaries
    - Managing Summaries
    - Summary Rewrite Optimization
- 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
    - Web Services
  - Configuring the Logging System
  - Configuring the Network Interface Restriction in Virtual DataPort
  - Installing the Denodo Solution for Microsoft SharePoint
  - Transforming Incoming/Outgoing Soap/Rest Messages with XSLT Stylesheets
  - JMS Connection Details: JNDI Properties
  - Execution Trace Information
  - 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
  - Enable the “Export” Endpoint of the Web Container
  - Publication of Views as Widgets
  - Launching Several Virtual DataPort Instances of the Same Installation
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
    - Privileges Required
- Remote Tables
  - CREATE REMOTE TABLE Command
- Summaries
  - CREATE SUMMARY VIEW Command
- Inserts, Updates and Deletes Over Views
  - INSERT Statement
  - UPDATE Statement
  - DELETE Statement
  - Return Modified Rows
    - Limitations
  - Use of WITH CHECK OPTION
- Refreshing Views
  - REFRESH Statement
- 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
  - Ownership of Elements
- 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
  - Embedded Web Container Management
  - Deploying and Exporting SOAP and REST 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
  - Changing Settings of Virtual DataPort and the Web Container
  - 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
  - CASE Clause Examples
  - Date and Time Pattern Strings
  - Publication of Widgets
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
- General Architecture
- Installation and Execution
  - Launching the Diagnostic & Monitoring Tool of the Denodo Platform
  - Launching the Diagnostic & Monitoring Tool of the Denodo Solution Manager
- Introducing the Diagnostic & Monitoring Tool
- Authentication
- Authorization
- 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
- Appendix
Scheduler API Javadoc
Solution Manager Installation Guide
- Preface
  - Who Should Use This Document
- Pre-Installation 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
- Post-Installation Tasks
- Denodo Platform Control Center
- Appendix
Solution Manager Administration Guide
- Preface
- Introduction
  - Architecture
- Starting the Solution Manager
- Introducing the Solution Manager Administration Tool
- License Management
- Configuration
- Authentication and Authorization
- Denodo Security Token
- Environments
  - Clusters
  - Working Modes
- Standard Mode
- Automated Cloud Mode (AWS)
- Environment Configuration
- Clusters Configuration
- 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
- Monitoring
  - Monitoring Configuration
  - JDBC Logging Configuration
- Import and Export
- Appendix
Denodo4Eclipse Plugin Guide
- Preface
- Installing Denodo4Eclipse Plugin
- VDP/ITP Server Tutorial
- Wrapper Generation Tool Tutorial
- Reference of the Dialogs of the Denodo4E Plugin
ITPilot
- ITPilot User Guide
- ITPilot Generation Environment Guide
- ITPilot Developer Guide
- ITPilot DEXTL Guide
- ITPilot NSEQL Guide
- ITPilot API Javadoc
DenodoConnect Components
- Apache Zeppelin for Denodo - User Manual
- Custom Handler Email Exported Files - User Manual
- Denodo Cloud Cache Load Bypass Stored Procedure - User Manual
- Denodo Custom Wrapper for IBM Cognos TM1 - User Manual
- Denodo Custom Wrapper for SAS - User Manual
- Denodo Dialect for SQLAlchemy (feat. support for Apache Superset and Jupyter Notebook) - 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 Custom Wrapper - 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 Presto Cluster on Kubernetes - User Manual
- Denodo RFCReadTable Custom Wrapper - User Manual
- Denodo SFTP Exported Files Custom Handler - User Manual
- Denodo SSH Custom Wrapper - User Manual
- Denodo ServiceNow Templates - Quick guide
- Denodo Tableau Exporter - User Manual
- Denodo Templates for Google Analytics - Quick Use Guide
- Denodo Templates for Marketo - Quick Use Guide
- 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 8: Quick Start Guide with Automated Cloud Mode
Denodo Express Quick Start Guide
Denodo Platform Container QuickStart Guide
Denodo Platform for AWS Free Trial BYOL Quick Start Guide

User Manuals /
Denodo Platform Installation Guide /
Appendix

Appendix¶

List of appendices included in this document:

Default Ports Used by the Denodo Platform Modules
Limitations of Denodo Express
Using Kerberos Authentication in Virtual DataPort Without Joining a Kerberos Realm
Using Kerberos Authentication in the Data Catalog Without Joining a Kerberos Realm
Using Kerberos Authentication in the Design Studio Without Joining a Kerberos Realm
Using Kerberos Authentication in Scheduler Without Joining a Kerberos Realm
How to Debug Kerberos in Web Applications
- Virtual DataPort Server and the Web Administration Tools Are on the Same Installation
- Virtual DataPort Server and the Web Administration Tools Are not on the Same Installation
Providing a Krb5 File for Kerberos Authentication
Denodo Security Token Configuration File
- Common settings
- Authentication modules
Launching the Denodo Standalone Applications in High DPI Displays
Troubleshooting the Denodo Platform Installer
Transparent Metadata Encryption
Supported Java Runtime Environments (JRE)
Increasing the Maximum Simultaneous Requests

Default Ports Used by the Denodo Platform Modules Uninstalling the Denodo Platform

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