Select Data Source Adapter field | TDV Support | Versions, Compatibility, and Notes |
Apache Drill | Active | CAST AS functions are not supported. |
Amazon AWS S3 | Active | |
Azure Data Lake Storage | Active | |
Composite | Active | |
ComputeDB | Active | Version 1.2 |
Custom Java Procedure | Active | |
DB2 V10.5 (Type4) | Active | |
DB2 z/OS Version 10 (Type 4) | Active | |
DB2 z/OS Version 11 | Active | |
Data Direct Mainframe | Active | The Shadow RTE Server (version 6.1.4.7606 or later) must be installed on the DataDirect Mainframe computer and the Shadow RTE Client (version 6.1.1.1080 or later) must be installed locally on the computer hosting the TDV Server. |
File (cache, delimited, and XML) | Active | For data sources that access a file share, the TDV service user account needs to have permission to read the file share. |
Greenplum 3.3 | Active | TDV capabilities with Greenplum have been developed and tested with a single node license. |
Greenplum 4.1 | Active | |
Greenplum 4.3 | Active | |
HBase 0.98 (Apache Phoenix Driver) | Active | Introspection of HBase databases retrieves information from the system tables. User created tables are only introspected if they have been created using the Apache Phoenix shell. Requires installation of Apache Phoenix JDBC drivers, specifically those in phoenix-4.1.0-bin.tar.gz. For more information see the TDV Administration Guide. |
HSQLDB 2.2.9 | Active | |
Hive 2.1.1 | Active | Kerberos is supported. Trusted Delegation is not supported. For Hive data sources, TDV introspects tables and columns only. |
Impala 2.x | Active | |
Informix 9.x | Active | |
Local File Storage | Active | |
LDAP | Active | v3 |
Microsoft Access | Active | Windows platforms only |
Microsoft Access (non-ODBC) | Active | Windows platforms only |
Microsoft Excel | Active | 2000 |
Microsoft Excel (non-ODBC) | Active | 2000 |
Microsoft SQL Server 2008 | Active | Kerberos authentication is supported. |
Microsoft SQL Server 2012 | Active | Kerberos authentication is supported with the 2008 driver. |
Microsoft SQL Server 2014 | Active | Kerberos authentication is supported. |
Microsoft SQL Server 2016 | Active | Kerberos authentication is supported. |
Microsoft SQL Server 2019 | Active | Kerberos authentication is supported. |
MySQL 5.1 | Active | |
MySQL 5.5 | Active | |
MySQL 8.0.23 | Active | Use MySQL5.5 adapter to connect to Mysql8.0.X databases. |
Neoview 2.3 | Active | |
Neoview 2.4 | Active | |
Netezza 6.0 | Active | NPS |
Netezza 7.0 | Active | NPS |
OData | Active | Provides for some limited access to SharePoint data. |
Oracle 11g (OCI Driver) | Active | 11g R1, 11g R2, Oracle RAC Kerberos authentication is supported with thin driver version 11.2.0.4. |
Oracle 11g (Thin Driver) | Active | 11g R1, 11g R2, Oracle RAC Kerberos authentication is supported with thin driver version 11.2.0.4. |
Oracle 12c (OCI Driver) | Active | Oracle RAC |
Oracle 12c (Thin Driver) | Active | Oracle RAC |
Oracle 19c (OCI Driver) | Active | |
Oracle 19c (Thin Driver) | Active | |
PostgreSQL 9.0 | Active | |
PostgreSQL 9.1 | Active | |
PostgreSQL 9.2.3 | Active | |
REST | Active | Kerberos authentication is supported. NTLM authentication is supported. |
RSS | Active | |
Redshift | Read-only | New datasources cannot be created. The following trigonometric functions should not be pushed to Redshift data sources, because they might return incorrect results: SIN, COS, TAN, ASIN, ACOS, COT. |
SOAP | Active | 1.1, 1.2 Kerberos authentication is supported. NTLM authentication is supported. |
SAP HANA SPS 09 | Active | Support is for on premise SAP HANA deployments. |
Sybase 12 | Active | 12.5 ASE |
Sybase 15 | Active | 15 and 15.5 ASE Kerberos authentication is supported. |
Sybase IQ | Active | 15 |
Sybase IQ (Type 2) | Active | 15.2 |
Teradata 13 | Active | 13 and 13.10 Support for query band. |
Teradata 14 | Active | 14.10 Might require installation of a Teradata 15 driver. Support for query band. |
Teradata 15 | Active | FastExport is not supported. The JDBC driver does not support CLOB columns with NULL values when using TDV to cache data into a Teradata 15 target. Support for query band. |
Teradata 16 | Active | 16.20 The JDBC driver does not support CLOB columns with NULL values when using TDV to cache data into a Teradata 16 target. Support for query band. |
TIBCO Streaming | Active | 10.6.1 |
Vertica 6.1 | Active | |
WSDL | Active | 1.1 Kerberos authentication is supported. NTLM authentication is supported. |
XML/HTTP | Active | Flat files or over HTTP. Kerberos authentication is supported. NTLM authentication is supported. |