Denodo Community
Discover the future of Data Management and Analytics
Welcome to the Denodo Community, here you can find useful technical resources to upskill yourself on the Denodo Platform, learn and discuss with other data management/data integration experts and peers.
I'm an Architect
As an Architect, I make architecture decisions on whether Denodo can be used on a use case/project or not, so I’d be interested in:
Denodo enables business applications to process a series of distributed and heterogeneous data sources, including external sources, as though the data were contained in a large “virtual” database. Here you can find the resources to learn about the architecture of Denodo.
Denodo Overview
- Virtual DataPort General Architecture (User Manual)
- Solution Manager: Denodo General Architecture (User Manual)
- Logical Data Management for Architects (Training Course)
- Denodo Platform Cluster Architecture (Knowledge Base Article)
- Multi-Layer Architecture (Knowledge Base Article)
- RESTful Architecture of Denodo (User Manual)
- Denodo Platform Subscriptions (Web page)
Make it Real: Define your Infrastructure Architecture
- Expert Trail: Deployment Topology (Expert Trail)
- Denodo Security Overview (Knowledge Base Article)
- Cluster Architectures / High Availability (User Manual)
Denodo exposes the information of your data infrastructure as views and web services. Here you can find the resources to learn how Denodo can help you when building these solutions and use cases.
Generative AI
- Assisted Queries by IA in the Data Catalog (Video)
- Data Catalog /Guide: Assisted Query (User Manual)
- Use Denodo and data fabric to enable RAG implementation (Denodo TechTalk)
- Denodo Supercharges AI for Enterprises with NVIDIA's NIM Integrations (Denodo TechTalk)
IT Infrastructure Modernization
- Logical Data Fabric Whitepaper (Whitepaper)
- Data Fabric and Denodo (Tutorial)
- Logical Data Fabric and Denodo (Training Course)
Cloud Modernization
- Denodo Cloud Architectures (Knowledge Base Article)
- Denodo Installation: Automated Cloud Mode (User Manual)
- Suggested Reading Materials to Use the Automated Cloud Mode (User Manual)
- Architecture of a Deployment of Solution Manager in Cloud (User Manual)
- Denodo for Cloud Marketplaces 8.0 (User Manual)
Data Self-Service for Data Democratization
- Denodo and BI Tools (Knowledge Base Article)
- Introducing the Denodo Data Catalog (User Manual)
- Using Notebooks for Data Science with Denodo (Knowledge Base Article)
- Denodo in Data Science and Machine Learning Projects (Knowledge Base Article)
Centralized Governance, Risk and Compliance
- Drive Data Privacy Regulatory Compliance (Denodo TechTalk)
- Denodo Security Overview (Knowledge Base Article)
- Global Security Policies (User Manual)
- Surpassing Element by Element Access Control: Semantic-Based Security Policies (Denodo TechTalk)
- How to Use Denodo Tags (Knowledge Base Article)
- Maximizing Data Governance Efficiency with Denodo and Collibra (Denodo TechTalk)
- Denodo Governance Bridge (User Manual)
- Privilege Auditing (User Manual)
- Enterprise Monitoring and Auditing in Denodo (Denodo TechTalk)
Operational Efficiency, Agility and Resilience
- RESTful Architecture of Denodo (User Manual)
- Data Services and Data Mesh projects made easy using Top-Down Modeling (Denodo TechTalk)
- Publication of Web Services (User Manual)
- How to implement Web Service Versioning in Denodo (Knowledge Base Article)
- Data Services (Tutorial)
Logical Data Lake
- Denodo Embedded MPP Guide (User Manual)
- Modeling Big Data and Analytic Use Cases (Knowledge Base Article)
- Data Virtualization and ETL (Knowledge Base Article)
Here you can find the list of Educational resources in case you want to learn about Denodo in a more guided-fashion.
Basic Topics
- Introduction to Logical Architectures (Training Course)
- Denodo Essentials (Training Course)
Core Topics for Architects
- Logical Data Management for Architects (Training Course)
- Logical Data Fabric and Denodo (Training Course)
- Self-Service and Data Marketplace with Denodo (Training Course)
Additional Topics
- Concepts for Architecting a Denodo Platform Deployment (Training Course)
- Beyond Query Optimizer: A Journey into Query Optimization Excellence (Training Course)
Stay Up to Date
- Denodo Platform Updates (Video Category)
Are you looking for something else? Try browsing our entire Content library for Architect
I'm a Developer
As a Denodo Developer, I use the Denodo web applications (Design Studio and Scheduler) to implement data projects using a logical approach to access the data. Some of my responsibilities are: connect to distributed data sources, build out virtual views, optimize queries, test views, document the project, etc.
The main responsibility for a Denodo Developer is building virtual views. The following resources talk about the best way to develop and organize virtual views in Denodo, and best practices for managing your Denodo projects.
View Development
- Data Virtualization Basics (Tutorial)
- Creating Data Sources and Base Views (User Manual)
- Expert Trail: DataSource Connectivity (Expert Trail)
- Connectors included in Denodo (Video)
- Data Sources(Knowledge Base Category)
- Data Combination(Tutorial)
- Creating Views (User Manual)
- Associations in Denodo (Knowledge Base Article)
- Data Services (Tutorial)
- Publication of web services (User Manual)
Development Best Practices
- Groups of Elements in Denodo (Knowledge Base Article)
- Development & Admin Best Practices (Knowledge Base Article)
- Denodo Development Best Practices(Knowledge Base Category)
- VDP Naming Conventions (Knowledge Base Article)
- SCHED Naming Conventions (Knowledge Base Article)
- Expert Trail: Modeling and Metadata Organization (Expert Trail)
Denodo Project Lifecycle
- Expert Trail: Development Lifecycle (Expert Trail)
- Denodo Project Lifecycle (Knowledge Base Article)
- Denodo Best Practices and Guidelines (Knowledge Base Category)
- Development Strategy and Best Practices with Denodo (Denodo TechTalk)
- Denodo Development Strategy - Development paradigm (Knowledge Base Article)
Performance matters a lot. Here you can find some essential articles to learn about the best practices to maximize the performance of the Denodo views.
Optimizing Queries
- Optimizing queries (User Manual)
- Expert Trail: Query Performance Optimization (Expert Trail)
Best Practices to Maximize Performance
- Best Practices to Maximize Performance I: Modeling Big Data and Analytic Use Cases (Knowledge Base Article)
- Best Practices to Maximize Performance II: Configuring the Query Optimizer (Knowledge Base Article)
- Best Practices to Maximize Performance III: Caching (Knowledge Base Category)
- Best Practices to Maximize Performance IV: Detecting Bottlenecks in a Query (Knowledge Base Article)
Here you can find the list of Educational resources in case you want to learn about Denodo in a more guided-fashion.
Basic Topics
- Introduction to Logical Architecture (Training Course)
- Denodo Essentials (Training Course)
Core Topics for Developers
- Implementing My First Logical Data Integration ( (Training Course)
- Beyond Query Optimizer: A Journey into Query Optimization Excellence (Training Course)
- Data Modeling with Denodo (Training Course)
- Denodo Project Management (Training Course)
Additional Topics
- Denodo Platform Endpoints (Training Course)
- Building API services with Denodo (Training Course)
- Advanced Configuration of Denodo Views (Training Course)
- Denodo Task Scheduling (Training Course)
Stay Up to Date
- Denodo Platform Updates (Video Category)
Are you looking for something else? Try browsing our entire Content library for Developer
I'm an Administrator
As Denodo Administrator, I implement the deployment architecture, make decisions on the operational practices, and do the work of the global administrator of Denodo Platform. I'd be interested in:
- Infrastructure Implementation
- Security Architecture
- Operational Best Practices
- Learning Path for Administrators
Here you can find resources to check the Denodo hardware and software requirements, how to install Denodo, set up a cluster of Denodo servers in high availability, and define failover and backup policies.
Specify Denodo Hardware and Software Requirements
- Denodo Platform General Architecture (User Manual)
- Solution Manager Hardware Requirements (User Manual)
- Solution Manager Software Requirements (User Manual)
- Denodo Platform Hardware Requirements (User Manual)
- Denodo Platform Software Requirements (User Manual)
Install Denodo Platform
- Solution Manager Installation Guide (User Manual)
- Solution Manager Installation Checklist (Knowledge Base Article)
- Denodo Platform Installation Guide (User Manual)
- Denodo Platform Installation Checklist (Knowledge Base Article)
- Silent/Unattended Installation (Knowledge Base Article)
- Expert Trail: Operations - Stages 1 and 2: Installing (Expert Trail)
- Denodo Embedded MPP Kubernetes Deployment (User Manual)
Update Denodo Platform with the Latest Enhancements and Bugfixes
- How to identify the Denodo Platform version and update installed (Knowledge Base Article)
- Installing Updates and Hotfixes (User Manual)
- Are Denodo Updates Cumulative or Incremental (Knowledge Base Article)
- Is it possible to uninstall a Denodo update? (Knowledge Base Article)
- Expert Trail: Operations - Stage 3: Installing the Latest Update (Expert Trail)
Run Denodo Platform on Containers
- Denodo Platform Container 8.0 QuickStart Guide (User Manual)
- How to create your own Docker images for Denodo Platform Containers (Knowledge Base Article)
- Deploying Denodo in Kubernetes (Knowledge Base Article)
- Deploying the Denodo Solution Manager in Kubernetes (Knowledge Base Article)
Define Environments and Clusters of Denodo Platform servers
- Denodo Platform General Architecture (User Manual)
- Cluster Architectures / High Availability (User Manual)
- Denodo Platform Cluster Architecture (Knowledge Base Article)
- Managing Denodo Licenses (Tutorial)
- Solution Manager Standard Mode (on premises cluster) (User Manual)
- Solution Manager Automated Cloud Mode (cloud cluster) (User Manual)
- Suggested Reading Materials to Use the Automated Cloud Mode (User Manual)
- How to configure a VDP Backup server in the Solution Manager (Knowledge Base Article)
Create Failover and Backup Policies
- Automating status check of Denodo services (Knowledge Base Article)
- Using the Import/Export Scripts for Backup And/or Replication (User Manual)
- Automated Cloud Mode - Creating a Backup (User Manual)
- Expert Trail: Operations - Stage 6: Backup and Recovery Policies (Expert Trail)
Here you can find resources to secure the Denodo Platform installation.
Data in Motion / Data at Rest
- Denodo Security Overview (Knowledge Base Article)
- Enable SSL/TLS in the Denodo Platform (User Manual)
- SSL connection from Denodo to data sources (Knowledge Base Article)
- Replicate the Encryption Key Across All the Installations (User Manual)
- Expert Trail: Security - Stage 1 and 2: Securing Data (Expert Trail)
Authentication Best Practices
- How to configure a VDP database with LDAP authentication (Knowledge Base Article)
- LDAP Authentication at Server Level (Video Category)
- LDAP Authentication Best Practices (Knowledge Base Article)
- SAML Authentication (User Manual)
- Kerberos configuration and troubleshooting (Knowledge Base Article)
- Authenticating with Single Sign-On (User Manual)
- Kerberizing Denodo for SSO - Step by step guide (Knowledge Base Article)
- Expert Trail: Security - Stage 3: Integration with a Centralized (Expert Trail)
Authorization Policies
- Databases, Users and Access Rights in Virtual DataPort (User Manual)
- Solution Manager Authorization (User Manual)
- Global Security Policies (User Manual)
- Data Governance (Tutorial)
- Best practices in designing fine-grained privileges in multi-layered virtual models (Knowledge Base Article)
- Expert Trail: Security - Stage 4: Configuring Permissions in Denodo (Expert Trail)
Here you can find resources to configure Denodo Platform and define standard procedures as administrator.
Denodo Servers Configuration
- Denodo Platform Configuration (User Manual)
- Solution Manager Configuration (User Manual)
- Data Catalog Administration (Tutorial)
- Embedded MPP Configuration (User Manual)
- Denodo Admin and Development Best Practices (Knowledge Base Article)
- Configuring the Cache (User Manual)
- Cache database size estimate (Knowledge Base Article)
- Expert Trail: Cache (Expert Trail)
- Memory Management (User Manual)
Define Version Control Best Practices
- VCS Configuration (User Manual)
- Picking a VCS Workflow (User Manual)
- Best Practices When Using the Integration with a VCS (User Manual)
- VCS Branching Best Practices (Knowledge Base Article)
Define a Promotion Between Environments Strategy
- Promotion using Denodo Solution Manager (User Manual)
- Solution Manager Promotion Best Practices (Knowledge Base Article)
- Denodo Solution Manager: Best Practices for Promotion (Denodo TechTalk)
- Promoting Metadata (Tutorial)
- Expert Trail: Operations - Stage 4 (Expert Trail)
Resource management
- Resource Manager (User Manual)
- Workload Management (Tutorial)
- Expert Trail: Operations - Stage 8: Resource Management (Expert Trail)
Monitoring & Diagnostics
- Diagnostic and Monitoring Tool Guide (User Manual)
- Denodo Monitor global configuration from Solution Manager (User Manual)
- Configuring alerts in Denodo (Knowledge Base Article)
- Expert Trail: Monitoring (Expert Trail)
- Denodo Embedded MPP Troubleshooting Guide (User Manual)
Here you can find the list of Educational resources in case you want to learn about Denodo in a more guided-fashion.
Basic Topics
- Introduction to Data Virtualization (Training Course)
- Denodo Essentials (Training Course)
Core Topics for Administrators
- Concepts for Architecting a Denodo Platform Deployment (Training Course)
- Denodo Platform Installation (Training Course)
- Denodo Operations Management (Training Course)
- Denodo Security Management (Training Course)
Additional Topics
- Denodo Performance Monitoring (Training Course)
- Denodo Data Management (Training Course)
- Denodo Platform Endpoints (Training Course)
- Denodo Task Scheduling (Training Course)
Stay Up to Date
- Denodo Platform Updates (Video Category)
Are you looking for something else? Try browsing our entire Content library for Administrator
I'm an End User
As an End User, I consume data or search for data using the Denodo Data Catalog or an application connected via web services to Denodo such as a reporting tool. Typically do not have to develop anything so I’d be interested in:.
Denodo servers expose the information of your data infrastructure as views and web services. These are the data assets you should analyze to obtain valuable information and make better decisions. Here you can find the resources to learn how Data Catalog can help you discover your valuable data resources.
Use Denodo Data Catalog
- Introducing the Data Catalog (User Manual)
- Data Discovery (Tutorial)
Here you can find the resources to learn how you can connect from any application to Denodo in order to query the virtual views created over your data sources.
Denodo Generic Connectors
- Access through JDBC (User Manual)
- Access through ODBC (User Manual)
- Access Through an ADO.NET Data Provider (User Manual)
- Denodo RESTful Web Service (User Manual)
- GraphQL Basic Querying (User Manual)
- OData 4.0 - Querying Data: The Basics (User Manual)
Connect to Denodo from Third-party applications
- Consumers (Knowledge Base Category)
- Denodo and BI Tools (Knowledge Base Category)
Execute queries in Denodo
- Assisted Queries by AI in the Data Catalog (Video)
- VQL Queries: SELECT Statement (User Manual)
- RESTful Web Service: IDU Requests (User Manual)
Here you can find the list of Educational resources in case you want to learn about Denodo in a more guided-fashion.
Basic Topics
- Introduction to Logical Architectures (Training Course)
- Denodo Essentials (Training Course)
Core Topics for End Users
- Data Discovery with Denodo Data Catalog (Training Course)
Additional Topics
- Denodo Platform Endpoints (Training Course)
Stay Up to Date
- Denodo Platform Updates (Video Category)
Are you looking for something else? Try browsing our entire Content library for End User
I'm a Data Analyst
As a Data Analyst, I get data from Denodo to build analytic scripts or reports for other End Users. I can use notebooks and/or other analytical and reporting tools on top of Denodo. I’d be interested in:
- Data Preparation
- Connect to Denodo from a Notebook
- Connect to Denodo from other Applications
- Machine Learning
- Learning Path for Data Analysts
Data preparation is crucial to optimize the process of data analysis. Denodo Data Catalog has a WYSIWYG data preparation editor to make this process easier.
Data Preparation in Denodo Data Catalog
- Data Preparation in Denodo Data Catalog (Video)
- Data Preparation (User Manual)
- Add a Derived Field using AI Recommendations (User Manual)
Data science gets done in notebooks. Here you can find the resources to learn how to use the Apache Zeppelin notebook customized for Denodo or connect other popular notebooks to Denodo.
Use Python and the Denodo Dialect for SQLAlchemy
- Denodo Dialect for SQLAlchemy (User Manual)
- How to connect to Denodo from Python - a starter for Data Scientists (Knowledge Base Article)
Use a Notebook
- Using Notebooks for Data Science with Denodo (Knowledge Base Article)
- How to connect to Denodo from Amazon SageMaker (Knowledge Base Article)
Here you can find the resources to learn how you can connect from other applications to Denodo in order to query the virtual views created over your data sources.
Denodo Generic Connectors
- Access through JDBC (User Manual)
- Access through ODBC (User Manual)
- Access Through an ADO.NET Data Provider (User Manual)
- Denodo RESTful Web Service (User Manual)
- GraphQL Basic Querying (User Manual)
- OData 4.0 - Querying Data: The Basics (User Manual)
Connect to Denodo from Third-party applications
- Consumers (Knowledge Base Category)
- Denodo and BI Tools (Knowledge Base Category)
- Agile BI (Tutorial)
Execute queries in Denodo
- VQL Queries: SELECT Statement (User Manual)
- RESTful Web Service: IDU Requests (User Manual)
Machine learning is key for making predictions or decisions based on data. Here you can find the resources to learn what is the role of Denodo in data science projects.
Use Denodo in Data Science projects
- Denodo in Data Science and Machine Learning Projects (Knowledge Base Article)
- Data Science & Machine Learning (Tutorial)
Here you can find the list of Educational resources in case you want to learn about Denodo in a more guided-fashion.
Basic Topics
- Introduction to Logical Architectures (Training Course)
- Denodo Essentials (Training Course)
Core Topics for Data Analysts
- Data Discovery with Denodo Data Catalog (Training Course)
- Denodo for Data Analytics (Training Course)
- Denodo Platform Endpoints (Training Course)
Stay Up to Date
- Denodo Platform Updates (Video Category)
Are you looking for something else? Try browsing our entire Content library for Data Analyst