This document is a compilation of Denodo Best Practices and Guidelines available in the Platform’s documentation and in the Denodo Community Knowledge Base.

General Best Practices (Development and Admin)

Denodo Admin and Development Best Practices: common administration best practices, including recommendations around installation, database management, security, JVM configuration, cache configuration, replication, monitoring, virtual machines, etc. It also includes guidance on development aspects like environment set-up, naming conventions, documenting virtual schemas, metadata storage, versioning, and query profiling (data lineage, execution traces).

Denodo Development Best Practices: project structure, interfaces, virtual databases organization, folder/database oriented models, VCS scenarios, view development, cache.

Denodo Development Strategy - Development paradigm: development methodologies, agile development.

Development and Teams

Version Control Systems Integration: Scenarios And Recommended Uses: this section of the documentation describes different development models and provides recommendations when integrating with Version Control Systems.

Denodo Project Lifecycle: basic project lifecycle, promotion between environments, testig, server maintenance.

Denodo Deployments and Continuous Integration: deployment process, revisions, Jenkins Denodo Testing Tool, continuous integration, promotion process.

Security

LDAP authentication best practices: general recommendations around the security when integrating Denodo and Active Directory or LDAP.

Testing

Denodo Testing Tool: this tool allows Denodo users to easily automate the testing of their data virtualization scenarios, both during the development of their virtualized solutions and during their maintenance, acting as a safety net before applying any significant changes to these environments. The Denodo Testing Tool can be downloaded from the Denodo Connect section of the Support site. The downloadable contains the Denodo Testing Tool User Manual which has the detailed instructions on the configuration steps.  

Testing in Denodo: Denodo Testing Tool, Unit Testing, Integration Testing, System Testing, Acceptance Testing.

Workload and Performance Tuning

Optimizing Queries: This section of the documentation describes different aspects related to query optimization in Denodo, including cost-based optimization, Data Movement, Parallel Processing, Query Simplification, etc.

Denodo Query Optimizations for the Logical Data Warehouse: very comprehensive document with detailed explanations about how the Denodo Query Optimizer works. It also contains examples around a Logical Data Warehouse scenario to show you how to set up your environment to leverage these optimization techniques.

Denodo Load Testing with Apache JMeter: This document explains how to configure Apache JMeter to simulate workloads on the Denodo Platform and carry out performance tests.

Denodo Load Testing with LoadRunner: This document explains how to configure LoadRunner for load/stress tests on the Denodo Platform.