Denodo Logo
community
Denodo Logo
  • EXPERT TRAILS
    • Overview
    • Cache
    • DataSource Connectivity
    • Deployment Topology
    • Development Lifecycle
    • Modeling and Metadata Organization
    • Monitoring
    • Operations
    • Query Performance Optimization
    • Security
  • Q&A
    • All Questions
    • Ask a Question
    • Search by tag
  • Resources
    • USER MANUALS
    • KNOWLEDGE BASE
    • VIDEOS
    • TUTORIALS
    • DRIVERS
    • DV Blog
    • Technical Newsletter
  • TEST DRIVES
  • FREE TRIALS
  • DENODO EXPRESS
  • ACADEMIC PROGRAM
REGISTER
SIGN IN
    community
    Denodo Platform 7.0
  • Denodo Platform Installation Guide
    • Legal Note
    • Preface
      • Scope
      • Who Should Use This Document
      • Summary of Contents
    • Introduction
    • Preinstallation Tasks
      • Hardware Requirements
        • Recommendations when Running Denodo on Amazon AWS
        • Recommendations to Run the Denodo Platform on Microsoft Azure
        • Running the Denodo Platform on Docker
        • Disk Space Requirements of the Denodo Platform
        • Requirements for the Virtual DataPort Administration Tool
      • Software Requirements
        • Supported Platforms
        • Supported Java Runtime Environments (JRE)
        • Supported Browsers
        • Software Requirements for ITPilot
      • Other Preinstallation Tasks
        • Check that the Required Ports Are Free
        • Check the PATH Environment Variable on Windows
        • Select a User Account to Install the Denodo Platform
        • Close All the Browsers
      • Download the Installer
    • Using the Graphical Installation Wizard
      • Commons Settings
      • Components and Configuration of Virtual DataPort
      • Components and Configuration of ITPilot
        • Initial Configuration of the Browser Pool
        • Wrapper Server
        • Verification Server
      • Installation Settings of Scheduler
        • Scheduler Server
        • Scheduler Index Server
      • Embedded Web Container
    • Using the Command Line Installer
    • Unattended Installation of the Denodo Platform
      • Modifying the Denodo Platform Installer to Include the Latest Update
    • Post-Installation Tasks
      • Install the Latest Update
      • Change the Host Name in the Virtual DataPort Server
        • Changing the Host Name of the Denodo Servers Graphically
        • Changing the Host Name of the Denodo Servers from the Command Line
      • Register the Denodo Servers in the License Manager
      • Enable SSL/TLS in the Denodo Platform
        • Obtaining and Installing an SSL/TLS Certificate
        • Enabling SSL/TLS in Denodo Platform Servers
        • Enabling HTTPS in the Embedded Apache Tomcat
        • Enabling SSL/TLS in the Administration Tool and Others
        • Enabling SSL/TLS for External Clients
        • SSL/TLS Versions Supported by the Denodo Platform Servers
      • Configure Windows Services
        • Installing the Denodo Web Applications as Windows Services
      • Post-Installation Tasks: Virtual DataPort
        • Change the Default Passwords
        • Setting-up Kerberos Authentication
        • Setting-up Kerberos Authentication in the Data Catalog
        • Enabling the Support for ODBC Sources When the Virtual DataPort Server Runs on Linux
        • Installing the Connector for Oracle Essbase
        • Installing the SAP JCo Connector
        • Installing the Microsoft Access Driver
        • Installing the JMS Connectors to Create JMS Listeners and Web Services with SOAP Over JMS
        • Configuring the VCS Clients
        • Importing the Certificates of Data Sources (SSL/TLS Connections)
        • Increasing the Maximum Simultaneous Requests
        • Resource Manager: Modify the Priority of a Query Dynamically
        • Preparing the Connection to Databases
        • Grant Privileges in SAP BW to the Virtual DataPort User Account
        • Grant Privileges on SAP for BAPI Sources
        • Enable XMLA on Microsoft SQL Server Analysis Services (Multidimensional Sources)
      • Post-Installation Tasks: ITPilot
        • Checking that the Generation Environment Has Been Installed
        • Configuration of Microsoft Internet Explorer
        • Enabling Internet Explorer Sequence Generation Toolbar in Microsoft Windows Server 2008
        • Disabling Internet Explorer Enhanced Security Configuration in Microsoft Windows 2008
        • Disabling Internet Explorer Enhanced Security Configuration in Microsoft Windows Server 2012
        • Manual Configuration of Adobe Acrobat Professional
        • Automatic Verification Database
        • Launching the Wrapper Generator Tool in High DPI Displays
      • Post-Installation Tasks: Scheduler
        • Change the Default Passwords
        • Setting-up Kerberos Authentication in Scheduler
      • Post-Installation Tasks: Web Container
        • Hide Name and Version in Error Pages
        • Secure the “Export” Endpoint of the Web Container
        • Enable Authentication on the Monitoring Interface
      • Upgrading from a Previous Version
    • Installing Updates and Hotfixes
      • Installing an Update or Hotfix Graphically
      • Installing an Update or Hotfix from the Command Line
    • Denodo Platform Control Center
      • Launching the Denodo Platform Control Center
      • Starting Platform Servers and Tools
      • Denodo Platform Configuration
        • Configuring the Connection to the License Manager
      • Configuration of the JVM Parameters from the Command Line
      • Control Center Help
      • Uninstalling the Denodo Platform
    • Appendix
      • 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 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
      • Launching the Denodo Standalone Applications in High DPI Displays
      • Deploying the Web Administration Tool in an External Web Container
      • Troubleshooting the Denodo Platform Installer
      • Transparent Metadata Encryption
  • 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
      • Changes in the Denodo Platform 7.0
        • Changes Common to All the Modules of Denodo 7.0
        • Changes in Virtual DataPort 7.0
        • Changes in the Privileges System in Virtual DataPort 7.0
        • Features Removed in Virtual DataPort 7.0
        • Changes Introduced in Aracne 7.0
      • Changes in the Denodo Platform 6.0
        • Changes Common to All the Modules of Denodo 6.0
        • Changes in Virtual DataPort 6.0
        • Changes in Scheduler 6.0
        • Changes in the Embedded Web Container of Denodo 6.0
      • Changes in the Denodo Platform 5.5
        • Cache
        • CAST Function
        • Reserved Words
        • Prohibit Setting Incompatible Source Type Properties
        • Three-valued Logic
        • Features Removed in Denodo 5.5
      • Changes in the Denodo Platform 5.0
        • Case-Sensitivity of Elements
        • Dependencies Between Elements
        • Exporting to a Repository of Files
        • JMS Listeners
        • Web Services Published by Denodo
        • Stored Procedures
    • Features Deprecated in Virtual DataPort 7.0
      • Data Type “Date”
      • VQL Syntax
        • Contains, Containsand, Containsor and Iscontained Operators
        • SQLFRAGMENT Clause
        • Syntax ALTER TABLE <base view name> ADD SEARCHMETHOD
        • Parameters of the CONTEXT Clause of SELECT Statements
        • Deprecated Functions
      • Data Sources: Decrypt Filter
      • Aracne Data Sources
      • Google Search
      • Denodo Stored Procedures
      • Denodo Stored Procedures API: getNumOfAffectedRows Method
      • Denodo Custom Wrappers API: Deprecated Methods
      • Denodo JDBC Driver
      • Denodo Web Services
      • Widgets
      • Script Export
      • Data Catalog: Roles “selfserviceadmin”, “selfserviceexporter”
      • Launching Several Instances of a Virtual DataPort Server
      • Denodo4Eclipse Plugin
      • Denodo Monitor: SNMP
    • Features Deprecated in Scheduler 7.0
      • Aracne Data Sources
      • Filter Sequences
      • Jobs
      • Exporters
        • SQL Exporter
        • File-Repository Exporter
      • Move-File-Repository Handler
    • Features Deprecated in Solution Manager 7.0
      • REST API: Authentication Using Session
  • Denodo Platform New Features Guide
    • Preface
      • Scope
      • Audience
    • What Is New in Denodo 7.0 Update 20220531
    • What Is New in Denodo 7.0 Update 20210818
    • What Is New in Denodo 7.0 Update 20210224
    • What Is New in Denodo 7.0 Update 20201116
    • What Is New in Denodo 7.0 Update 20200803
    • What Is New in Denodo 7.0 Update 20200310
    • What Is New in Denodo 7.0 Update 20190903
    • 7.0 GA: New Features Common to All Modules
      • New Tool: Solution Manager
      • New Tool: Web Panel
      • Control Center
      • New Supported Platforms
      • Data Catalog
      • Diagnostic & Monitoring Tool
      • OData Service
      • Others
        • Kerberos Authentication
    • 7.0 GA: New Features of the Installer
      • Other Changes
    • 7.0 GA: New Features of Virtual DataPort
      • Data Sources
        • Salesforce.com Data Source
        • JDBC Data Sources
        • DF Data Sources
        • Custom Data Sources
        • HTTP Requests of Data Sources
      • Execution Engine
        • New Data Types
        • Massive Parallel Processing
        • Query Optimizer
        • Cost-Based Optimizer
        • Other Improvements
      • Cache Engine
      • Denodo Stored Procedures
      • Web Services
      • Administration Tool
      • JDBC Driver
      • Administration
      • Privileges
      • Monitoring
      • Denodo4E Eclipse Plugin
      • Others
    • 7.0 GA: New Features of Scheduler
      • VDPIndexer and VDPCache Jobs
      • Import/Export
      • Authentication
      • Deprecated Elements
    • 7.0 GA: New Features of the Embedded Web Container
      • New Version of the Web Container: Apache Tomcat 8.5
      • Allow URIs Slash and Backslash by Default
      • Others
  • 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
        • Main Areas of the Administration Tool
        • Tool Preferences
        • Using the VQL Shell
        • Query Monitor
        • Catalog Search
        • Invalidate Cache
        • Trace Viewer
    • 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
        • Additional Settings
        • Bulk Mode
      • 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
        • Configuring the Cache of a View
        • Memory Usage and Swapping Policy of Views
        • Internationalization Configuration
        • Query Capabilities
        • View Configuration Properties
        • Indexes of Views
        • Statistics of the View
        • Editing the Execution Plan
        • Defining the Data Movements of the View
      • Materialized Tables
      • Temporary Tables
      • Querying Views
        • Execution Trace of a Statement
      • Editing / Replacing a View
        • Modifying Base Views
        • Modifying Derived Views
        • 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
        • Operations Tab
        • Settings Tab (SOAP)
        • Advanced Tab (SOAP)
      • Publishing REST Web Services
        • Resources Tab
        • Settings Tab (REST)
        • Advanced Tab (REST)
      • XSLT Transformations
      • Web Services Authentication
        • HTTP Basic
        • HTTP Basic with VDP
        • HTTP Digest
        • HTTP SPNEGO (Kerberos)
        • OAuth 2.0
        • SAML 2.0
        • Impersonating a User
      • 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
      • Privileges Required
    • 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
        • Creating an Association
        • Multiplicity of Associations
        • Referential Integrity in Associations
        • Role Preconditions
        • Why You Should Define Associations Between Views
      • RESTful Web Service
        • Representations
        • Input Parameters of the RESTful Web Service
        • IDU Requests
        • Requests with Input Compound Values
        • Status Codes
        • Obtaining the Number of Rows of a Result Set
        • Security and Access Privileges
        • Configuring the RESTful Web Service
      • Denodo OData 4.0 Service
        • Serving Metadata
        • Querying Data: The Basics
        • Navigating Associations
        • Advanced Querying
        • Pagination
        • Configuration
        • Entity Collection Streaming
        • Debug Option
        • Privilege Requirements
        • Limitations
        • Features
    • JMS Listeners
      • Creating JMS Listeners
      • Privileges Required
      • Advanced JMS Configuration
        • Acknowledge Mode
        • Acknowledge On Query Finish and Serialized Processing
      • Enabling Advanced Logging for JMS Listeners
    • Remote Tables
      • Managing Remote Tables
        • Creating Remote Tables
        • Editing Remote Tables
        • Refresh Data
        • Dropping 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
        • Memory Usage Settings
        • Swapping Settings
        • Maximum Size of a Query
      • Global Settings of REST Web Services
        • Enable/Disable the OpenAPI Endpoints
        • Accessing the REST Web Services Through a Reverse Proxy
        • Changing the HTTP Header “Content-type”
        • Changing the HTTP Header “WWW-Authenticate”
        • Obfuscating that the REST Web Services are Published by the Denodo Platform
      • Queries Optimization
      • Configuring Runtime Parameters for Stored Procedures
      • Configuring the Default Internationalization
      • Identifiers Charset
        • Restricted Mode
        • Unicode Mode
      • Kerberos Authentication
        • Creating the Roles of the Virtual DataPort Users
        • Creating an LDAP Data Source
        • Setting-Up the Kerberos Authentication in the Virtual DataPort Server
        • Configuring the Administration Tool to Use 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
      • Cache Modes
        • Partial Mode
        • Full Mode
        • Incremental Mode
        • Recommended Parameters for Queries that Load the Cache
        • Caching Very Large Data Sets
        • Caching the Result of Queries that Fail
      • Cache Maintenance Task
        • Maintaining the Underlying Database
      • Specific Information about Cache Databases
        • Amazon Athena
        • Azure SQL Data Warehouse
        • Presto
        • Spark
        • Yellowbrick
        • Databases with HDFS Storage
      • Generic Support for Other Databases
    • Version Control Systems Integration
      • VCS Configuration
        • Virtual DataPort Server Configuration
        • Environment Management
        • Database Configuration
        • Importing an Existing Database from a VCS Server
      • VCS Integration Features
        • Supported Element Types
        • Integration with the Server Explorer
        • VCS Operations for Microsoft TFS and Subversion
        • VCS Operations for GIT
        • Delete Operations
        • Other Version Control Operations
        • Dependencies Management
        • VCS Settings of the Administration Tool
      • Scenarios and Recommended Uses
        • Picking a VCS Workflow
        • Centralized Workflow with Shared Databases
        • Distributed Workflow
        • Centralized Workflow with Private Databases
        • Best Practices to Manage Global Elements
        • Promoting Changes from Development to Testing and Production
        • Using VCS Environments
      • 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
        • Types of Access Rights
        • Column Privileges
        • Row Restrictions
        • Enforcing Column Privileges, Row Restrictions and Custom Policies
        • Roles
      • Administration of Databases, Users, Roles and Their Access Rights
        • Creating Databases
        • Configuring and Deleting Databases
        • Creating Users
        • Modifying and Deleting Users
        • Creating Roles
    • Monitoring the Virtual DataPort Server
      • Monitoring with a Java Management Extensions (JMX) Agent
        • Using JavaTM VisualVM
        • General Information on the Server
        • Information on Data Sources
        • Information on the Cache
        • Information and Events on Catalog Access (DDL Statements)
        • Information and Events on the Running of Statements
        • Information and Events on Transactions
        • Setting the User Agent of an Application
      • Denodo Monitor
        • Local Monitors
        • Server Monitors
        • Virtual DataPort Monitors
        • Configuring the Denodo Monitor
        • Launching the Denodo Monitor
    • Cluster Architectures / Server Backup
      • Denodo Tools
      • How to Check If a Virtual DataPort Server Is Alive
        • Connecting from a JDBC Client Through a Load Balancer
        • Using the Ping Script
        • Alternatives to the Ping Script
      • Using the Import/Export Scripts for Backup And/or Replication
        • Export Script
        • Import Script
      • Launching Several Virtual DataPort Instances of the Same Installation
        • How to Configure the Secondary Instances
        • Deploying Web Services on This Configuration
    • Bulk Data Load
      • Amazon Athena
      • Amazon Redshift
      • DB2
      • Databricks
        • Mounting External File Systems on the DBFS
      • Hive
      • Impala
      • 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
        • Merge Join
        • Nested Join
        • Nested Parallel Join
        • Hash Join
      • Automatic Simplification of Queries
        • Removing Redundant Branches of Queries (Partitioned Unions)
        • Pushing Down GROUP BY Views Below JOIN Views
        • Pushing Down GROUP BY Views Below UNION Views
        • Selecting the Most Optimal Source When the Data Is Replicated in Several Sources
      • Cost-Based Optimization
        • Enabling the Cost-Based Optimization
        • Gathering the Statistics of Views
        • Tuning the Cost-Based Optimization Process
        • Current Limitations of the Cost-Based Optimization Process
      • Data Movement
        • Data Movements From/To Netezza Databases
        • Examples of Data Movement
        • Known Limitations
        • Options of the CONTEXT Clause that Control a Data Movement
      • Parallel Processing
        • Use of an 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
        • Web Services
      • Configuring the Logging System
      • Configuring the Network Interface Restriction in Virtual DataPort
      • 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
        • Apache ActiveMQ 5.6.0
        • IBM WebSphere MQ 7.0
        • Progress SonicMQ 8.0
      • Execution Trace Information
      • Web Services Created with Previous Versions of the Denodo Platform
        • Publishing Web Services
        • XSLT Transformations of Web Services Created with Previous Versions
        • SOAP Over JMS on Web Services Created with Previous Versions of the Denodo Platform
        • Authentication in Web Services Created with Previous Versions
        • Types Conversion Table for REST / SOAP Web Services Created with Previous Versions
        • Invoking Web Services Created with Previous Versions
      • 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
      • Scope
      • Who Should Use This Document
      • Summary of Contents
    • Introduction
      • Examples
    • Access Through JDBC
      • JDBC Driver Parameters
      • Connecting to Virtual DataPort Through a Load Balancer
      • Connecting to Virtual DataPort Using Kerberos Authentication
        • When the Client Application Does Not Belong to the Domain
      • Details of the JDBC Interface
        • Description of Views and Their Fields
        • Retrieving the Content Type of Blob Values
        • Working with Datetime Values with the Denodo JDBC Driver
        • Obtaining the Names of Elements Inside a Struct (Register)
        • Connecting from Applications that Filter Incoming Serialization Data
        • Queries with Datetime Literals
    • Access Through ODBC
      • Configuration of the ODBC Driver on Windows
        • Install the ODBC Driver on Windows
        • Set Up a DSN on Windows
      • Configuration of the ODBC Driver in Linux and Other UNIX
        • Obtain the Appropriate ODBC Driver
        • Install UnixODBC
        • Register the Denodo ODBC Driver in UnixODBC
        • Register a Data Source (DSN) on UnixODBC
        • Compiling UnixODBC
        • Troubleshooting Issues
      • Creating a DSN-Less Connection
      • Details of the ODBC Interface
        • How the ODBC Interface Reports the Datetime and Interval Data Types
      • Integration with Third-Party Applications
        • Supporting Queries with Brackets
        • Maximum Length of Text Values
        • Maximum Length of Error Messages
        • Disabling Transactions
      • Backward Compatibility of the ODBC Driver
    • Access Through an ADO.NET Data Provider
      • Using Kerberos Authentication
    • Access Through OLE DB
    • Developing Extensions
      • Developing Custom Functions
        • Creating Custom Functions with Annotations
        • Creating Custom Functions Using Name Conventions
        • Compound Types
        • Custom Function Return Type
        • Getting Information About the Context of the Query
        • Dealing with Datetime and Interval Types
      • Developing Stored Procedures
        • Using Datetime Values in Denodo Stored Procedures
        • Required Libraries to Develop Stored Procedures
      • Developing Custom Wrappers
        • Required Libraries to Develop Custom Wrappers
        • Extending AbstractCustomWrapper
        • Overriding AbstractCustomWrapper
        • Dealing with Conditions
        • Dealing with the ORDER BY Clause
        • Configuring a Custom Wrapper
        • Updating the Custom Wrapper Plan
        • Dealing with Datetime and Interval Types
      • Developing Custom Input Filters
        • Required Libraries to Develop Custom Filters
        • Developing Custom Filters
    • Custom Policies
      • Developing a Custom Policy
    • Appendix
      • Output Schema of the LIST Command
      • Output Schema of the DESC Commands
      • Error Codes Returned by Virtual DataPort
      • Compile the Denodo ODBC Driver
        • Pre-requisites to Compile the ODBC Driver on Linux
        • Compile the ODBC Driver (Standard Method)
        • Compile the ODBC Driver to Obtain Forwardable Tickets
        • Troubleshooting the Compilation of the Denodo ODBC Driver
  • Virtual DataPort VQL Guide
    • Preface
      • Scope
      • Who Should Use This Document
      • Summary of Contents
    • Introduction
    • General Overview of Virtual DataPort
      • Creating or Defining Data
        • Defining Base Views
        • Defining Data Sources and Wrappers
        • Defining the Views of the Global Schema
      • 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
        • JDBC Data Sources
        • ODBC Data Sources
        • Multidimensional Data Sources
        • Data Sources for SOAP Web Services
        • XML Data Sources
        • JSON Sources
        • DF Data Sources
        • Denodo Aracne Data Sources
        • Google Search Data Sources
        • LDAP Data Sources
        • BAPI Data Sources
        • Salesforce Data Sources
        • Custom Data Sources
        • Data Source Configuration Properties
        • Specifying Paths in Virtual DataPort
      • Creating Wrappers
        • Execution Context and Interpolation Strings
        • Wrapper Metadata
        • JDBC Wrappers
        • Multidimensional Databases Wrappers
        • ODBC Wrappers
        • WWW Wrappers
        • Web Services Wrappers
        • XML Wrappers
        • JSON Wrappers
        • DF Wrappers
        • Denodo Aracne Wrappers
        • Google Search Wrappers
        • LDAP Wrappers
        • BAPI Wrappers
        • Salesforce Wrappers
        • CUSTOM Wrappers
        • Wrapper Configuration Properties
      • 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
        • Query Constraints
        • Assigning Wrappers to Search Methods
        • Example of How a Search Method Is Created
      • Modifying a Base View
    • Queries: SELECT Statement
      • FROM Clause
        • JOIN Operation
        • INTERSECT Operation
        • MINUS Operation
        • FLATTEN View (Flattening Data Structures)
        • Subqueries in the WHERE Clause of the Query
      • 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
    • 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
        • CACHE_CONTENT
        • CATALOG_ELEMENTS
        • CATALOG_FKS
        • CATALOG_METADATA_VIEWS
        • CATALOG_PERMISSIONS
        • CATALOG_PKS
        • CATALOG_VDP_METADATA_VIEWS
        • CATALOG_VIEWS
        • CLEAN_CACHE_DATABASE
        • COLUMN_DEPENDENCIES
        • COMPACT_HADOOP_CACHE
        • COMPACT_METADATA_TABLES
        • CREATE_REMOTE_TABLE
        • DROP_REMOTE_TABLE
        • DUAL
        • GENERATE_SMART_STATS_FOR_FIELDS
        • GENERATE_SMART_STATS_FOR_FIELDS_BY_TABLENAME
        • GENERATE_STATS
        • GENERATE_STATS_FOR_FIELDS
        • GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW
        • GET_ACTIVE_LOGGERS
        • GET_ASSOCIATIONS
        • GET_CACHE_COLUMNS
        • GET_CACHE_CONFIGURATION
        • GET_CACHE_TABLE
        • GET_CATALOG_EFFECTIVE_PERMISSIONS
        • GET_CATALOG_METADATA_WS
        • GET_DELEGATED_SQLSENTENCE
        • GET_ELEMENTS
        • GET_EXPORTED_KEYS
        • GET_FOREIGN_KEYS
        • GET_JDBC_DATASOURCE_TABLES
        • GET_PRIMARY_KEYS
        • GET_PROCEDURE_COLUMNS
        • GET_SERVER_CONNECTIVITY
        • GET_SESSIONS
        • GET_SOURCE_CHANGES
        • GET_SOURCE_COLUMNS
        • GET_SOURCE_TABLE
        • GET_TYPE_ATTRIBUTES
        • GET_USER_DEFINED_TYPES
        • GET_VIEW_COLUMNS
        • GET_VIEW_INDEXES
        • GET_VIEW_STATISTICS
        • GET_VIEWS
        • LIST_JDBC_DATASOURCE_TABLES
        • LOGCONTROLLER
        • MIGRATE_DATE_TYPES
        • PING_DATA_SOURCE
        • SOURCE_CHANGES
        • VIEW_DEPENDENCIES
        • WAIT
        • WEBCONTAINER_ELEMENTS
        • WEBCONTAINER_ELEMENT_STATUS
        • WRITELOGERROR
        • WRITELOGINFO
    • 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
        • Modifying and Deleting Users
        • Connecting to Another Database
        • Modifying the Privileges of a User
        • Managing User Roles
      • 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
        • Basic and Digest
        • OAuth 2.0 and OpenID
        • 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
        • DVCSCOMMIT
        • DVCSPUSH
        • DVCSPULL
        • DVCSREVERT
      • 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
      • 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
        • Arithmetic Functions
        • Text Processing Functions
        • Datetime Processing Functions
        • XML Processing Functions
        • Type Conversion Functions
        • Aggregation Functions
        • Analytic Functions (Window Functions)
        • Other Functions
      • Syntax of Search Expressions for the Contains Operator
        • Exact Terms and Phrases
        • Term Modifiers
        • Boolean Operators
        • Groups
        • Escaping Special Characters
      • 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
      • Scope
      • Who Should Use This Document
      • Summary of Contents
    • Introduction
    • Installation and Execution
      • Launching the Data Catalog
    • Authentication and Authorization
    • Administration
      • Servers Configuration
        • Configure the Virtual DataPort Servers
        • Configure the Connection Settings to the Virtual DataPort Servers
        • Configure the Database Used by Data Catalog
      • Content Search Configuration
      • Kerberos Configuration
      • Personalization
        • Elements Shown to the Users
        • Browse Configuration
        • User Interface
        • Export Format Configuration
        • Database, View and Web Service Connection URIs
        • Usage Statistics
      • Catalog Management
        • Categories Configuration
        • Tags Configuration
        • Databases Configuration
        • Elements Configuration
        • Property Groups Configuration
      • Import and Export Data Catalog Metadata
        • Import and Export Data Catalog Metadata from the UI
        • Import and Export Data Catalog Metadata Using a Script
    • Configuration
    • Browse
      • Databases
      • Categories
      • Tags
      • Relationships
      • Views
        • Summary of Views
        • Query of Views
        • Associations of Views
        • Lineage of Views
        • Search of Views
        • Usage of Views
      • Web Services
        • Summary of Web Services
        • Query a Web Service
    • Saved Queries
      • Deploying Saved Queries
      • Copying Saved Queries
    • Search
      • Catalog Search
      • Content Search
      • Queries
    • Appendix
      • Installing the Data Catalog on a Cluster: Sharing the Same Settings Across All the Nodes
        • Setting Up the Common Database
        • Configure the Data Catalog to Use the Common Database
      • REST API
        • Synchronize Elements with the Server
        • Compute the Usage Statistics
        • Export Metadata
        • Import Metadata
        • Ping Data Catalog
      • Apache Lucene Search Syntax
        • Terms
        • Fields
        • Term Modifiers
        • Boolean Operators
        • Grouping
        • Field Grouping
        • Escaping Special Characters
  • Diagnostic & Monitoring Tool Guide
    • Preface
      • Scope
      • Who Should Use This Document
      • Summary of Contents
    • 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
      • Monitoring Servers
        • Monitoring - Resources
        • Monitoring - State
        • Monitoring - Sessions
        • Monitoring - Requests
        • Monitoring - Cache
        • Monitoring - Data Sources
        • Monitoring - Threads
      • Monitoring Environments
      • Overview
    • Creating Diagnostics and Diagnostic Intervals
      • Creating Diagnostics
      • Creating Diagnostic Intervals
    • Diagnosing
      • Diagnosing - Resources
      • Diagnosing - State
      • Diagnosing - Sessions
      • Diagnosing - Requests
      • Diagnosing - Cache
      • Diagnosing - Data Sources
      • Diagnosing - Threads
      • Diagnosing - Errors
    • Export and Import
      • Export
      • Import
    • Configuration
      • User Configuration
        • Configuration - General
        • Configuration - Overview
        • Configuration - Resources
        • Configuration - State
        • Configuration - Sessions
        • Configuration - Requests
        • Configuration - Cache
        • Configuration - Data Sources
        • Configuration - Threads
        • Configuration - Errors
      • Server Configuration
        • Informative Message
  • Virtual DataPort API Javadoc
  • Scheduler Administration Guide
    • Preface
      • Scope
      • Who Should Use This Manual
      • Summary of Contents
    • Introduction
    • General Architecture
    • Installation and Execution
    • Administration
      • Authentication
      • Web Configuration
        • User Configuration
        • Kerberos Configuration
        • Informative Message Configuration
      • Scheduler Server Configuration
        • Server Configuration Sections
        • Permissions
        • Plugins and JDBC Adapters
      • Log Configuration
    • Creating and Scheduling Jobs
      • Jobs
      • Data Sources
        • ARN Data Sources
        • Scheduler Index Data Sources
        • CSV Data Sources
        • Elasticsearch Sources
        • ITP Data Sources
        • JDBC Data Sources
        • VDP Data Sources
      • Filter Sequences
      • Configuring New Jobs
        • General Structure of a Job
        • Aracne-type Job Extraction Section
        • VDP Extraction Section
        • ITP Extraction Section
        • JDBC Extraction Section
        • VDPCache Extraction Section
        • VDPIndexer Extraction Section
        • Data Schema Generated by the Different Types of Extraction Jobs
        • Jobs for Maintaining Aracne Indexes
        • Postprocessing Section (Exporters)
        • Retry Section
        • Handler Section
        • Time-based Job Scheduling Section
        • Dependencies Among Jobs
    • Developer API
      • Scheduler Client API
      • Extensions (Plugins)
        • Filters
        • Exporters
        • Handlers
        • Aracne Custom Crawlers
    • Appendix
      • Dateformat Function Syntax
      • Regular Expressions for Filters
      • JDBC Drivers
      • Use of the Import/Export Scripts for Backup (Scheduler)
        • Export
        • Import
      • Use of the Import/Export Scripts for Backup (Scheduler Index)
        • Export
        • Import
      • Use of the Ping Script
      • ChangePassword Script (Scheduler)
      • ChangePassword Script (Scheduler Web Administration Tool)
      • ChangePassword Script (Scheduler Index)
  • Scheduler API Javadoc
  • ITPilot User Guide
    • Preface
      • Scope
      • Who Should Use This Document
      • Summary of Contents
    • Introduction
      • Denodo ITPilot Environments
        • Administration Tool
        • Generation Environment
        • Execution Environment
        • Verification Environment
    • Distribution of Environments
      • Distribution of the Generation Environment
      • Distribution of the Execution Environment
      • Distribution of the Verification Environment
    • Installation and Initial Configuration
    • Execution
      • Starting Up the Administration Tool
      • Starting Up the Browser Pool
      • Starting Up the Wrapper Server
      • Starting Up the Verification Server
      • Starting Up the Verification Server with a Graphical Tool
      • Starting Up the PDF Conversion Server
    • Web Administration Tool
      • Adding, Editing and Deleting Servers
      • Configuring the Browser Pool Server
        • Global Configuration Parameters
        • MSIE and Denodo Browser Configuration
      • Configuration of the Wrapper Server
        • List of Wrappers
        • Server Configuration (Wrapper Server)
        • Embedded Denodo Browser Configuration
        • Extensions
      • Configuring the Verification Server
        • Server Configuration (Verification Server)
        • Database Configuration
        • Mail Configuration
        • Rules Configuration
    • Verification Server Graphical Configuration and Monitoring Tool
      • An Overview of the Graphical Tool
      • Configuration of the Verification Environment
      • Monitoring the Wrappers Under Verification
    • Wrapper Execution Trace Logs
      • Enabling Wrapper Trace Logging
      • Log Categories and Effective Log Level
      • Appenders
        • Configuring Custom Appenders
        • Custom Appenders and Logger Additivity
  • ITPilot Generation Environment Guide
    • Preface
      • Scope
      • Who Should Use This Document
      • Summary of Contents
    • Introduction
      • Presentation
      • Development of Component-Based Wrappers
    • Installation and Execution
      • Introduction to the Tools
    • Generation Environment Tools - Part I
      • Presentation of the Example
      • Creating Projects and Wrappers
      • Components in ITPilot
        • Input and Output Parameters
      • Process Initialization
        • Use of the Catalog Explorer
      • Web Browsing Automation
        • Component Configuration
        • Comparison Between MSIE and Denodo Browser
        • Advanced Configuration of the Sequence and Next Interval Iterator Components
        • Error Processing on the Web Browsing Automation
      • Configuration of the Extractor Component
        • Defining the Structure of the Data and Assigning Examples
        • Generating a DEXTL Specification from the Examples
        • Testing the Generated Specification
        • Locale Configuration of the Extractor Component
        • Error Processing on the Extractor Component
      • Processing the Retrieved Results
        • Use of the Iterator Component
        • Processing the Individual Records: Use of Record Constructor
        • Returning Results: Output Component
      • Wrapper Generation, Tests and Exporting
        • Wrapper Generation
        • Wrapper Execution
        • Deploying Wrappers to the Wrapper Server
    • Generation Environment Tools - Part II
      • Extracting Multipaginated Data
        • Pagination Using Single Block or Multiple Block Schemes
      • Access to Details Pages
        • Access to the Details Page: Using Extractor Sequence
        • Individual Test of Extractor Sequence, Next Interval Iterator and Form Iterator Components
        • Specifying the Structure of the Detail Page Information
        • Generating the Access Specification to the Details Page
        • Iteration on the Details Page Structures and Creation of the Output Record
      • Generation Tool Global Preferences
      • Tagsets and Scanners
        • Understanding Tagsets
        • Graphical Creation of New Tagsets
        • Tagsets and Scanners Included in the Distribution
        • Lexer Types
      • Generating the Data Extraction Specifications Manually
        • Creating a Structure Using the Structure Pane
        • Obtaining the Tokens of the Data to Extract
        • Creating a DEXTL Specification from the Tags
      • Using the Sequence Debugger
        • Breakpoint Management
      • Saving a Flow as a Custom Component
        • Deploying a Custom Component to the Wrapper Server
      • Wrapper Advanced Options: Specific Browser Pool and Locale
        • Specific Browser Pool
        • Locale
      • Migrating Wrappers Between Generation Environments: Import and Export
        • Exporting Wrappers
        • Importing Wrappers
      • Managing Extensions
        • Adding Extensions
        • Deleting Extensions
        • Exporting a Flow as an Extension
    • Generating Navigation Sequences
      • Description of the Navigation Sequences Generator Interface
        • Toolbar State Info Dialog
      • Steps for Generating a Navigation Sequence
        • Checking Navigation Sequences in Systems with Cookie-Based Session Authentication and Maintenance
      • The SelectFrame Action
      • The Transpose Table Button and Action
      • The Cancel Navigation Button
      • Recording Sequences with Passwords
      • Properties of the Navigation Bar
        • Generating Sequences Using an Authenticated Proxy
        • Criteria for Selecting NSEQL Commands
        • Advanced Options
      • XPath Generator Utility
    • Appendix A: ITPilot Operators
      • Logical Operators
      • Comparison Operators
    • Appendix B: ITPilot Functions
      • Arithmetic Functions
      • Text Processing Functions
      • Functions for Handling Null Values
      • Functions for Handling Lists
      • Date Processing Functions
      • Type Conversion Functions
      • Functions for URL Processing
      • Functions for Page Handling
      • Functions for Handling Compressed Files
      • Extraction Functions
      • Case Clause
    • Appendix C: Catalog of Components
      • Add Record To List
      • Condition
      • Using the Conditions Editor
      • Create List
      • Create Persistent Browser
      • Diff
      • Execute JavaScript
      • Expression
        • Using the Expressions Editor
      • Extractor
      • Extractor Sequence
      • Filter
      • Form Iterator
      • Get Page
      • INIT
      • Iterator
      • JDBC Extractor
      • Loop
      • Next Interval Iterator
      • Output
      • Record Constructor
      • Release Persistent Browser
      • Repeat
      • SaveFile
      • Script
      • Sequence
    • Appendix D: Constraints of the Simplified DOM
    • Appendix E: List of Reserved Words
  • ITPilot Developer Guide
    • Preface
      • Scope
      • Who Should Use This Document
      • Summary of Contents
    • Introduction
    • ITPilot Development API
    • Connecting to the Server
      • Obtaining Wrappers
      • Using Wrappers
      • Processing Query Results
        • Canceling Queries
      • Example of Use
    • Creating Custom ITPilot Functions
      • Naming Conventions and Annotations
      • Compound Types
      • Page Type
      • Custom Function Return Type
      • Example
  • ITPilot DEXTL Guide
    • Preface
      • Scope
      • Who Should Use This Manual
      • Summary of Contents
    • Introduction
    • An Overview of DEXTL
    • Basic Syntax
      • Fundamentals of Pattern Specification
      • Ambiguity of Patterns and Demarcation of the Search Space
      • Relations and Subrelations
    • Advanced Syntax
      • Extracting Tag Attributes
      • Tags with Evaluated Attributes
      • Voracious Separators
      • Dynamic Separators
      • Attributes with FIXED Value and Default Value
      • Format Tags
        • Tagsets
      • Hierarchy of Elements
      • Alternative Specifications
      • Scanners
        • Lexer Types
      • Structure of a DEXTL Program
        • Declarations Section
        • Specification Section
      • Escape Characters in DEXTL
    • DEXTL Quick Reference Sheets
    • Putting All Together
      • Browser View
      • HTML Code View
      • FORMAT TAGS VIEW
      • DEXTL VIEW
      • RESULTS VIEW
  • ITPilot NSEQL Guide
    • Preface
      • Scope
      • Who Should Use This Manual
      • Summary of Contents
    • Introduction
    • Basic Concepts of NSEQL
      • Navigation Sequences: Basic Syntax
      • NSEQL Commands: General Overview
      • Configuration of Page Waiting Times
      • Example
    • List of NSEQL Commands
      • Usual Parameters
      • Error Parameters
      • Navigation Commands
        • CANCELNEXTNAVIGATION
        • CANCELNAVIGATION
        • EXTENDEDWAITPAGES
        • GOBACK
        • GOFORWARD
        • NAVIGATE
        • IGNORENAVIGATIONERRORS
        • SETMAXDOWNLOADTIME
        • NAVIGATEEXTENDED
        • POSTDATA
        • REFRESH
        • STOP
        • WAIT
        • WAITPAGES
      • Commands for Processing Links
        • CLICKONANCHORBYHREF
        • CLICKONANCHORBYHREFREC
        • CLICKONANCHORBYPOSITION
        • CLICKONANCHORBYTEXT
        • CLICKONANCHORBYTEXTREC
        • CLICKONAREABYHREF
        • CLICKONAREABYPOSITION
        • SELECTANCHORBYHREF
        • SELECTANCHORBYHREFREC
        • SELECTANCHORBYPOSITION
        • SELECTANCHORBYTEXT
        • SELECTANCHORBYTEXTREC
        • SETTARGETURL
      • Commands for Selecting Forms
        • FINDFORMBYACTION
        • FINDFORMBYACTIONREC
        • FINDFORMBYNAME
        • FINDFORMBYNAMEREC
        • FINDFORMBYPOSITION
        • RESETFORM
      • Commands for Executing Actions on Elements of a Form
        • CLICKONELEMENT
        • CLICKONINPUTELEMENT
        • FIREEVENT
        • SELECTINDEXBYPOSITION
        • SELECTINDEXBYTEXT
        • SELECTINDEXBYVALUE
        • SELECTOPTIONBYPOSITION
        • SELECTOPTIONBYTEXT
        • SELECTOPTIONBYVALUE
        • SETINPUTVALUE
        • SETTEXTAREAVALUE
        • SETVALUE
        • SETCHECKED
        • SUBMITFORM
        • UNSELECTALL
      • Frame Selection Commands
        • FINDFRAMEBYNAME
        • FINDFRAMEBYNAMEREC
        • FINDFRAMEBYPOSITION
        • FINDFRAMEBYSOURCE
        • FINDFRAMEBYSOURCEREC
        • RESETFRAME
      • Commands for Selecting Elements
        • FINDACTIVEELEMENTINDOCUMENT
        • FINDCHILDELEMENTBYATTRIBUTE
        • FINDCHILDELEMENTBYPOSITION
        • FINDCHILDELEMENTBYTEXT
        • FINDELEMENTBYATTRIBUTE
        • FINDELEMENTBYATTRIBUTEREC
        • FINDELEMENTBYCHILD
        • FINDELEMENTBYCHILDREC
        • FINDELEMENTBYPOSITION
        • FINDELEMENTBYTEXT
        • FINDELEMENTBYTEXTREC
        • FINDELEMENTBYXPATH
      • Commands for Executing on Actions on Elements
        • CLICKONSELECTEDELEMENT
        • FIREEVENTONSELECTEDELEMENT
        • TRANSPOSESELECTEDTABLE
      • Commands for Handling Windows
        • ALLOWOPENNEWWINDOWS
        • CLOSEWINDOW
        • GETWINDOWNAME
        • OPENALERTDIALOGSINNEWWINDOW
        • OPENNEWWINDOW
        • OPENNEWWINDOWSUNNAMED
        • OPENWEBPAGEDIALOGSINNEWWINDOW
        • SELECTWINDOW
        • SETWINDOWNAME
        • CLOSEINACTIVEWINDOWS
      • Commands for Handling Pop-Up Dialogs
        • ONDIALOG
        • ONPRINTDIALOG
        • ONWEBPAGEDIALOG
        • ONCERTIFICATEDIALOGDENODOBROWSER
        • SETDIALOGPROPERTIES
        • SETSILENT
      • Commands for Editing the Browser Properties
        • SETAMBIENTPROPERTIES
        • SETPROXYAUTHINFO
        • SETUSERAGENT
      • Informative Commands
        • FINDCOOKIES
        • GETEXTENDEDSOURCECODE
        • GETLASTURL
        • GETLASTURLPOSTPARAMETERS
        • GETLOCATION
        • GETMIMETYPE
        • GETSELECTOPTIONS
        • GETSOURCECODE
        • GETTITLE
        • ISDOWNLOADING
        • QUERYDOWNLOADEDPAGES
      • Conversion Commands
        • CONVERTEXCELTOHTML
        • CONVERTWORDTOHTML
        • CONVERTPDFTOHTML
      • Commands for Saving Files
        • SAVEFILE
      • Commands for Executing Code
        • EXECUTEJS
        • EXECUTEJSBEFORELOAD
      • Commands for Clearing Browser Data
        • CLEARPERSISTENTCOOKIES
        • CLEARCACHE
    • Util Functions
      • EncodeSEQ
  • ITPilot API Javadoc
  • Solution Manager Installation Guide
    • Preface
      • Who Should Use This Document
    • Preinstallation Tasks
      • Hardware Requirements
      • Software Requirements
        • Supported Platforms
        • Supported Java Runtime Environments (JRE)
        • Supported Browsers
      • Other Preinstallation Tasks
        • Check that the Required Ports are Free
        • Check the PATH Environment Variable on Windows
        • Select a User Account to Install the Solution Manager
      • Download the Installer
    • Using the Graphical Installation Wizard
      • Commons Settings
      • Components and Configuration of Virtual DataPort
      • Components and Configuration of Solution Manager
      • Components and Configuration of Web Panel
      • Embedded Web Container
    • 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
      • Install the Latest Update
      • Change the Default Passwords
      • Install the License
      • Enable SSL/TLS in the Solution Manager
        • Obtaining and Installing an SSL Certificate
        • Enabling SSL/TLS in Solution Manager Servers
      • Configure Windows Services
      • Installing the Solution Manager Web Applications as Windows Services
      • Post-Installation Tasks: Virtual DataPort
      • High Availability
      • Disable “Export” Endpoint of the Web Container
    • Denodo Platform Control Center
      • Starting Platform Servers and Tools
      • Installing Updates and Hotfixes
      • Virtual Machine and Web Container Configuration
      • Configuration of the JVM Parameters from the Command Line
      • Control Center Help
      • Uninstalling the Solution Manager
    • Appendix
      • Default Ports Used by the Solution Manager Modules
      • Using Kerberos Authentication in Virtual DataPort Without Joining a Kerberos Realm
      • Using Kerberos Authentication in Solution Manager Without Joining a Kerberos Realm
      • Providing a Krb5 File for Kerberos Authentication
      • Launching the Denodo Standalone Applications in High DPI Displays
      • Troubleshooting the Solution Manager Installer
      • Transparent Metadata Encryption in the Solution Manager
      • Configuring the Network Interface Restriction in the Solution Manager
  • Solution Manager Administration Guide
    • Preface
      • Scope
      • Who Should Use This Document
      • Summary of Contents
    • Introduction
      • General Architecture
    • Launching the Solution Manager Components
      • Launching the Solution Manager Virtual DataPort Server
      • Launching the License Manager Server
      • Launching the Solution Manager Server
      • Launching the Solution Manager Administration Tool
    • Introducing the Solution Manager Administration Tool
    • Authentication and Authorization
      • Authenticating with Virtual DataPort
      • Authenticating with Kerberos
      • Authorization
        • Solution Manager Administrator
        • Promotion Administrator
        • Promotion Administrator for Certain Environments
        • Promotion
        • Promotion for Specific Environments
        • Overview of the Promotion Roles
        • JMX Administrators
        • Global Administrator
        • Developer
    • Environments
      • Creating Environments
      • Configuring Environments
        • Configuring Virtual DataPort Properties
        • Configuring Deployments
        • Configuring Deployment Scripts
        • Configuring Environment Logging Level
    • Clusters
      • Creating Clusters
      • Configuring Clusters
        • Configuring Cluster Load Balancing Variables
        • Configuring Scheduler Properties
        • Configuring Cluster Logging Level
    • 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
      • Creating Revisions
        • General Options
        • Additional Options
        • Revision Candidate Elements
      • Create Revisions from VQL
      • Revisions Table
        • Create a Revision
        • Edit a Revision
        • See the Information of a Revision
        • Remove Revisions
        • Filter Revisions in the Table
        • Download the Metadata of a Revision
        • Validate a Revision
        • Check the Validation Summary of a Revision
        • Copy Revision
        • Deploy Revisions
        • Check the Environments where a Revision Was Deployed
      • Deploying Revisions
        • Deployment Preconditions
        • Deployment Paradigms
        • Cache Limitations
      • Deployments Table
        • Cancel Deployments
        • Filter Deployments in the Table
        • Check the Progress Summary of a Deployment
        • See the Errors of a Deployment
        • See the Revisions of a Deployment
        • Download Backup Data for a Deployment
      • Deployment Progress
    • License Management
      • Install a License
        • Check Global License Information
      • Assign a License to an Environment
        • Check the License Information for an Environment
      • Assign a License to a Server
      • How Licenses Work
        • How a Server Resolves its License
        • How Denodo Servers Behave on License Responses
      • License Usages Table
    • Monitoring
      • Monitoring Configuration
      • JDBC Logging Configuration
    • Configuration
      • Setting-Up an External Database
        • Changing the Password of the External Database
      • VCS Configuration
      • Setting-Up the Informative Message
    • Import and Export Catalog
    • Appendix
      • REST API
        • Get the List of Environments
        • Create an Environment
        • Get the List of Licenses Available
        • Update an Environment
        • Delete an Environment
        • Get the List of Virtual DataPort Properties Associated to an Environment
        • Create and Delete Environment Properties
        • Get the List of Clusters
        • Create a Cluster
        • Get a Cluster
        • Update a Cluster
        • Delete a Cluster
        • Get the List of Scheduler Properties Associated to a Cluster
        • Create and Delete Cluster Properties
        • Get the List of Servers
        • Create a server
        • Get a Server
        • Update a Server
        • Delete a Server
        • Get the List of Revisions
        • Create a Revision from a VQL file
        • Get the List of Deployments
        • Start a New Deployment from a List of Revisions
        • Get the Progress of a Deployment
        • Free License Usage
        • Ping License Manager Server
        • Ping to Solution Manager Server
      • Best Practices: Deployment of Updates Across Your Organization
        • Updating Solution Manager with High Availability
      • Solution Manager Compatibility with the Denodo Platform Servers
      • How To Initialize a Git Repository
  • Web Panel Guide
    • Preface
      • Scope
      • Who Should Use This Document
      • Summary of Contents
    • Installation and Execution
      • Launching the Web Panel Administration Tool
      • Installing Web Panel as Windows Service
    • Accessing Denodo Web Tools
    • Administration
      • Authentication
      • Configuration
        • Virtual DataPort Server Set-Up
        • Kerberos Set-Up
        • Informative Message Set-Up
      • Web Applications Management
  • Denodo4E User Guide
    • Preface
      • Scope
      • Who Should Use This Document
      • Summary of Contents
    • Installing Denodo4E
    • VDP/ITP Server Tutorial
      • Creating an Extension Project with a Custom Stored Procedure
      • Creating Debug Configurations for the VDP/ITP Server and the VDP Administration Tool
      • Starting the VDP/ITP Server in Debug Mode
      • Debugging the Stored Procedure
      • Deploying the Stored Procedure
    • Wrapper Generation Tool Tutorial
      • Creating an Extension Project with an ITPilot Custom Function
      • Creating a Debug Configuration for the Wrapper Generation Tool
      • Starting the Wrapper Generation Tool
      • Debugging the Custom Function
      • Deploying the Custom Function
    • Reference of the Dialogs of the Denodo4E Plugin
      • Create
        • The Denodo Extension Project Wizard
        • The Denodo Extension Wizard
      • Debug
        • Denodo Application Debug Configuration
        • Supported Denodo Applications
        • Support for Dependencies
        • Debug Remote Applications
      • Deploy
        • The Deploy Wizard
      • Supported Extension Types
  • DenodoConnect Components
    • Apache Zeppelin for Denodo - 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 - User Manual
    • Denodo Dialect for Spark SQL - 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 DynamoDB Custom Wrapper - User Manual
    • Denodo Email Exported Files Custom Handler - User Manual
    • Denodo FileSystem CustomWrapper - User Manual
    • Denodo Geo Service - User Manual
    • Denodo Google Sheets Custom Wrapper - User Manual
    • Denodo Google Sheets Tool - User Manual
    • Denodo Governance Bridge - User Manual
    • Denodo GraphQL Service - User Manual
    • Denodo HBase CustomWrapper - User Manual
    • Denodo HL7 FHIR Service - 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 MDX Service - 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 Replicator - User Manual
    • Denodo SFTP Exported Files Custom Handler - User Manual
    • Denodo SSH Custom Wrapper - User Manual
    • Denodo SalesForce REST Custom Wrapper - User Manual
    • Denodo ServiceNow Templates - Quick guide
    • Denodo Tableau Exporter - User Manual
    • Denodo Templates for Adobe Analytics - Quick Use Guide
    • Denodo Templates for Google Analytics - Quick Use Guide
    • Denodo Templates for SharePoint - Quick Use Guide
    • Denodo Templates for Twitter - Quick Use Guide
    • Denodo Testing Tool - User Manual
    • Denodo VQL Generation Stored Procedures - 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 BYOL Quick Start Guide
  • Denodo Platform for Azure BYOL Quick Start Guide
  • Denodo Platform for Azure Quick Start Guide
  • Denodo Platform for GCP BYOL Quick Start Guide
  • Denodo Platform for GCP Quick Start Guide
Important: To see the latest version of the document click here
  • User Manuals /
  • Data Catalog Guide /
  • Search /
  • Content Search

Content Search¶

This feature is only available if an administrator has set-up a search index for the selected server (the section Content Search Configuration explains how to enable it). That is because the searches are performed on that index and not querying the views on real time.

When you access this tab, you can choose whether to search in all the databases and views or to select some of them.

The tool searches on the values of all the fields of all the indexed views. As result, it displays the views where results were found and the number of results per view (10 by default). To see a summary of the results of a view, click Details (image0). The administrator can configure the number of results and the fields to be shown for each view, on that summary.

Note that you will only see the information over which you have permissions defined in Virtual DataPort. This way:

  • Views with row restrictions are not shown it in the search results.

  • Views with column privileges only show the columns with permissions in the search results.

Search results

Search results¶

To load a particular view and/or access to its complete results, click on its name to open the Search tab of that view (see section Search of Views). In this case, if you have specified any keyword when searching, the results of the view will show all the filtered results of that search.

You can also click on the database name to browse it.

Queries Catalog Search

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