This newsletter is aimed at TIBCO Data Virtualization administrators and users who will benefit from news of the latest releases, hotfixes, knowledge base articles and technical tips.
In response to the rapid increase of coronavirus (COVID-19), TIBCO has published a statement on the steps we are taking to ensure the welfare of our employees, customers, and partners. In addition, TIBCO Support has an FAQ on the crisis (customer login required):
Review the end of support dates below and plan upgrades to supported versions so you benefit from security updates, defect corrections, and features available in the latest releases.
TIBCO Data Virtualization version 8.3 is the latest release in the 8.x series that addresses performance/scalability and various data source updates. Check the release notes for a list of new features, and changes in functionality. Download the TIBCO Data Virtualization suite from TIBCO eDelivery.
Below are some of the new features and improvements in 8.3.
A Data Streams adapter for accessing 80+ streaming sources and blending the snapshot data from multiple streaming sources (or, blending it with data coming from other sources).
Adapters for MarkLogic, Splunk, CosmosDB, Oracle 19c, and SQLServer 2019, and Teradata 16.20
Dockerfile, for building a Docker based container image for TDV deployments.
New REST and Domain Specific APIs to manage the full lifecycle of TDV resources
TDV automatically generates Swagger based documentation based on OAS 3.0 for all REST based published web services. The specifications can be accessed from the Studio through the menu item Help >> Published REST Web Services.
The documentation is available in HTML format, providing a much easier and searchable way to find individual product features and more.
TIBCO Data Virtualization version 7.0.9 is also available for download from TIBCO eDelivery. The release notes list Fixed and Known issues.
Recent Security Advisories:
All TIBCO security advisories can be accessed from the Security Advisories for TIBCO Products web page.
We recommend that you always keep your TIBCO Data Virtualization environment up-to-date with the latest hotfixes. Hotfixes can be downloaded from the TIBCO Support Portal at https://support.tibco.com. After log in, pull down the Downloads menu to Hotfixes. On the Hotfixes page, click on "AvailableDownloads" > DataVirtualization. The list of issues and fixes are in the Readme file in the zip file of the hotfix.
Note: Service Packs can be downloaded from TIBCO eDelivery site
Data Virtualization Studio
How to log in into TIBCO Data Virtualization Studio without entering a username and password each time
How to enable DEBUG logging for TIBCO Data Virtualization Studio?
Data Virtualization Server
How many cpu cores is TIBCO Data Virtualization server using, and can the number be configured?
When a request to a TIBCO Data Virtualization web service takes more than 60 seconds to return data, it fails with a SocketTimeoutException
TIBCO Data Virtualization Studio throws "Cause: java.lang.NullPointerException" error when querying data from MS SQL 2014 adapter.
Using Microsoft SQLServer 'NVL2' function in TIBCO Data Virtualization results in an error
How do you analyze the execution of a query (to find out which operations could be slowing the execution)?
If the query is not already saved as a view, save it as a view in TDV Studio.
Open the view. Click on Show Execution Plan in the top menu bar, then click on the Execute and Show Statistics button that appears at the bottom of the panel.
Save the plan as a text file.
Open the text file using a text editor (e.g. Notepad++). Review the time taken by each node.
The following screenshot shows the steps:
How to prevent cache refresh issues from resulting due to running two TDV servers in Parallel?
Sometimes, it is helpful to run parallel TDV servers. For instance, when installing a new TDV server the existing TDV server can be kept running until the new server is up. This is helpful to users as they can continue to use the existing server without experiencing a break in service.
Having parallel TDV servers could result in issues with cache refreshes, as both servers may try to refresh the same cache at the same time. To prevent this from happening, you can disable cache refreshes on the existing server using the Disable Cache Refreshes configuration setting. The setting may be accessed by opening TDV Studio, connecting to the existing TDV server, and navigating to Administration > Configuration > Server > Configuration > Debugging > Disable Cache Refreshes as shown below.
We have a few Quick Tip YouTube videos and content on the TIBCO LinkedIn group to help with extended topics and unique analytics challenges. Please subscribe and follow us on YouTube and LinkedIn to stay updated. We also provide interactive technical events, educational YouTube videos, and other great content on TIBCO Community.
TIBCO Support routinely conducts surveys to evaluate customer satisfaction. You are invited via email to complete an online survey about cases you have logged. You can also submit a survey at any point during the case lifecycle. Thanks to everyone who submitted feedback. We use it to improve our service.
Review Support Customer Satisfaction survey results.
Sign up for upcoming Data Virtualization Discovery events
More TIBCO events: Events
Learn how to subscribe to notifications, release announcements, hotfixes, knowledge base articles, retirement notices, and more.
TIBCO Software Inc.
3307 Hillview Ave. Palo Alto, CA USA 9430