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)
- Data Virtualization Architect (Training Course)
- Denodo Platform Cluster Architecture (Knowledge Base Article)
- Multi-Layer Architecture (Knowledge Base Article)
- RESTful Architecture of Denodo (User Manual)
- Denodo Subscriptions and Features (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.
Logical Data Fabric
- Logical Data Fabric Whitepaper (Whitepaper)
- Logical Data Fabric and Denodo (Training Course)
BI and Data Science/Analytics
- 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)
Cloud Solutions
- 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 Governance
- 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)
- Privilege Auditing (User Manual)
- Denodo Governance Bridge (User Manual)
Data Services
- RESTful Architecture of Denodo (User Manual)
- Publication of Web Services (User Manual)
- How to implement Web Service Versioning in Denodo (Knowledge Base Article)
- Data Services (Tutorial)
Big Data
- Denodo Presto Cluster on Kubernetes (User Manual)
- Data Virtualization and ETL (Knowledge Base Article)
- Modeling Big Data and Analytic Use Cases (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 Data Virtualization (Training Course)
- Denodo Essentials (Training Course)
Core Topics for Architects
- Data Virtualization Champion (Training Course)
- Data Virtualization Architect (Training Course)
- Logical Data Fabric and Denodo (Training Course)
Additional Topics
- Denodo Deployment Configuration (Training Course)
- Denodo Performance Best Practices (Training Course)
- Data Modeling with Denodo (Training Course)
- Denodo Security Management (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)
- Data Sources(Knowledge Base Category)
- Creating Views (User Manual)
- Associations in Denodo (Knowledge Base Article)
- 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 (Knowledge Base Article)
- 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 Data Virtualization (Training Course)
- Denodo Essentials (Training Course)
Core Topics for Developers
- Connecting and Combining Data with Denodo (Training Course)
- Denodo Performance Best Practices (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 (Expert Trail)
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 (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)
- Automated LifeCycle Management (Tutorial)
- Solution Manager Standard Mode (on premises cluster) (User Manual)
- Solution Manager Automated Cloud Mode (cloud cluster) (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 (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)
- Transparent Metadata Encryption (User Manual)
- Expert Trail: Security - Stage 1 and 2 (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 (Expert Trail)
Authorization Policies
- Databases, Users and Access Rights in Virtual DataPort (User Manual)
- Solution Manager Authorization (User Manual)
- Global Security Policies (User Manual)
- Global Security Policies and Tags (Tutorial)
- Best practices in designing fine-grained privileges in multi-layered virtual models (Knowledge Base Article)
- Expert Trail: Security - Stage 4 (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)
- 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)
- Expert Trail: Operations - Stage 4 (Expert Trail)
Resource management
- Resource Manager (User Manual)
- Workload Management (Tutorial)
- Expert Trail: Operations - Stage 8 (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)
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
- Denodo Deployment Configuration (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
- 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 Data Virtualization (Training Course)
- Denodo Essentials (Training Course)
Core Topics for End Users
- Self-service and Visualizing Data (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:
- Connect to Denodo from a Notebook
- Connect to Denodo from Consumers
- Machine Learning
- Learning Path for Data Analysts
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 the Apache Zeppelin for Denodo Notebook
- DenodoConnect: Apache Zeppelin for Denodo (User Manual)
Use Other Notebooks
- Using Notebooks for Data Science with Denodo (Knowledge Base Article)
- How to connect to Denodo from Python (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)
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 Data Virtualization (Training Course)
- Denodo Essentials (Training Course)
Core Topics for Data Analysts
- Self-service and Visualizing Data (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