Table of Contents

• Preface
  • Scope
  • Audience
• What Is New in Denodo 6.0 Update 20201123
• Installer
  • Command Line Installer
  • Unattended Installations
  • Client Installer
• Common to All Modules
  • Information Self-Service Tool
  • Control Center
  • Privileges
  • Logging System
    • Clearer Date Format
  • Stability Improvements: SSL
  • Windows Services
• Virtual DataPort
  • Using Elements from Other Database
  • Administration Tool
    • Execution Trace
    • Data Lineage: Show the Implementation Expressions of Interface Views
    • “Please Wait Dialog” Indicates User is waiting for Transaction
  • Date and Time Values
  • Support for Windows 10
  • JDBC Data Sources
    • Support for Amazon Redshift
    • Support for Teradata Version 14 and 15
    • Upgrade of the jTDS Driver
    • Oracle Adapter Indicates Escape Character
    • IBM DB2: Support for Nickname Elements
    • Microsoft SQL Server: Support for Pass-Through Authentication Using the Domain of the User
    • Data Sources with OAuth Authentication: Tokens as Interpolation Variables
  • Excel Data Sources: Allow Selecting Multiple WorkSheets
  • Execution Engine
    • Automatic Data Movement Based on Statistics
    • Improvements in the Cost-Based Optimizations
    • Support for Analytical Functions Delegable to the Source
    • Support for ORDER BY with Expressions
    • Canceled Queries Are Terminated after Waiting Five Minutes for all the Threads to Finish
  • Navigational Queries
    • SELECT_NAVIGATIONAL: Support for the EXPAND clause
    • SELECT_NAVIGATIONAL: Support for Projecting COUNT(*) and Other Aggregation Functions with an Alias.
  • Performance Improvements
    • LDAP Authentication
    • Improvements on the Metadata Cache
  • Custom Functions API: Provide Access to Contextual Information of the Query
  • Out-of-the-box Stored Procedures: CATALOG_PERMISSIONS
  • Monitoring
    • Denodo Monitor
    • MBean VDBServerManagementInfo: New Operation getRequestById.
    • MBeans TransactionsManagementInfo Events: New Attribute SessionId
  • Version Control System (VCS)
    • Support for GIT
  • Cache
    • New Database Adapters: Vertica 7 and Teradata 14 and 15
    • Changing a Parameter of the Connection
  • Resource Manager
  • Upgrade of the Java Secure Channel Library (JSCH)
  • JDBC Driver
    • Support for the JDBC 4.1 API
    • Support for Ignoring the “setAutoCommit” Parameter
  • ODBC Driver
  • RESTful Web Service: Simpler Format for Conditions with Compound Values
  • Backward Compatibility Between Updates of the Same Major Version
  • New Version of the Logging Library: Apache Log4j 2
• Embedded Web Container
  • New Version of the Web Container: Apache Tomcat 8
  • Tomcat Uses One More Port