USER MANUALS

What Is New in Denodo 8.0u20240926

This page lists the main enhancements of the update 8.0u20240926 of the Denodo Platform and the Solution Manager.

We also published these videos that explain the enhancements included in this update:

For the full list of enhancements and bug fixes, read the Release Notes in the Support Site, in the page of this update.

Virtual DataPort

  • New functions: LEFT and RIGHT. They extract a specified number of characters from the beginning or end of a text string.

  • New features to improve the stability of Virtual DataPort:

    • New memory stability controller (see Automatic Out Of Memory Recovery).

    • Limit the number of generated files in swapping processes. That is, there are two new settings: Maximum disk space that can be used for swapping (MB) and Maximum number of swap files that can be opened at the same time (see Swapping Settings).

  • Applications can already use ADO.Net to connect to Virtual DataPort. Now, Virtual DataPort supports newer versions of ADO.Net (see Access Through an ADO.NET Data Provider).

Virtual DataPort - Data Sources

Virtual DataPort - Execution Engine

Several performance improvements:

  • When executing a SQL query with an unnecessary join with a view from a different data source, and a possible aggregation push down under that join, the optimizer will apply aggregation push-down even if after the pruning the query could be fully pushed to the data source.

  • Improve the performance of several metadata operations when the metadata is stored in an external database.

  • Saving changes in an existing view is faster, particularly in views that are part of a large hierarchy of derived views.

  • Reduce the memory usage of the stored procedures VIEW_DEPENDENCIES, COLUMN_DEPENDENCIES and CATALOG_PERMISSIONS.

Virtual DataPort - ODBC Driver

The ODBC driver now supports:

  • OAuth authentication with multi-factor authentication

  • OAuth refresh token flow.

Virtual DataPort - Operations and Security

  • New roles to grant privileges to users:

    • read_all_privileges: grants the privilege of viewing - but not modifying - the privileges of all the users and roles.

    • assign_vdb_admin_privileges: grants the privilege to assign all the privileges over a database and its elements, excluding the “global administrator” privilege, to all users and roles.

    The page Default Roles lists all the default roles.

  • Global Security Policies (GSPs):

    • In a GSP that uses a custom masking expression, you can now use the wildcard anytag (see Custom Masking Expression with Wildcard Tag Name).

    • When defining a GSP with an Audience = Attributes of the user’s session, there is a new attribute you can use: userRoles. It represents all the effective roles of the user that runs the query.

Data Catalog

Added enhancements to the feature Assisted queries like improving the data sent to the large language model to obtain a more accurate response, and several improvements to the user interface.

OData Service

The OData service now supports the function date. For example https://.../actor?$filter=last_update lt date(now()) (see Date Functions)

GraphQL Service

You can now obtain specific subfields of an array or a register (see Basic Querying).

Scheduler

When storing the metadata of Scheduler on Amazon Aurora, Scheduler now supports using the authentication methods AWS IAM credentials and AWS instance credentials.

Solution Manager

Implemented an audit trail feature to track user operations within the Solution Manager. This functionality records and logs all user actions, providing a comprehensive audit trail for monitoring and analysis purposes.

Information about Deprecated Features

The following features are not going to be available in the next major version (Denodo 9):

  • ITPilot.

  • The Denodo4Eclipse Plugin.

  • In Scheduler, the support for Elasticsearch 5.x and 6.x (future versions of Elasticsearch are still supported).

  • In Virtual DataPort:

    • In the Version Control System feature, the integration with Subversion and Microsoft Team Foundation Server (TFS).

    • The VQL functions “IS_PROJECTED_FIELD” and “TEXTCONSTANT”.

    • Widgets.

This list was compiled on May 08, 2025; there could be more features that are already deprecated that finally, will not be available in Denodo 9.

These features were already deprecated with the release of Denodo 8.0 or one of its updates.

The page Features Deprecated in Denodo Platform 8.0 lists all the features that are deprecated.

Add feedback