TDV Drivers

This page lists system requirements for TIBCO® Data Virtualization Server version 8.8.

Hardware

TDV performance depends on processor speeds, available memory, network bandwidth, data source response times, query join types, the complexity of views, and many other implementation factors. Fast response times and support for a large active user base and large loads are achieved with:

Fast multi-core CPUs
Large amounts of RAM
Ample disk space
GB Ethernet network connections on the same subnet as the most heavily trafficked data source

If hardware configurations are less than optimal, TDV functions equally well, although more slowly, for most development tasks. Given below are the minimum hardware requirements.

Processor

Minimum: 2 CPUs/cores

Recommended: 8 CPUs/cores

RAM

Minimum: 8 GB memory

Recommended: 32 GB memory

Hard Disk Space

Minimum: 8 GB read/write, persistent storage.

  • 2.0 GB for TDV installation

  • 1.0 GB for the TDV repository database

  • 5.0 GB for future growth (e.g. default TDV temp directory, TDV VCS data, logs, file cached data, and future TDV patch/Java/repository software updates)

Recommended: 32 GB of readable/writable persistent storage

For details about different TDV deployments, please refer to Sizing Guidelines for TDV.

TDV Server Software

Refer to TDV Server for the TDV Server Requirements.

Drivers

ODBC
  • iODBC Driver Manager v3.52.12 for AIX and Linux

  • DataDirect Driver Manager v8.0 - DataDirect Driver Manager is supported on Linux and AIX platforms. There is no extra configuration needed for using TDV ODBC driver with DataDirect Driver Manager.

  • unixODBC Driver Manager(v2.3.1) - unixODBC Driver Manager is supported on Linux and AIX platforms. For using TDV ODBC driver with the unixODBC Driver Manager, set the environment variable TDV_ODBC_UODBC to TRUE for the applications that use TDV ODBC Driver.

set TDV_ODBC_UODBC=TRUE
  • Windows Driver Manager - The Windows Driver Manager is part of your Windows Operating System. Refer to the section Operating System Support for Server in the TDVInstallation and Upgrade Guide for a list of supported OS.

JDBC
  • JRE v11 and conforms to JDBC API 4.0

  • JRE v1.8 and conforms to JDBC API 4.0

  • JRE v17 and conforms to JDBC API 4.0

Example: If you are running a client using JRE 8(also known as 1.8), you would include csjdbc.jar in the CLASSPATH as shown below:

"C:\Program Files\Java\jdk1.8.0_211\bin\java" -classpath .;.\csjdbc.jar Test

ADO .Net

ADO .Net Driver Support

  • ADO.NET (32-bit and 64-bit)

Client-Side ADO.NET Driver Support

The TDV ADO.NET driver can be installed, uninstalled, or re-installed. It is delivered as a DLL and .NuGet package. It supports native ADO.NET driver functionality on the operating systems supported by .Net Standard 2.0.

Refer the following link for a list of OS and .Net versions supported by .Net Standard 2.0:

https://dotnet.microsoft.com/en-us/platform/dotnet-standard

TDV supports communication and use with Visual Studio version 2019 that the tool extension supports. You will need to install the extension by executing the following file:

TDV_INSTALL_DIR\ADO.NET Driver\Composite.VisualStudio.vsix

The SKUs supported by the Visual Studio Extension are Community, Professional and Enterprise. The Extension essentially has a Provider for DDEX(Data Designer Extensibility). Refer the following link for further details:

https://docs.microsoft.com/en-us/previous-versions/bb163760(v=vs.140)

Client Application Target Framework

.NET Standard 2.0

Refer to the following link for a list of .Net Framework versions supported by .Net Standard 2.0:

https://dotnet.microsoft.com/en-us/platform/dotnet-standard

ADO.Net Data Provider with Entity Framework support ADO.Net 2022 Data Provider - v20.0.7656
Power BI

The Power BI Connector for TIBCO(R) Data Virtualization is built on top of an ODBC driver.

TDV supports version 20.0.7656

TDV Installation prompts you to install Microsoft Visual C++ Redistributable for Visual Studio 2017, if it is not already installed. Proceed with the installation. This is needed to connect to the Powe BI Connector.

SSIS

The TIBCO SSIS Components for TIBCO(R) Data Virtualization supports Visual Studio versions 2012 and above.

TDV Supports  SSIS version 20.0.7668

Authentication Methods
  • Composite (Default)

  • NTLM

  • Kerberos

  • OAuth

Client Applications

JDBC Driver:

  • Cognos 11 R3

  • Cognos v10.2.2 fixpack 5

ODBC Driver:

  • MicroStrategy 9.0.2 - Data sources supported are : Oracle 10g or 11g, Netezza 5 or 6, SQL Server 2008, and for mixed data coming from Oracle 11g and Netezza 6.

  • MicroStrategy 9.2.1/9.2.1m on Windows I-Server - Because MicroStrategy can create and delete data directly, you must have used Studio and configured one of the following as a temporary tablespace to hold the created and deleted data: Oracle 10g and 11g, Netezza 5 and 6, SQL Server 2008, Teradata 13, MySQL 5, and DB2 v9.

  • Tableau Desktop Professional Edition Version 7.0.13

ADO.Net Driver:

  • TIBCO Spotfire

Note: All other client applications are supported through the standard communication protocols that include JDBC and ODBC.