- Denodo Platform Installation Guide
- Legal Note
- Preface
- Introduction
- Pre-Installation Tasks
- Using the Graphical Installation Wizard
- Using the Command Line Installer
- Unattended Installation of the Denodo Platform
- Post-Installation Tasks
- Install the Latest Update
- Set the Host Name of Virtual DataPort
- Register the Denodo Servers in the License Manager
- Enable SSL/TLS in the Denodo Platform
- Obtaining and Installing an SSL/TLS Certificate
- Denodo SSL/TLS Configurator Script
- 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
- Post-Installation Tasks: Virtual DataPort
- Change the Default Passwords
- Setting-up Kerberos Authentication
- Setting-up Kerberos Authentication in the Data Catalog
- Installing the Connector for Oracle Essbase
- Installing the SAP Java Connector
- 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)
- Preparing the Connection to Data Sources
- Post-Installation Tasks: Scheduler
- Post-Installation Tasks: Web Container
- 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
- Upgrading from a Previous Version
- Installing Updates and Hotfixes
- Denodo Platform Control Center
- Appendix
- Denodo Platform - Feature Packs
- Restrictions of Denodo Standard
- Restrictions of Denodo Express
- Default Ports Used by the Denodo Platform Modules
- Health Monitoring
- Enabling Kerberos Authentication Without Joining a Kerberos Realm
- How to Debug Kerberos in Web Applications
- Providing a Krb5 File for Kerberos Authentication
- Denodo Security Token Configuration File
- Launching the Denodo Standalone Applications in High DPI Displays
- Troubleshooting the Denodo Platform Installer
- Transparent Metadata Encryption
- Supported Java Runtime Environments (JRE)
- Increasing the Maximum Simultaneous Requests
- Language of the Web Administration Tools
- Denodo Platform Upgrade Guide
- Preface
- Introduction to Upgrading the Denodo Platform
- Preparing to Upgrade
- Pre-Upgrade Tasks for the New Installation
- Common to All Modules
- Virtual DataPort
- Virtual DataPort: JDBC Data Sources that Use the Bulk Data Load API
- Virtual DataPort: Enable the Cache Engine
- Virtual DataPort: Install Third-Party Connectors
- Virtual DataPort: Other Third-Party Jar Files
- Virtual DataPort: Version Control System
- Virtual DataPort: Delete Unused Objects
- Virtual DataPort: Delete Aracne and Google Search Data Sources
- Virtual DataPort - Published Web Services: Customize Logo
- Data Catalog: Enable the External Database
- Scheduler: Enable the External Database
- Solution Manager
- Upgrading from Denodo 6.0: Export the Settings and Metadata of the Current Installation
- Upgrading from Denodo 7.0: Export the Settings and Metadata of the Current Installation
- Review the Virtual DataPort Metadata
- Import Settings and Metadata in to the New Installation
- Post-Upgrade Tasks for the New Installation
- Test the New Denodo Platform Installation
- Backward Compatibility
- Features Deprecated in Denodo Platform 8.0
- Virtual DataPort
- Data Type “Date”
- VQL Syntax
- Data Sources
- Denodo Stored Procedures
- Role JMXAdmin
- Denodo Stored Procedures API: getNumOfAffectedRows Method
- Denodo Custom Wrappers API: Deprecated Methods
- Denodo JDBC Driver
- Denodo Web Services
- Widgets
- Script Export: Deprecated Parameters
- Launching Several Virtual DataPort Instances of the Same Installation
- Data Catalog
- ITPilot
- Scheduler
- Solution Manager
- Denodo4Eclipse Plugin
- Virtual DataPort
- Denodo Platform New Features Guide
- Preface
- What Is New in Denodo 8.0 Update 20210715
- What Is New in Denodo 8.0 Update 20210209
- Denodo 8.0 GA Highlights
- New Features of the Solution Manager 8.0 GA
- New Features of Virtual DataPort 8.0 GA
- New Features of Scheduler 8.0 GA
- New Features Common to All Modules of 8.0 GA
- Virtual DataPort Administration Guide
- Preface
- Introduction
- General Architecture
- Starting Virtual DataPort
- Creating Data Sources and Base Views
- JDBC Sources
- ODBC Sources
- SOAP Web Service Sources
- Multidimensional Database Sources
- Path Types in Virtual DataPort
- XML Sources
- JSON Sources
- Delimited File Sources
- Excel Sources
- Web Sources (WWW)
- LDAP Sources
- BAPI Sources
- Salesforce Sources
- Custom Sources
- Viewing the Schema of a Base View
- Data Source Configuration Properties
- Source Refresh
- Working with Blob Fields of Base Views
- Creating Derived Views
- Creating Union Views
- Creating Join Views
- Creating Selection Views
- Creating Flatten Views
- Creating Intersection Views
- Creating Minus Views
- Creating Interface Views
- Viewing the Schema of a Derived View
- Tree View
- Data Lineage
- Advanced Configuration of Views
- Materialized Tables
- Temporary Tables
- Querying Views
- Editing / Replacing a View
- Stored Procedures
- Publication of Web Services
- RESTful Architecture
- JMS Listeners
- Remote Tables
- Server Configuration
- Configuring the Cache
- Limiting the Number of Concurrent Requests
- Credentials Vault
- Configuring the Default Internationalization
- Default Configuration of HTTP Proxy
- Identifiers Charset
- Configuring the Memory Usage and Swapping Policy
- Privileges
- Queries Optimization
- Server Authentication
- Server Connectivity
- Configuring Runtime Parameters for Stored Procedures
- Threads Pool
- Storing the Metadata on an External Database
- Memory Management
- Resource Manager
- Exporting and Importing the Server Metadata
- Importing Extensions
- Cache Module
- Version Control Systems Integration
- Databases, Users and Access Rights in Virtual DataPort
- Monitoring the Virtual DataPort Server
- Cluster Architectures / Server Backup
- Bulk Data Load
- Optimizing Queries
- Appendix
- Supported JDBC Data Sources
- Backward Compatibility Between the Virtual DataPort Server and Its Clients
- Mapping Multidimensional Data to a Relational Model
- Considerations When Configuring Data Sources with Pass-Through Credentials
- Configuring the Logging System
- Configuring the Network Interface Restriction in Virtual DataPort
- Installing the Denodo Solution for Microsoft SharePoint
- Transforming Incoming/Outgoing Soap/Rest Messages with XSLT Stylesheets
- JMS Connection Details: JNDI Properties
- Execution Trace Information
- Useful Tools to Debug Issues with Active Directory or Other LDAP Servers
- Single User Mode
- Resource Manager: Available Fields to Evaluate a Rule
- Values of the Attribute “Access Interface”
- Avoiding SQL Injections
- Enable the “Export” Endpoint of the Web Container
- Publication of Views as Widgets
- Launching Several Virtual DataPort Instances of the Same Installation
- Change Password Script (Design Studio)
- Restriction of Number of Data Sources
- Virtual DataPort Developer Guide
- Preface
- Introduction
- Access Through JDBC
- JDBC Driver Parameters
- Connecting to Virtual DataPort Through a Load Balancer
- Connecting to Virtual DataPort Using Kerberos Authentication
- Connecting to Virtual DataPort Using OAuth Authentication
- 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
- Get Auto-Generated Keys in IDU Statements
- Enabling JDBC Logging
- Access Through ODBC
- Access Through an ADO.NET Data Provider
- Access Through OLE DB
- Developing Extensions
- Custom Policies
- Appendix
- Virtual DataPort VQL Guide
- Preface
- Introduction
- General Overview of Virtual DataPort
- Language for Defining and Processing Data: VQL
- Functions
- Aggregation Functions
- Analytic Functions
- Conversion Functions
- Datetime Functions
- ADDDAY
- ADDHOUR
- ADDMINUTE
- ADDMONTH
- ADDSECOND
- ADDWEEK
- ADDYEAR
- CURRENT_DATE
- CURRENT_TIMESTAMP
- EXTRACT
- FIRSTDAYOFMONTH
- FIRSTDAYOFWEEK
- FORMATDATE
- GETDAY
- GETDAYOFWEEK
- GETDAYOFYEAR
- GETDAYSBETWEEN
- GETHOUR
- GETMILLISECOND
- GETMINUTE
- GETMONTH
- GETMONTHSBETWEEN
- GETQUARTER
- GETSECOND
- GETTIMEINMILLIS
- GETWEEK
- GETYEAR
- LASTDAYOFMONTH
- LASTDAYOFWEEK
- LOCALTIME
- LOCALTIMESTAMP
- MAX
- MIN
- NEXTWEEKDAY
- NOW
- PREVIOUSWEEKDAY
- SUBTRACT
- TO_DATE
- TO_LOCALDATE
- TO_TIME
- TO_TIMESTAMP
- TO_TIMESTAMPTZ
- TRUNC
- Numeric Functions
- Other Functions
- Text Functions
- XML Functions
- 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
- LDAP Data Sources
- BAPI Data Sources
- Salesforce Data Sources
- Custom Data Sources
- Data Source Configuration Properties
- Specifying Paths in Virtual DataPort
- Creating Wrappers
- Valid Conversions Between Types in Wrappers and VDP Types
- QUERY WRAPPER Statements
- Creating Data Sources
- Creating a Base View
- Queries: SELECT Statement
- Defining a Derived View
- Defining the Statistics of a View
- Materialized Tables
- Temporary Tables
- Remote Tables
- Summaries
- Inserts, Updates and Deletes Over Views
- Refreshing Views
- 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_AVAILABLE_STATS_MODES
- 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_PARAMETER
- GET_PRIMARY_KEYS
- GET_PROCEDURE_COLUMNS
- GET_SERVER_CONNECTIVITY
- GET_SESSIONS
- GET_SOURCE_CHANGES
- GET_SOURCE_COLUMNS
- GET_SOURCE_TABLE
- GET_STATS_FOR_FIELDS
- 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 Databases, Users, Roles and Access Privileges
- Describing Catalog Elements
- Listing Elements in the Catalog
- Removing Elements from the Catalog
- Publication of Web Services
- RESTful Architecture
- Help Command
- Version Control Systems Integration Commands
- Resource Manager
- Advanced Characteristics
- Appendix
- Virtual DataPort API Javadoc
- Data Catalog Guide
- Preface
- Introduction
- Installation and Execution
- Upgrading from 8.0GA or 8.0u20210209
- Introducing the Data Catalog
- Search
- Browse
- Views
- Web Services
- My Queries
- Locale Configuration
- Authentication
- Authorization
- Administration
- Appendix
- Data Catalog Guide (up to Update 20210209)
- Preface
- Introduction
- Installation and Execution
- Authentication and Authorization
- Administration
- Configuration
- Browse
- Saved Queries
- Search
- Appendix
- Diagnostic & Monitoring Tool Guide
- Preface
- Introduction
- General Architecture
- Installation and Execution
- Introducing the Diagnostic & Monitoring Tool
- Authentication
- Authorization
- Creating Servers and Environments
- Monitoring
- Creating Diagnostics and Diagnostic Intervals
- Diagnosing
- Export and Import
- Configuration
- Scheduler Administration Guide
- Preface
- Introduction
- General Architecture
- Installation and Execution
- Administration
- Creating and Scheduling Jobs
- Developer API
- Appendix
- JDBC Drivers
- Use of configure Scheduler export key script
- Use of the Import/Export Scripts for Backup (Scheduler)
- Use of the Import/Export Scripts for Backup (Scheduler Index)
- Use of the Ping Script (Scheduler)
- Use of the Ping Script (Scheduler Index)
- ChangePassword Script (Scheduler)
- ChangePassword Script (Scheduler Web Administration Tool)
- ChangePassword Script (Scheduler Index)
- Scheduler API Javadoc
- Solution Manager Installation Guide
- Preface
- Pre-Installation Tasks
- Using the Graphical Installation Wizard
- Using the Command Line Installer
- Unattended Installation of the Solution Manager
- Post-Installation Tasks
- Denodo Platform Control Center
- Appendix
- Default Ports Used by the Solution Manager Modules
- 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
- Supported Java Runtime Environments (JRE)
- Solution Manager Administration Guide
- Preface
- Introduction
- Starting the Solution Manager
- Introducing the Solution Manager Administration Tool
- License Management
- Configuration
- Authentication and Authorization
- Denodo Security Token
- Environments
- Standard Mode
- Automated Cloud Mode (AWS)
- Configuring Mode
- Creating Environments
- Configuring Environments
- Creating Clusters
- Configuring Clusters
- Managing Clusters
- View the Cluster Summary
- View the Progress of the Last Action
- Enable a Cluster
- Disable a Cluster
- View All Cluster Events
- Start a Cluster
- Stop a Cluster
- Restart a Cluster
- Recreate a Cluster
- Recreate a Cluster from Server
- Install a Denodo Update in a Cluster
- Monitor the Cluster with the Diagnostic & Monitoring Tool
- Environment Configuration
- Clusters Configuration
- Servers
- Load Balancing Variables
- Promotions
- Monitoring
- Import and Export
- Appendix
- REST API
- Get the List of Environments
- Create an Environment
- Get the List of Licenses Available
- Update an Environment
- Delete an Environment
- Update AWS Global Credentials
- Update AWS Environment Credentials
- Start Automated Mode Cluster
- Stop Automated Mode Cluster
- Restart Automated Mode Cluster
- Recreate Automated Mode Cluster
- Recreate From Servers Automated Mode Cluster
- Install Denodo Update Automated Mode Cluster
- 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
- Export Solution Manager Catalog and Configuration
- Import Solution Manager Catalog and Configuration
- 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
- Free License Usage by Server Id
- Ping License Manager Server
- Ping to Solution Manager Server
- Best Practices: Deployment of Updates Across Your Organization
- Solution Manager Compatibility with the Denodo Platform Servers
- Creating A Custom AMI for the Denodo Platform
- Suggested Reading Materials to Use the Automated Cloud Mode
- Architecture of a Deployment of Solution Manager in AWS
- Best Practices for Automated Mode AWS Environments
- AWS - Creating a Backup
- Creating an IAM Policy
- REST API
- Denodo4Eclipse Plugin Guide
- ITPilot
- ITPilot User Guide
- ITPilot Generation Environment Guide
- Preface
- Introduction
- Installation and Execution
- Generation Environment Tools - Part I
- Generation Environment Tools - Part II
- Extracting Multipaginated Data
- Access to Details Pages
- Generation Tool Global Preferences
- Tagsets and Scanners
- Generating the Data Extraction Specifications Manually
- Using the Sequence Debugger
- Saving a Flow as a Custom Component
- Wrapper Advanced Options: Specific Browser Pool and Locale
- Migrating Wrappers Between Generation Environments: Import and Export
- Managing Extensions
- Generating Navigation Sequences
- Appendix A: ITPilot Operators
- Appendix B: ITPilot Functions
- Appendix C: Catalog of Components
- Add Record To List
- Condition
- Create List
- Create Persistent Browser
- Diff
- Execute JavaScript
- Expression
- 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
- ITPilot DEXTL Guide
- ITPilot NSEQL Guide
- Preface
- Introduction
- Basic Concepts of NSEQL
- List of NSEQL Commands
- Usual Parameters
- Error Parameters
- Navigation Commands
- Commands for Processing Links
- Commands for Selecting Forms
- Commands for Executing Actions on Elements of a Form
- Frame Selection Commands
- Commands for Selecting Elements
- Commands for Executing on Actions on Elements
- Commands for Handling Windows
- Commands for Handling Pop-Up Dialogs
- Commands for Editing the Browser Properties
- Informative Commands
- Conversion Commands
- Commands for Saving Files
- Commands for Executing Code
- Commands for Clearing Browser Data
- Util Functions
- ITPilot API Javadoc
-
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 (feat. support for Apache Superset and Jupyter Notebook) - 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 Email Exported Files Custom Handler - User Manual
- Denodo FileSystem CustomWrapper - User Manual
- Denodo GeoJSON Service - User Manual
- Denodo Google Sheets Custom Wrapper - User Manual
- Denodo Google Sheets Tool - User Manual
- Denodo Governance Bridge - User Manual
- Denodo HBase CustomWrapper - User Manual
- Denodo 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 SFTP Exported Files Custom Handler - User Manual
- Denodo SSH Custom Wrapper - User Manual
- Denodo ServiceNow Templates - Quick guide
- Denodo Tableau Exporter - User Manual
- Denodo Templates for Adobe Analytics - Quick Use Guide
- Denodo Templates for Google Analytics - Quick Use Guide
- Denodo Templates for Marketo - Quick Use Guide
- Denodo Templates for Twitter - Quick Use Guide
- Denodo Testing Tool - User Manual
- Denodo XSLT Mapper - User Manual
- Denodo XtraFuncs - User Manual
- Generic XML Exporter - User Manual
- Denodo 8: Quick Start Guide with Automated Cloud Mode
- Denodo Express Quick Start Guide
- Denodo Platform Container QuickStart Guide
- Denodo Platform for AWS BYOL Quick Start Guide
- Denodo Platform for AWS 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
- Denodo Standard BYOL for AWS Marketplace - Deployment and Quick Start Guide
- Denodo Standard Frequently Asked Questions (FAQ)
- Denodo Standard for AWS Marketplace - Deployment and Quick Start Guide
- Denodo Standard for Azure BYOL Quick Start Guide
- Denodo Standard for Azure Quick Start Guide
- Denodo Standard for GCP BYOL Quick Start Guide
- Denodo Standard for GCP Quick Start Guide
- Denodo for Cloud Marketplaces Frequently Asked Questions (FAQ)
community
Denodo Platform 8.0
- User Manuals /
- Scheduler Administration Guide /
- Administration /
- Web Configuration /
- Change Password
