TIBCO® Data Virtualization

TIBCO® Data Virtualization integrates disparate data sources in real-time instead of copying their data into a data warehouse. TIBCO® Data Virtualization allows you to easily create logical views to integrate and secure data across disparate data sources and tailor it to your analytical needs. TDV connects to virtually any data source and provides business users access to data through JDBC, ODBC, ADO.NET, REST and SOAP.

Version: 8.8.0
Release: October 2023

 

Web-UI Enhancements

  • Improved User Experience

— Updated Filter Node’s design to be more intuitive and user friendly

  • Undo/Redo Flow Changes

— Users can undo or redo the changes to the flow with the provided buttons or through keystrokes.

Driver Enhancements

  • Added support for Dynamic Relational DataSource Configuration

— A callback TDV procedure, that is implemented in SQL Script or as a custom Java procedure (CJP) and owned by TDV administrators, can be registered with a relational data source to apply runtime customizations to the data source properties configuration before a connection is used by the TDV server to establish a new session with the data source. All customizations are transient. Their scope is limited to the specification of the JDBC properties to be used by data source connections.
— As an example, an administrator could define a SQL Script procedure that determines the user associated with an incoming request accessing a relational data source and use TDV domain specific language (DSL) statements to adjust its JDBC connection properties to reflect what type of access - ReadWrite or ReadOnly - should apply to the data source connection used by the user request.

  • Vertica - text index

— Added support to create and drop text index in Vertica driver.
— The source table on which the index is to be created must have a primary key and an associated projection. It must also be both sorted and segmented by the primary key.

  • File System Adapters Date Inference - File System Adapters such as LFS, S3, Azure Data Lake, and GCS now infer the data type of file columns carrying date values as DATE.

Query Engine Enhancements

  • Introduced new functions WEEKNUM, BYTE_SUBSTR, SUBSTR, CONVERT_TO and CONVERT_FROM

    • CONVERT_TO and CONVERT_FROM are supported only for Postgres.

Security Enhancements

  • Enhanced OAuth2 support for REST Adapter for fetching Access Tokens

  • Support for Opaque OAuth Tokens

— This enhancement introduces supports consuming the opaque OAuth tokens for JDBC, ODBC, and ADO.NET drivers

  • Enhanced AzureAD as IdP

  • Improved Log Out experience for OAuth logins

Studio Enhancements

  • Review CDATA adapter version in Studio

— The adapter version for CDATA Adapters can now be viewed in the Info Panel of the CDATA Adapters in the Studio

  • Multi-table cache table privilege inheritance

    • A checkbox to “Copy Privileges from parent folder” has been added to the cache table creation panel.

Miscellaneous

  • Support for XQuery 3.1

— XQuery 3.1 introduces support for consuming JSON data and supports maps & arrays.

  • Language Selection during Login

— Users can now select the language (default English) while logging in through Studio, WebUI, Manager, Deployment Manager, and Business Directory

  • Upgrade to Java 17

— This version of the product uses Java 17

  • Kubernetes Deployment to use micro-services

— Kubernetes deployment has been refactored to use separate containers for TDV server, cache and repository

Supported Platforms

For the complete list of supported platforms, refer to the Installation and Upgrade Guide.

This release adds support for -

  • Oracle Enterprise Linux 8

  • Oracle Enterprise Linux 9

  • Red Hat Enterprise Linux 8

  • Red Hat Enterprise Linux 9

  • Rocky Linux 8

  • AlmaLinux 8

  • SUSE Linux Enterprise Server 15

  • IBM AIX 7.3

  • Windows 11

  • Ubuntu 22 (Docker and Kubernetes Distribution)

Dropped support for:

  • Microsoft Windows Server 2012

  • IBM AIX 7.1

  • Oracle Enterprise Linux 6

See What's New