TIBCO® Data Virtualization

TIBCO® Data Virtualizationintegrates 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.

Version: 8.7
Release: October 2023
Download Help

Driver Improvements

  • TDV drivers JDBC/ODBC/ADO.Net now supports OAuth Token (headless flow). A new configuration parameter delegateOauth2flowToServer has been added.

This is a flag used to indicate whether the oauth2 ROPC flow delegation is used for JDBC/ODBC/ADO.net driver. set this to True to delegate OAUTH2 ROPC flow to TDV server from JDBC/ODBC/ADO.net driver and invoke a call to the oauth IDP and get token from it. set this to false to indicate not to delegate OAUTH2 ROPC flow to TDV server from JDBC/ODBC/ADO.net driver.

  • A new optional property has been added in Connection String of the JDBC/ODBC?ADO.Net drivers that will enable TCP-KeepAlive for the connection.. In the DSN Editor UI(ODBC) this property is located under 'connection' tab

Property Name: EnableKeepAlive
Property Type: Boolean
Default Value: false

  • ADO.Net logger performance has been improved.

 

TDV Server Improvements

  • Multiple Workload Management Rules can be defined for User Requests. A rule action is triggered when the user request satisfies a rule. All rules except the EXCEPTION can be invoked many times within the life cycle of request. The EXCEPTION rule however, terminates the request by throwing an exception that has been defined.

  • To reduce the traffic in KPI Metrics, you now have the ability to filter internal and server sessions.

 

Query Engine Improvements

  • TDV’s DECIMAL data type now supports arbitrary values. Datasources Oracle, Postgres, Teradata, Greenplum (fork of Postgres) support this arbitrary NUMERIC datatype.

  • Support has been added for the DDL statement CREATE OR REPLACE TABLE DDL

  • Support has been added for pre-aggregation over UNION ALL when the aggregate function is a composite function.

  • Support has been added to the function TO_NCHAR.

  • Numeric Division is now supported when performing integer divisions. To enable/disable this, use the configuration option /server/sql/language/numericDivision.

  • New SELECT option has been included NO_DATA_CACHE_IMMEDIATE. This disables caching for immediate views only. It does not affect sub views.

     

Security Enhacements

  • TDV drivers JDBC/ODBC/ADO.Net now supports OAuth Token (headless flow). A new configuration parameter delegateOauth2flowToServer has been added.

This is a flag used to indicate whether the oauth2 ROPC flow delegation is used for JDBC/ODBC/ADO.net driver. set this to True to delegate OAUTH2 ROPC flow to TDV server from JDBC/ODBC/ADO.net driver and invoke a call to the oauth IDP and get token from it. set this to false to indicate not to delegate OAUTH2 ROPC flow to TDV server from JDBC/ODBC/ADO.net driver

  • TDV now supports the field Scope when creating an OAuth domain. Microsoft Azure requires to have "application ID URI" in front of the scope values (ie. prefix api://...). This will enable TDV to receive a valid access token that has a valid issuer value.

     

Studio Enhancements

  • TDV Studio Editor has been replaced. Some of the notable features are:

    • Occurrence bar is added to the right edge of the editor which shows the current matches in the Find/Replace context
    • Bookmarks are added. These bookmarks are not retained when the content is reloaded. They are useful in the current editing session only.
    • Context menu is added for the most commonly used editor commands (You can activate the context menu by Right mouse click).
    • Line numbers can be turned on and off from the user preference. Line number color can be customized as well.
    • You can set options such as Auto-complete, Line number, Line wrap, Auto-Capitilization, Syntax Coloring, Fonts etc. from the Editor Preferences window. Access the Editor Preferences by choosing Edit->Options from the TDV Studio menu and choosing the Editor tab.
    • The Find/Replace interface looks slightly different from the old editor, but most of the functions are retained.
    • Status bar now includes the read-only indicator, line-wrap toggle, and the line and character count tool-tip over the cursor location indicator. The PC/UNIX/Mac line ending option has been removed.
    • User preferences and keyboard shortcut quick help have been updated accordingly
    • Syntax Highlighting has been retained from the previous editor and most of the functions are the same. Currently XQuery editor comments are not highlighted.
    • Resource paths will not be auto-completed in the editor. Drag and drop the resources to your editor pane to display the entire path of the resources.
    • Manual code folding is removed, but auto XML code folding is added.
    • A list of new keyboard shortcuts are available by accessing the menu item Help -> Editor Quick Help.

  • The visual presentation of the information displayed in the Execution Query Plan in TDV Studio has been improved for better readability.