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, system memory management, 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, data sources, interfaces, virtual databases organization, folder/database oriented models, VCS scenarios, view development, cache, custom elements.

Denodo Development Strategy - Development paradigm: development methodologies with the Denodo Platform, 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. It also includes guidance about promoting changes from development.

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

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

Solution Manager Promotion Best Practices: best practices for promotions of elements between environments using the Solution Manager.

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.