Community

Documentation
Try Denodo
Get Started
Learn
Collaborate

Sign In
Register

USER MANUALS

Denodo Platform 9.5

日本語

Denodo Platform Installation Guide

Legal Notes
Preface
Introduction
Pre-Installation Tasks
Using the Graphical Installation Wizard
- Settings you can Modify when you Select the Custom Installation
Using the Command Line Installer
Unattended Installation of the Denodo Platform
- Modifying the Denodo Platform Installer to Include the Latest Update
Post-Installation Tasks
Installing Updates, Bugfixes and Extra-Features
Denodo Platform Control Center
Appendix
- Supported Java Development Kits (JDK)
- Troubleshooting the Denodo Platform Installer

Denodo Platform Upgrade Guide

Preface
Introduction to Upgrading the Denodo Platform
Preparing to Upgrade
Pre-Upgrade Tasks for the New Installation
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
- Configuration Properties of Virtual DataPort for Upgrades: “exportMigrationCompatibility” and “exportOnlyResources”
- Alternatives for When You Cannot Install the Latest Update of Denodo 7.0
Upgrading From Denodo 8.0: Export the Settings and Metadata of the Current Installation
- Configuration Properties of Virtual DataPort for Upgrades: “exportMigrationCompatibility” and “exportOnlyResources”
- Alternatives for When You Cannot Install the Update 20240306 or Later of Denodo 8.0
Review the Virtual DataPort Metadata
Import Settings and Metadata in to the New Installation
- Common Errors when Importing the Metadata of Virtual DataPort to the New Version
Post-Upgrade Tasks for the New Installation
Test the New Denodo Platform Installation
Backward Compatibility
Features Deprecated in Denodo Platform

Denodo Platform New Features Guide

Preface
- Audience
What Is New in Denodo 9.5
What Is New in Denodo 9.4
What Is New in Denodo 9.3
What Is New in Denodo 9.2
What Is New in Denodo 9.1
Denodo 9 Highlights
New Features of the Denodo Platform 9

Denodo Platform Administration Guide

Preface
- Audience
Adding AWS RDS Certificate to JRE cacerts
Audit Trail
Credentials Vault Support in the Denodo Platform
Default Ports Used by the Denodo Platform Modules
Denodo Assistant Features
- Denodo Assistant Features That Use Large Language Models
- Other Denodo Assistant Features
Denodo Platform - Subscription Bundles
- Denodo Enterprise Plus
Denodo Security Token Configuration File
- Common Settings
  - Token Signing Credentials
- Authentication Modules
Enable Authentication in the Monitoring Interface of the Web Container
Enabling Kerberos Authentication Without Joining a Kerberos Realm
Health Monitoring
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
Increasing the Maximum Simultaneous Requests
Installation Encryption Key
- Configure Keystore Password Loader
- Keystore Management
Language of Data Marketplace, Design Studio and Scheduler
- Changing the Language of the Applications
- Creating Your Own Language Files
  - Considerations When Translating the Language Files
  - How to Refresh Custom Messages After Installing an Update
Password Policies in the Denodo Platform and Solution Manager
Prevent Load Balancers From Closing Connections of Data Marketplace and Design Studio
- Enabling this Feature in Data Marketplace
- Enabling this Feature in Design Studio
Providing a Krb5 File for Kerberos Authentication
Restrictions of Denodo Express
Reverse Proxy Settings (Design Studio, Data Marketplace, Scheduler)
- Reverse Proxy Configuration
Server Process Identifiers
Session Configuration (Data Marketplace, Design Studio, Diagnostic & Monitoring Tool, Scheduler and Solution Manager Administration Tool)
Setting-up Kerberos Authentication
Transparent Metadata Encryption

Virtual DataPort Administration Guide

Preface
Introduction
General Architecture
Starting Virtual DataPort
Creating Data Sources and Base Views
Creating Derived Views
Stored Procedures
Publication of Web Services
RESTful Architecture
JMS Listeners
Kafka Listeners
Remote Tables
- Managing Remote Tables
- Create Parquet or Iceberg tables on an Object Storage like HDFS, S3 or ADLS
  - Remote Tables vs Other Mechanisms for Persisting Data
Server Configuration
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
Import Tags From External Catalog
Monitoring the Virtual DataPort Server
Cluster Architectures / Server Backup
Data Lake Storage Management
Bulk Data Load
Optimizing Queries
Denodo Lakehouse Accelerator
Import Model
Appendix

Virtual DataPort Developer Guide

Preface
Introduction
- Examples
Access Through JDBC
Access Through ODBC
Access Through Arrow Flight SQL
Access Through an ADO.NET Data Provider
- Using Kerberos Authentication
Access Through OLE DB
Developing Extensions
Custom View Policies
- Developing a Custom View Policy
- Predefined View Policies
  - DYNAMIC_RESTRICTIONS_POLICY
Appendix

Virtual DataPort VQL Guide

Preface
Introduction
General Overview of Virtual DataPort
- Creating or Defining Data
- Executing Statements
Language for Defining and Processing Data: VQL
Functions
- Aggregation Functions
  - AVG
  - COUNT
  - FIRST
  - GROUP_CONCAT
  - LAST
  - LIST
  - MAX
  - MEDIAN
  - MIN
  - NEST
  - STDEV
  - STDEVP
  - STRING_AGG
  - SUM
  - VAR
  - VARP
  - COUNT DISTINCT
- Conversion Functions
- Datetime Functions
  - ADDDAY
  - ADDHOUR
  - ADDMILLIS
  - ADDMINUTE
  - ADDMONTH
  - ADDSECOND
  - ADDWEEK
  - ADDYEAR
  - AT TIME ZONE
  - CONVERT_TIMEZONE
  - CURRENT_DATE
  - CURRENT_TIMESTAMP
  - EXTRACT
  - FIRSTDAYOFMONTH
  - FIRSTDAYOFWEEK
  - FORMATDATE
  - GETDAY
  - GETDAYOFWEEK
  - GETDAYOFYEAR
  - GETDAYSBETWEEN
  - GETHOUR
  - GETMILLISECOND
  - GETMINUTE
  - GETMONTH
  - GETMONTHSBETWEEN
  - GETQUARTER
  - GETSECOND
  - GETTIMEFROMMILLIS
  - GETTIMEINMILLIS
  - GETWEEK
  - GETWEEKSBETWEEN
  - GETYEAR
  - LASTDAYOFMONTH
  - LASTDAYOFWEEK
  - LOCALTIME
  - LOCALTIMESTAMP
  - MAX
  - MIN
  - NEXTWEEKDAY
  - NOW
  - PREVIOUSWEEKDAY
  - SUBTRACT
  - TO_DATE
  - TO_LOCALDATE
  - TO_TIME
  - TO_TIMESTAMP
  - TO_TIMESTAMPTZ
  - TRUNC
- Embedding Functions
- JSON Functions
- Large Language Model Functions
- Numeric Functions
  - ABS
  - ACOS
  - ASIN
  - ATAN
  - ATAN2
  - CEIL
  - COS
  - COT
  - DEGREES
  - DIV
  - EXP
  - FLOOR
  - LN
  - LOG
  - MAX
  - MIN
  - MOD
  - MULT
  - PI
  - POWER
  - RADIANS
  - RAND
  - ROUND
  - SIGN
  - SIN
  - SQRT
  - SUBTRACT
  - SUM
  - TAN
  - TRUNC
- Other Functions
  - COALESCE
  - CONTEXTUALSUMMARY
  - DECODE_BASE64
  - DECRYPT
  - DECRYPT_FIXED
  - ENCODE_BASE64
  - ENCRYPT
  - ENCRYPT_FIXED
  - GETVAR
  - GETCONTEXTVAR
  - GETSESSION
  - HASH
  - HASH_FUNCTION
  - MAP
  - NULLIF
  - PIVOTREGISTER
  - ROWNUM
  - UNPIVOTREGISTER
- Spatial Functions
- Text Functions
  - ASCII
  - BASE64_TO_BASE10
  - BASE64_TO_HEX
  - CHAR
  - CONCAT
  - CONCATLIST
  - DELETESPACES
  - ENDWITH
  - HEX_TO_BASE64
  - INITCAP
  - INSTR
  - LEFT
  - LEFTPAD
  - LEN
  - LOWER
  - LTRIM
  - MAX
  - MIN
  - POSITION
  - PRINTF
  - PROPERCASE
  - REGEXP
  - REGEXP_COUNT
  - RIGHT
  - REMOVEACCENTS
  - REPEAT
  - REPLACE
  - REPLACEMAP
  - RIGHT
  - RIGHTPAD
  - RTRIM
  - SIMILARITY
  - SPLIT
  - STARTWITH
  - SUBSTRING / SUBSTR
  - TRIM
  - UPPER
- Window Functions
  - APPROX_COUNT_DISTINCT
  - AVG
  - COUNT
  - CUME_DIST
  - DENSE_RANK
  - FIRST_VALUE
  - LAG
  - LAST_VALUE
  - LEAD
  - LISTAGG
  - MAX
  - MIN
  - NTILE
  - PERCENTILE_CONT
  - PERCENTILE_DISC
  - PERCENT_RANK
  - RANK
  - ROW_NUMBER
  - SUM
  - STDEV
- XML Functions
Generating Wrappers and Data Sources
Creating a Base View
- Query Capabilities: Search Methods and Wrappers
- Modifying a Base View
Queries: SELECT Statement
Defining a Derived View
Defining the Statistics of a View
Materialized Tables
- Creating Materialized Tables
- Inserting Data into Materialized Tables
Temporary Tables
- Creating Temporary Tables
- Privileges Required
Remote Tables
- CREATE REMOTE TABLE Command
Summaries
- CREATE SUMMARY VIEW Command
- ALTER SUMMARY VIEW Command
Inserts, Updates and Deletes Over Views
Refreshing Views
- REFRESH Statement
ALTER SESSION Statement
Transactions in Virtual DataPort
Stored Procedures
Tags
Defining Other Elements of the Catalog
Creating Databases, Users, Roles and Access Privileges
Global Security Policies
Describing Catalog Elements
- Exporting Metadata
- Importing Metadata
Listing Elements in the Catalog
Removing Elements From the Catalog
Publication of Web Services
RESTful Architecture
- Associations
- Navigational Queries
Help Command
Version Control Systems Integration Commands
Resource Manager
- Managing the Plans of the Resource Manager
- Managing the Rules of the Resource Manager
Advanced Characteristics
Appendix
- Date and Time Pattern Strings

Virtual DataPort API Javadoc

Denodo Lakehouse Accelerator Guide

Preface
Overview
Architecture
Kubernetes Deployment
Configuration
Lakehouse Accelerator at Denodo
- Bulk Data Load with the Denodo Lakehouse Accelerator
  - Configuration
- Cost Based Optimization
Presto on Velox
Deployment
- Object Storage
Scaling
- Autoscaling
- Manually
Observability
Resource Groups
Upgrade to a New Version
Cleanup
Troubleshooting
- Troubleshooting Deployment
- Troubleshooting Usage
Appendix
What Is New in Denodo Lakehouse Accelerator 2.1.0
What Is New in Denodo Lakehouse Accelerator 2.0.0
Older Versions Release Notes

Data Marketplace Guide

Preface
Introduction
Installation and Execution
- Launching the Data Marketplace
Introducing the Data Marketplace
- Search Data Assets or Query Their Content
  - Role and permission needed
Search
- Metadata Search
  - Metadata Search in Index
- Content Search
Denodo Assistant Chatbot
Browse
Databases
Views
Metric Views
Web Services
External Elements
Workflow Requests
Queries
- My Queries
- VQL Shell
User Settings
Authentication
Authorization
Administration
Appendix

Diagnostic & Monitoring Tool Guide

Preface
Introduction
General Architecture
Installation and Execution
- Launching the Diagnostic & Monitoring Tool of the Denodo Platform
- Launching the Diagnostic & Monitoring Tool of the Denodo Solution Manager
Introducing the Diagnostic & Monitoring Tool
Authentication
Authorization
Creating Servers and Environments
- Creating Servers
- Creating Environments
Monitoring
Creating Diagnostics and Diagnostic Intervals
Diagnosing
Export and Import
- Export
- Import
Configuration

Scheduler Administration Guide

Preface
Introduction
General Architecture
Installation and Execution
Administration
Creating and Scheduling Jobs
Developer API
Appendix

Scheduler API Javadoc

Solution Manager Installation Guide

Preface
- Who Should Use This Document
Pre-Installation Tasks
Using the Graphical Installation Wizard
- Settings you can Modify when you Select the Custom Installation
Using the Command Line Installer
Unattended Installation of the Solution Manager
- Modifying the Solution Manager Installer to Include the Latest Update
- Unattended Installation of the Solution Manager
Post-Installation Tasks
Denodo Platform Control Center
Appendix

Solution Manager Administration Guide

Preface
Introduction
- Architecture
Starting the Solution Manager
Introducing the Solution Manager Administration Tool
License Management
Metering
- Usage Reports Table
  - Configuring Automatic Upload
  - Manual Upload to the Denodo Support Site
Configuration
Authentication and Authorization
Denodo Security Token
Environments
Standard Mode
Automated Cloud Mode
Environment Configuration
Clusters Configuration
Servers
- Creating Servers
- Configuring Servers
  - Configuring Server Load Balancing Variables (Standard Mode)
  - Configuring Server Logging Level
Load Balancing Variables
- Creating Load Balancing Variables
- Assigning Values to Loading Balancing Variables
Promotions
Monitoring
- Monitoring Configuration
- Monitoring Virtual DataPort Servers Running Behind a Load Balancer
Import and Export
- Import From Solution Manager 8.0
Appendix

Agora - Subscription Bundles
Differences between Agora and Self-Managed Instances
External Identity Provider
- External Identity Provider General Settings
- SCIM
AWS
Azure

DenodoConnect Components
Quick Start Guides

User Manuals /
ODBC Adapter (Legacy)

ODBC Adapter (Legacy)¶

The content of this page has been moved to the page Legacy ODBC Adapter.

Feedback:

Share:

Add feedback

Copyrights © Denodo Technologies

Code of Conduct Terms of Use Privacy Notice Cookies Notice

Denodo Site Support Site Partner Portal Contact Us