Table of Contents

• 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
    • Main Areas of the Administration Tool
    • Tool Preferences
      • Authentication
      • Locale
      • Connection Parameters
      • VCS Configuration
    • Using the VQL Shell
    • Query Monitor
    • Catalog Search
    • Invalidate Cache
    • Trace Viewer
    • Maximum Session Idle Timeout
  • Starting the Design Studio
    • Main Areas of the Design Studio
    • Design Studio Preferences
      • Connection Options
      • Kerberos Settings
      • Informative Message
      • Application Settings
      • Disable the Preferences Page of Design Studio
    • Using the Design Studio VQL Shell
    • Design Studio Query Monitor
    • Design Studio Catalog Search
    • Design Studio Invalidate Cache
    • Design Studio Trace Viewer
    • Logging in to Design Studio
• Creating Data Sources and Base Views
  • JDBC Sources
    • Preparing the Connection to the Database
    • Importing JDBC Sources
      • Initial SQL Statements
      • Connection Pool
      • “Read & Write” Tab
      • “Source Configuration” Tab
      • Metadata Tab
    • Database Specific Information
      • Alibaba Cloud MaxCompute
      • Amazon Athena and PrestoDB/Trino
      • Amazon Redshift
        • Amazon Athena and Amazon Redshift STS and S3 AWS Regions
      • Apache Impala
      • Cassandra
      • Elasticsearch
      • IBM DB2
      • Informix
      • Azure Synapse SQL
      • Microsoft SQL Server
      • Oracle
        • How Oracle Proxy Authentication Works
        • The REGEXP Function and Regular Expressions with Lookahead Assertions
      • SAS
        • NULL Values
        • CAST
        • Leading Blanks in Text Fields
        • Boolean Values
        • Concatenation of Text Fields
        • BETWEEN Operator
        • IN Operator
        • JOINS
        • IDU Operations
      • Spark SQL
      • Teradata
      • Yellowbrick
      • SAP HANA
        • SAP HANA Input Parameters
        • Conditions with Multiple Values for Input Parameters
        • SAP HANA Input Variables
        • Group By Views with Input Parameters and Input Variables
      • Generic Adapter
    • Connecting to a JDBC Source with Kerberos Authentication
      • Kerberos Authentication with Constrained Delegation
    • Connecting to a JDBC Source with OAuth Authentication
    • Creating Base Views from a JDBC Data Source
    • Importing Graphically Stored Procedures from a Database
      • Importing Stored Procedures from IBM DB2
      • Importing Stored Procedures from Microsoft SQL Server
      • Importing Stored Procedures from Oracle
      • Importing Stored Procedures from PostgreSQL
    • Creating Base Views from SQL Queries
      • Using the WHEREEXPRESSION Variable
      • Creating Base Views from a Query to a Stored Procedure
  • ODBC Sources
    • Enabling the Support for ODBC Sources
    • Enabling the Support for ODBC Sources When Using an External JRE
    • Creating an ODBC Data Source
    • Creating Base Views over an ODBC Data Source
  • SOAP Web Service Sources
    • Importing SOAP Web Service Sources
      • Connecting to a SOAP Web Service with Kerberos Authentication
    • Creating Base Views from a SOAP Web Service
      • Dealing with Web Service Operations that Return Compound Values
      • Dealing with Web Service Operations with Polymorphic or “Any” Types
  • Multidimensional Database Sources
    • Creating a Base View Over a Multidimensional Data Source, Graphically
    • Creating a Base View Over a SAP Bex Query (only for SAP BW)
    • Creating a Base View Over a Multidimensional Data Source with an MDX Query
      • Specific Information of Multidimensional Databases
        • Microsoft SQL Server Analysis Services (SSAS)
    • Multidimensional Data Sources to Oracle Essbase
    • Multidimensional Data Sources Push Down Capabilities
  • Path Types in Virtual DataPort
    • Local Path
      • Paths Pointing to a Directory
    • Path From Variable
    • HTTP Path
      • Configuration
      • Pagination
        • 1. Obtain the “Next Page URL” from an HTTP Header of the Response
          • 1.1 POST Considerations
        • 2. Obtain the “Next Page URL” from the Body of the Response
          • 2.1 REST
          • 2.2 POST
          • 2.3 Common Behavior
        • 3. Obtain a Token from the Response
        • 4. Pagination with Indices
      • Proxy Settings
      • Authentication in HTTP Paths
        • Mutual Authentication
        • OAuth Authentication
          • OAuth 1.0a
          • OAuth 2.0
        • SPNEGO (Kerberos)
      • Connection Pool
    • FTP / SFTP / FTPS Path
    • HDFS Path
      • Configuration
        • Paths Pointing to a Directory
      • Authentication
    • S3 Path
      • Configuration
        • Paths Pointing to a Directory
      • Authentication
    • ADLS Path (ABFS)
      • ADLS Configuration
        • Paths Pointing to a Directory
      • ADLS Authentication
    • Hadoop-Compatible Storage
    • Compressed or Encrypted Data Sources
    • Custom Input Filters
    • Paths and Other Values with Interpolation Variables
  • XML Sources
    • Direct
    • From OpenAPI 3 Document
  • JSON Sources
    • Direct
    • From OpenAPI 3 Document
  • Delimited File Sources
    • Examples of How to Define a Tuple Pattern
    • Paths Using Date Ranges
  • Excel Sources
    • Size Limit When Processing Excel Files
    • Fields Detected as Text During Introspection with Another Format
  • LDAP Sources
  • BAPI Sources
  • Salesforce Sources
    • Registering Denodo as a Connected Application
    • Creating a Salesforce Data Source
      • Web Server Flow
      • Username and Password Flow
      • Mutual Authentication
    • Creating Base Views from a Salesforce Data Source
    • Creating Base Views from SOQL Queries
      • Using the Variable WHEREEXPRESSION in SOQL Queries
    • Binary Fields
      • Insert or Update Binary Fields
    • Limitations of Salesforce
    • Additional Settings
    • Bulk Mode
      • Bulk Mode Parameters
  • MongoDB Sources
    • Creating a MongoDB Data Source
      • Mutual Authentication
      • Connection Properties
      • Connection Pool Configuration
      • Metadata Tab
    • Creating Base Views from a MongoDB Data Source
    • MongoDB Aggregation Pipelines
      • Interpolation Variables
    • Delegation Capabilities and Limitations
  • Object Storage data in Parquet and Delta Format
    • How to Connect to a Kerberized HDFS from Embedded MPP Data Sources
    • From Object Storage vs From MPP Catalogs
    • Schema Evolution
    • Source Refresh on Views from Object Storage
    • Manage Views Created from Object Storage
  • OData 2 Sources
    • Create OData v2 Data Sources
    • Create OData v2 base views
    • Examples
    • Known Limitations
    • Troubleshooting
      • Symptom
      • Resolution
    • References
    • Appendix
      • Connection to Microsoft SharePoint Online
  • OData 4 Sources
    • Create OData v4 Data Sources
    • Create OData v4 Base Views
    • Examples
    • Known Limitations
    • References
  • Custom Sources
    • Using Interpolation Variables as Custom Sources’ Input Parameters
  • Software as a Service Wizards
    • Adobe Analytics
      • Getting OAuth 2.0 Credentials
      • Importing Artifacts
      • Campaign Performance
      • Query Example
      • Content Consumption
      • Query Example
      • Generic
      • Query Example
      • Metric and Dimensions
      • Query Example
      • Marketing Ecommerce
      • Query Example
      • People Metrics
      • Query Example
      • Product Retail
      • Query Example
      • Web Acquisition
      • Query Example
      • Web Technology
      • Query Example
      • Appendix I. How to Simplify the Data Range Format in Views
    • Google Analytics 4
      • Getting OAuth 2.0 Credentials
      • Importing Artifacts
      • Real Time Reports
      • Query With Real Time View
      • Custom Reports
      • Query With Custom Report View
      • Custom Pivot Reports
      • Query With Custom Pivot Report View
      • GA4 New Features Predefined Reports
      • Query With GA4 Dimension Configurable Reporting Views
      • Appendix I. How To Use Google Analytics Data API v1
      • Example
    • Google Analytics Migration
      • Getting OAuth 2.0 Credentials
      • Importing Artifacts
      • GA4 Migration Predefined Reports
      • Query
    • Marketo
      • Importing Artifacts
      • Query Example
    • Marketo Bulk Extract
      • Importing Artifacts
      • Query Example
    • ServiceNow
      • Importing Artifacts
    • SharePoint
      • Configuring The Application in Azure
    • SharePoint For OData
      • Getting OAuth 2.0 Credentials
      • Importing Artifacts
      • Query Example
    • SharePoint REST API
      • Getting OAuth 2.0 Credentials
      • Importing Artifacts
      • Query Example
  • Viewing the Schema of a Base View
    • View the VQL of an Element
      • Edit the VQL of a Derived View
    • Used By…
    • Source Type Properties
  • Data Source Configuration Properties
  • Source Refresh
  • Working with Blob Fields of Base Views
  • Adobe Analytics
    • Getting OAuth 2.0 Credentials
    • Importing Artifacts
    • Campaign Performance
    • Query Example
    • Content Consumption
    • Query Example
    • Generic
    • Query Example
    • Metric and Dimensions
    • Query Example
    • Marketing Ecommerce
    • Query Example
    • People Metrics
    • Query Example
    • Product Retail
    • Query Example
    • Web Acquisition
    • Query Example
    • Web Technology
    • Query Example
    • Appendix I. How to Simplify the Data Range Format in Views
  • Google Analytics 4
    • Getting OAuth 2.0 Credentials
    • Importing Artifacts
    • Real Time Reports
    • Query With Real Time View
    • Custom Reports
    • Query With Custom Report View
    • Custom Pivot Reports
    • Query With Custom Pivot Report View
    • GA4 New Features Predefined Reports
    • Query With GA4 Dimension Configurable Reporting Views
    • Appendix I. How To Use Google Analytics Data API v1
    • Example
  • Google Analytics Migration
    • Getting OAuth 2.0 Credentials
    • Importing Artifacts
    • GA4 Migration Predefined Reports
    • Query
  • Marketo
    • Importing Artifacts
    • Query Example
  • Marketo Bulk Extract
    • Importing Artifacts
    • Query Example
  • ServiceNow
    • Importing Artifacts
  • SharePoint
    • Configuring The Application in Azure
  • SharePoint For OData
    • Getting OAuth 2.0 Credentials
    • Importing Artifacts
    • Query Example
  • SharePoint REST API
    • Getting OAuth 2.0 Credentials
    • Importing Artifacts
    • Query Example
• Creating Derived Views
  • Creating Union Views
    • Creating Extended 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
      • Considerations about View Parameters
      • When Should You Use View Parameters
        • Enforce a Filter Condition
        • Group By Bypass
        • Outer Join Bypass
        • Partitioned UNIONs
      • Limitations Using View Parameters
  • 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
      • Cache Indexes
      • Cache Refresh Jobs
        • How This Works
        • Pre-Requites to Use this Feature
        • Configuration Steps
    • Search Methods, Configuration Properties and Internationalization
      • Alternative Sources
      • View Configuration Properties
      • Internationalization Configuration
    • Indexes of Views
      • Defining an Index of a Base View
      • Creating an Index in the Underlying Database of a Remote Table or a Summary
    • Statistics of the View
    • Defining the Data Movements of the View
  • Materialized Tables
  • Temporary Tables
  • Querying Views
    • Execution Trace of a Statement
      • Storing the Execution Trace of Queries
  • Editing / Replacing a View
    • Modifying Base Views
    • Modifying Derived Views
    • Views Affected by Modifications
• Stored Procedures
  • Importing Java Stored Procedures
  • Executing Stored Procedures
  • Use of Stored Procedures in Creating Views
• Publication of Web Services
  • Publishing SOAP Web Services
    • Operations Tab
      • Pagination Support
      • Ordering the Results
    • Settings Tab (SOAP)
      • SOAP Over JMS
    • Advanced Tab (SOAP)
  • Publishing REST Web Services
    • Resources Tab
    • Settings Tab (REST)
      • HTML-Escaping the Data
      • Mappings for the RSS Representation
      • Selecting the Default / Available Representations
      • Cross-origin Resource Sharing (CORS)
        • Initial Set-Up of CORS
        • Enabling CORS on a Web Service
      • OpenAPI / Swagger
    • Advanced Tab (REST)
  • XSLT Transformations
  • Web Services Authentication
    • HTTP Basic
    • HTTP Basic with VDP
    • HTTP Digest
    • HTTP SPNEGO (Kerberos)
    • OAuth 2.0 and OpenID
    • 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
      • Invoking Web Services with SAML Authentication from a Browser
      • Invoking Web Services with SAML Authentication Programmatically
    • Types Conversion Table for REST / SOAP Published Web Services
  • Privileges Required
• RESTful Architecture
  • Primary Keys of Views
  • Associations
    • Creating an Association
      • Creating Associations for JDBC Base Views Automatically
      • Creating an Association Manually
    • Multiplicity of Associations
    • Referential Integrity in Associations
    • Role Preconditions
    • Why You Should Define Associations Between Views
  • RESTful Web Service
    • Representations
      • XML Representation
        • XML Representation of a Database
        • XML Representation of a View
        • XML Representation of a “View Element” Resource
        • XML Representation of an Association
      • JSON Representation
      • HTML Representation
    • Input Parameters of the RESTful Web Service
      • Tunnel HTTP Methods Inside Another HTTP Method (X-HTTP-Method-Override)
    • IDU Requests
      • INSERT Queries (POST)
        • Alternative Structure for the Body of the Request to Insert One Row
      • UPDATE Queries (PUT)
      • DELETE Queries
    • 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
      • Limit the Maximum Number of Rows Returned
      • Cross-origin Resource Sharing (CORS)
      • Customizing the Look & Feel of the RESTful Web Service
      • Modifying the Connection Parameters Between the RESTful Web Service and Virtual DataPort
  • Denodo OData 4.0 Service
    • Serving Metadata
    • Querying Data: The Basics
      • Querying Collections
      • Obtaining Items by Primary Key
      • Accessing Individual Properties
      • Accessing Individual Property Values
      • Accessing Complex Properties
      • Counting Elements in a Collection: $count
      • Establishing the Response Format
        • JSON Format
        • Atom Format
    • Navigating Associations
      • Querying Related Entries
      • Referencing Related Entities
    • Advanced Querying
      • Selection: $filter
        • Operators
        • String Functions
        • Math Functions
        • Date Functions
      • Projection: $select
      • Ordering Results: $orderby
      • Including Related Resources: $expand
      • Parameter Aliases
      • Specifying Maximum Number of Results: $top
      • Specifying Offset: $skip
      • Asking for Total Result Count: $count
      • Lambda Operators: any
      • System Query Option: $apply
    • Pagination
    • Configuration
      • Enabling Kerberos Authentication in the OData Service
      • Enabling Cross-Origin Resource Sharing (CORS)
        • Supported HTTP Header Methods
    • Entity Collection Streaming
    • Debug Option
    • Privilege Requirements
    • Limitations
    • Features
  • Denodo GraphQL Service
    • Configuration
      • GZIP
    • Privilege Requirements
    • Schema
      • Custom Scalar Types
    • Introspection
    • Basic Querying
      • Fields
      • Arguments
      • Aliases
      • Fragments
      • Variables
      • Directives
      • Pagination
    • GraphQL Names
    • Advanced Querying
      • Filtering
      • Filtering Limitations
      • Sorting
      • Group BY and Aggregation Functions
      • Using an Aggregation Function More than Once in a Query
    • Authentication
      • Basic
      • SPNEGO (Kerberos)
      • OAuth 2.0
    • Resource Limitations
    • Limitations
      • Mutations and Subscriptions
      • Group BY
      • Handling of Very Large Result Sets
    • 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
• Kafka Listeners
  • Creating Kafka Listeners
  • Privileges Required
  • Advanced Kafka Configuration
• Remote Tables
  • Managing Remote Tables
    • Creating Remote Tables
    • Editing Remote Tables
    • Refresh Data
    • Dropping Remote Tables
    • Customizing the Table Creation Template
  • Remote Tables vs Other Mechanisms for Persisting Data
• Server Configuration
  • Configuring the Cache
  • Limiting the Number of Concurrent Requests
  • Credentials Vault
    • Enabling Access to the Credentials Vault
    • Supported Credentials Vaults
      • AWS Secrets Manager
        • Default Credential Provider
        • Access Keys
        • Naming Convention for AWS Secrets Manager Secrets
        • Required Policies
      • Azure Key Vault
        • Client Certificate
        • Client Secret
        • Environment Variables
        • System Managed
        • User Managed
        • Naming Convention for Azure Key Vault
      • CyberArk
        • CyberArk: Agent Mode
          • Application Configuration for Agent Mode
        • CyberArk: AgentLess Mode
        • Naming Convention for CyberArk Accounts
        • How Virtual DataPort Retrieves the Credentials from CyberArk
      • HashiCorp Vault
        • Agent
        • App Role
        • LDAP
        • TLS Certificate
        • Token
        • User/Password
        • Naming Convention for HashiCorp Vault Secrets
    • How A Data Source Obtains the Credentials from the Vault
    • Specify a Pattern as Secret Name, Parameterized by the Login
  • Configuring the Default Internationalization
  • Default Configuration of HTTP Proxy
  • Identifiers Charset
    • Restricted Mode
    • Unicode Mode
  • Configuring the Memory Usage and Swapping Policy
    • Memory Usage Settings
    • Swapping Settings
    • Maximum Size of a Query
  • Privileges
    • Indirect Access Control
    • The FILE Privilege
  • 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
  • Server Authentication
    • LDAP Authentication
      • Initial Configuration for Enabling LDAP Authentication
      • Enabling Global LDAP Authentication for the Virtual DataPort Server
      • Enabling LDAP Authentication for a Virtual DataPort Database
      • The LDAP Authentication Process
      • Configuring a Database with LDAP Authentication and Dynamic Groups
      • Enabling the LDAP Roles Cache
    • 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
        • Enabling Kerberos Authentication for ODBC Connections Using Old Versions of the Driver
        • Disable Kerberos Replay Cache
        • Cross-Domain Authentication
      • Configuring the Administration Tool to Use Kerberos Authentication
    • SAML Authentication
      • Creating the Roles of the Virtual DataPort Users
      • Validation of the Response Signature
    • OAuth Authentication
      • Enabling OAuth Authentication
        • JWT
        • Introspection
      • Connecting to REST and SOAP Web Service with OAuth Authentication
      • Connecting with JDBC and ODBC with OAuth Authentication
      • Creating the Roles of the Virtual DataPort Users
    • Denodo Security Token Authentication
  • Server Connectivity
  • Configuring Runtime Parameters for Stored Procedures
  • Threads Pool
  • Storing the Metadata on an External Database
    • Replication Process
      • Avoiding Conflicts
    • Databases Supported
    • Considerations About This Feature
    • How to Configure Virtual DataPort to Store the Metadata on an External Database
      • Using a Script to Enable this Feature
• 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
  • Logging Resource Manager Actions
• 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
      • Exporting with “metadata_export” Role
  • Importing Metadata into a Server
• Importing Extensions
  • Importing a JDBC Driver
  • Importing a JDBC Driver for a Database that is not Listed
  • Importing Other Types of Elements
    • Using a Script to Upload Extensions
• Cache Module
  • Cache Modes
    • Partial Mode
      • Explicit Loads
      • Match Exact Queries Only
    • Full Mode
      • Loading the Cache Invalidating the Existing Data
      • Loading the Cache Incrementally
        • Incremental Cache Loads Based on Time
        • Incremental Cache Loads Based on Content
        • Incremental Cache Loads Updating the Existing Cached Data
      • The Full Cache Mode at Runtime
    • Incremental Mode
      • Requirements a View Has to Meet to Support Incremental Queries
      • How Incremental Queries Work at Runtime
      • Example 1 of Use of Incremental Queries (Salesforce)
      • Example 2 of Use of Incremental Queries (Google Drive)
    • Recommended Parameters for Queries that Load the Cache
      • Avoid Obtaining the Result of a Query Executed to Load the Cache
      • Checking If the Cache Has Been Loaded Correctly
    • Caching Very Large Data Sets
      • Invalidating the Cache of a View in Blocks
    • 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
    • Google BigQuery
    • Kudu
    • PrestoDB/Trino
    • Embedded Denodo MPP
    • Spark
    • Yellowbrick
    • Databases Using a Distributed Object Storage
  • Generic Support for Other Databases
  • Table Creation Templates Management
    • Creating or Editing the Table Creation Template On the Data Sources
    • Configure the Cache Table Creation Templates
    • Customize the Cache Management Tables Template
    • Creating or Editing the Table Creation Template On Views
    • Template Parameters
    • Internal Parameters List
• Version Control Systems Integration
  • VCS Configuration
    • Virtual DataPort Server Configuration
    • Environment Management
      • What Are VCS Environments
      • Managing VCS Environments
    • Database Configuration
    • Importing an Existing Database from a VCS Server
  • VCS Integration Features
    • Integration with the Server Explorer
    • VCS Operations for GIT
      • Commit
      • Push
      • Pull
        • Unresolved Elements
      • Revert
      • Discard
      • Delete
    • Dependencies Management
      • Privileges Management
      • Global Elements 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
      • More Information about Global Elements
    • Promoting Changes from Development to Testing and Production
      • Promoting a Database Using Scripts Instead of the Solution Manager
    • Using VCS Environments
  • Best Practices When Using the Integration with a VCS
    • Tagging and Branching Releases
    • Recommendations for the Testing Environment
• Databases, Users and Access Rights in Virtual DataPort
  • Databases in Virtual DataPort
  • User and Access Rights in Virtual DataPort
    • Users
    • Roles
    • Types of Access Rights
    • Privileges at Database Level
      • Connection Privilege
      • Create Privilege
      • Create Data Source Privilege
      • Create View Privilege
      • Create Data Service Privilege
      • Create Folder Privilege
      • Execute Privilege
      • Metadata Privilege
      • Write Privilege
      • File Privilege
      • Admin Privilege
      • Insert, Update and Delete Privileges
  • Fine-Grained Privileges at View Level
    • Column Privileges
    • Row Restrictions
  • Modeling Fine-Grained Role Restrictions on Multiple Roles
    • Privileges are Cumulative, not Exclusionary
    • Data Available to a User with Roles R1,R2 is Equals to the Data Available to R1 + the Data Available to R2 in General but NOT Always
    • The execution engine only considers the privileges in roles with execution privilege on the query views
  • Limit Indirect Access to Views Shared with Other Development Teams
    • Limit Indirect Access to Shared Views Using Global Security Policies
    • Limit Indirect Access to Shared Views Using the Indirect Access Privilege
  • Administration of Databases, Users, Roles and Their Access Rights
    • Creating Databases
      • Creating a Database with Global Authentication Settings
      • Creating a Database with LDAP Authentication
    • Configuring and Deleting Databases
    • Creating Users
      • Considerations
    • Modifying and Deleting Users
      • Changing Your Own Password
      • Modifying the Privileges of a User
    • Creating Roles
      • Wizard “Import Roles from LDAP”
        • Default Roles
  • Privilege Auditing
    • Logging Details when Processing Privileges
    • Impersonation
• Global Security Policies
  • Tags Management
    • Removing Tags
    • Privileges Required to Manage and Assign/Unassign Tags
  • Global Security Policy
    • Global Security Policies Management
    • Creating a Global Security Policy
    • Privileges
• Import Tags from External Catalog
• Monitoring the Virtual DataPort Server
  • Monitoring with a Java Management Extensions (JMX) Agent
    • Using JavaTM VisualVM
    • General Information on the Server
      • VDBServerManagementInfo MBean
        • Attributes of the VDBServerManagementInfo MBean
        • Operations of the VDBServerManagementInfo MBean
        • Notifications of the VDBServerManagementInfo MBean
      • MemoryManagementInfo MBean
        • Attributes of the MemoryManagementInfo MBean
        • Operations of the MemoryManagementInfo MBean
      • LogManagementInfo MBean
    • Information on Data Sources
      • GlobalDataSourceManagementInfo MBean
        • Attributes of the GlobalDataSourceManagementInfo MBean
      • LocalDataSourceManagementInfo MBean
      • DataSourceManagementInfo MBean
        • Attributes of the DataSourceManagementInfo MBean
        • Operations of the DataSourceManagementInfo MBean
    • Information on the Cache
      • VDBServerCacheManagementInfo MBean
      • DatabaseCache MBean
      • ViewCache MBean
    • Information and Events on Catalog Access (DDL Statements)
    • Information and Events on the Running of Statements
      • VDBServerRequestsManagementInfo MBean
        • Notifications of the VDBServerRequestsManagementInfo MBeans
      • RequestsManagementInfo MBean
        • Attributes of the RequestsManagementInfo MBeans
        • Notifications of the RequestsManagementInfo MBeans
    • Information and Events on Transactions
    • Setting the User Agent of an Application
    • Setting Cloud Infrastructure Properties
  • Denodo Monitor
    • Local Monitors
    • Server Monitors
      • Resources Monitors
      • Threads Monitors
    • Virtual DataPort Monitors
      • Virtual DataPort Queries Monitor
      • Virtual DataPort Query Data Sources Monitor
      • Virtual DataPort Cache Monitor
      • Virtual DataPort Connections Monitor
      • Virtual DataPort Data Sources Monitor
      • Virtual DataPort Query Blocks Monitor
    • Configuring the Denodo Monitor
      • JDBC Logging Configuration
        • Kerberos Configuration
      • Cloud Storing Configuration
      • Obfuscation of Sensitive Information
    • Launching the Denodo Monitor
      • Start Denodo Monitor
      • Stop Denodo Monitor
      • Obtain a Memory Dump with the Denodo Monitor
  • FinOps
• 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
      • Importing the Metadata from a Single File
      • Importing the Metadata from a Repository
• Data Lake Storage Management
  • CSV, JSON and XML File Formats
  • Apache Parquet File Format
  • Delta Lake Table Format
  • Iceberg Table Format
• Bulk Data Load
  • AlloyDB for PostgreSQL
  • Amazon Athena
  • Amazon Aurora MySQL
  • Amazon Aurora PostgreSQL
  • Amazon Redshift
  • DB2
  • Databricks
  • Denodo Embedded MPP
    • Iceberg Tables
    • Configure the Denodo Server to Use the Embedded MPP as Cache Using Iceberg Tables
    • Create Iceberg Tables in the Denodo Embedded MPP
    • Bulk Data Loading into Iceberg Tables
    • Create Iceberg Tables in the Denodo MPP or Presto Data Source When the Catalog Name is not Iceberg
    • Troubleshooting
  • BigQuery
  • Hive
  • Impala
    • Data Load to Impala Using Built-in Implementation
    • Data Load to Impala Using External Hadoop Installation
  • Kudu
    • Steps Virtual DataPort Performs to Bulk Load Data into Kudu
  • MySQL
  • Oracle
  • PostgreSQL
  • PrestoDB/Trino
  • Snowflake
  • Spark
  • Microsoft SQL Server and Azure Synapse SQL
  • Teradata
  • Yellowbrick
  • Settings of the Generation of the Temporary Files
    • Generation of Temporary Files for a Hadoop-compatible Distributed Object Storage
      • Compression
      • Decimal Precision and Scale
  • Bulk Data Load on a Distributed Object Storage like HDFS, S3 or ADLS
  • Built-in Implementation
  • External Hadoop Installation
• 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
      • Gathering Statistics Automatically
        • How the Gathering Statistics Process Works
        • Scheduling the Gathering of Statistics
        • Limitations of the Gathering Statistics Process
    • Tuning the Cost-Based Optimization Process
      • Estimating the Cost of Queries on Data Sources
      • Estimating Post-Processing Costs
      • Specifying Indexes
        • Tuning the Imported Indexes Information for Oracle
        • Tuning the Imported Indexes Information for MySQL
        • Tuning the Imported Indexes Information for Informix
        • Tuning the Imported Indexes Information for Teradata
        • Tuning the Imported Indexes Information for Netezza
        • Tuning the Imported Indexes Information for Redshift
        • Tuning the Imported Indexes Information for Greenplum
        • Tuning the Imported Indexes Information for Hive
        • Tuning the Imported Indexes Information for Google BigQuery
        • Tuning the Imported Indexes Information for Other Data Sources
      • Data Source I/O Parameters
    • Current Limitations of the Cost-Based Optimization Process
  • Data Movement
    • Data Movements From/To Netezza Databases
    • Examples of Data Movement
    • Known Limitations
    • Forcing the Data Movement of a View
    • Options of the CONTEXT Clause that Control a Data Movement
    • Customize the Data Movement Table Creation Command
  • Parallel Processing
    • Embedded MPP Acceleration
    • Parallel Processing Using an External MPP
    • Use of an MPP Engine as Cache
    • Force Movement of Views to the MPP Engine Using the CONTEXT Clause
  • Window Functions
    • Execution of Window Functions
      • Automatic Data Movement to Delegate Window Functions
      • Manual Data Movement to Delegate Window Functions
  • Smart Query Acceleration Using Summaries
    • Managing Summaries
      • Creating Summaries
      • Refresh Summary Data
      • Export/Import Between Environments
      • Editing Summaries
      • Dropping Summaries
    • Summary Promotions
      • Promotion Process for New Summaries
      • Promotion Process for Summary Updates
    • Summary Rewrite Optimization
      • Enable/Disable this Feature
      • Main Use Cases
      • Caching vs Summary Rewriting
      • Recommendations When Using Summaries
    • Automatic Summary Recommendations
      • How to Monitor an Environment for Summary Recommendations
      • Make the Logs Information Available to a VDP Server
      • Run the Summary Recommendations Tool
        • Generate Recommendations
        • Process the Results
      • Process Setup Overview
• Denodo Embedded MPP
  • Sizing Recommendations for the Denodo Embedded MPP
  • Promoting the Denodo Embedded MPP
  • Embedded MPP Extended Execution Trace
    • MPP Route Plan
    • MPP Execution Plan
    • MPP Stage Plan
    • MPP Stage Plan Operation Nodes
    • Errors in the Extended Execution Trace
• Import Model
  • Overview
  • Data Modeling
    • RDFS and OWL Ontologies
  • Usage
  • Limitations
  • Tags Supported by the Import Model Tool
• Appendix
  • Avoiding SQL Injections
  • Backward Compatibility Between the Virtual DataPort Server and Its Clients
  • Configuring the Logging System
    • Obfuscation of Sensitive Information of Requests
  • Configuring the Network Interface Restriction in the Denodo Platform
  • Considerations When Configuring Data Sources with Pass-Through Credentials
    • Web Services
  • Data Sources That Support Merge Data
  • Using the Databricks API and DBFS for Bulk Loads
    • Mounting External File Systems on the DBFS
  • Change Password Script (Design Studio)
  • Enable the “Export” Endpoint of the Web Container
  • Execution Trace Information
  • Configure Export Key Script
  • Importing the Certificates of Data Sources (SSL/TLS Connections)
  • Installing the Connector for Oracle Essbase
    • Requirements of the Essbase 11 Adapter
  • Installing the JMS Connectors to Create JMS Listeners and Web Services with SOAP Over JMS
    • JMS Client Jars
  • Installing the SAP Java Connector
    • Installing the Connector
    • Testing the Connector on Windows
    • Testing the Connector on Linux
    • Grant Privileges in SAP for BAPI Data Sources
    • Grant Privileges in SAP BW for Multidimensional Data Sources
  • JMS Connection Details: JNDI Properties
    • Apache ActiveMQ 6.1.x
    • IBM WebSphere MQ 7.0
    • Progress SonicMQ 8.0
  • Launching Several Virtual DataPort Instances of the Same Installation
    • How to Configure the Secondary Instances
    • Deploying Web Services on This Configuration
  • Creating Multidimensional Base Views Over a Multidimensional Data Source
    • “Include Empty Rows” Option
    • “Leaf Members Only” Option
    • “Leaf Label Only” Option
    • “Member Captions” Option
    • “Technical Keys” Option
    • “Member Leaves” Option
    • “Include Member Keys” Option
    • SAP Variables
    • SAP Metadata Cache
  • Mapping Multidimensional Data to a Relational Model
    • Creating Multidimensional Base Views Over a Multidimensional Data Source
      • “Include Empty Rows” Option
      • “Leaf Members Only” Option
      • “Leaf Label Only” Option
      • “Member Captions” Option
      • “Technical Keys” Option
      • “Member Leaves” Option
      • “Include Member Keys” Option
      • SAP Variables
      • SAP Metadata Cache
    • Mapping the Result of MDX Queries
  • Mapping the Result of MDX Queries
  • OpenAPI 3 Data Sources FAQ
  • Resource Manager: Available Fields to Evaluate a Rule
    • Examples of Resource Manager Rules
  • Restriction of Number of Data Sources
  • Single User Mode
    • Explicit Single User Mode
    • Automatic Single User Mode
  • Supported JDBC Data Sources
  • Transforming Incoming/Outgoing Soap/Rest Messages with XSLT Stylesheets
  • Useful Tools to Debug Issues with Active Directory or Other LDAP Servers
  • Values of the Attribute “Access Interface”
  • Change Password Script (VDP)