The table given below lists the supported databases (and, in some cases, data warehouses) and their corresponding Trillium ODBC drivers.
Database | Version | Platform | Bit | TSS ODBC Driver |
---|---|---|---|---|
Amazon Redshift |
- |
Windows Linux |
64-bit |
TSS 17 Amazon Redshift Wire Protocol Driver |
Apache Cassandra |
3.7 2.0, 2.1, 2.2 |
Windows Linux |
64-bit |
TSS 17 Apache Cassandra Driver |
Apache Hive |
See Apache Hadoop Hive Distribution Support for Linux and Windows |
Windows Linux |
64-bit |
TSS 17 Apache Hive Wire Protocol Driver |
Apache Spark SQL |
3.0* 2.0*, 2.2* 1.2, 1.3, 1.4*, 1.5* |
Windows Linux |
64-bit |
TSS 17 Apache Spark SQL Driver |
Cloudera Impala Server |
3.2* 2.0*, 2.1*, 2.2*, 2.3*, 2.4*, 2.5*, 2.6* 1.0*, 1.1*, 1.2*, 1.3*, 1.4* |
Windows Linux
|
64-bit |
TSS 17 Impala Wire Protocol Driver |
DataStax Enterprise | 5.0 4.7, 4.8 |
Windows Linux |
64-bit |
TSS 17 Apache Cassandra Driver |
dBase File (*.dbf) | - | Linux | 64-bit | TSS 17 dBASE File Driver |
Google Analytics |
API Version 3 |
Windows Linux |
64-bit |
TSS 17 Google Analytics Driver |
Google BigQuery | - |
Windows Linux |
64-bit |
TSS 17 Google BigQuery Driver |
Greenplum |
6.0* 5*, 5.1*, 5.2*, 5.3*, 5.4*, 5.5* 4, 4.1, 4.2, 4.3 3.3 |
Windows Linux
|
64-bit |
TSS 17 Greenplum Wire Protocol Driver |
IBM Db2 |
Db2 11.1, 11.5 |
Windows Linux (for all) |
64-bit (for all) |
TSS 17 DB2 Wire Protocol Driver |
Db2 12 for z/OS | ||||
Db2 i 7.3 (DB2 V7R3 for iSeries) | ||||
Db2 Hosted | ||||
Db2 Warehouse on Cloud (formerly dashDB) | ||||
Informix |
14.1 12.1 |
Windows Linux |
64-bit |
TSS 17 Informix Driver |
Microsoft Analytics Platform System |
10.00 |
Windows Linux |
64-bit |
TSS 17 SQL Server Wire Protocol Driver |
Microsoft Azure Synapse Analytics |
12.00 |
Windows Linux |
64-bit |
TSS 17 SQL Server Wire Protocol Driver |
Microsoft Dynamics 365 CRM apps | Customer Service, Field Service, Marketing, Project Service Automation, Sales |
Windows Linux |
64-bit |
TSS 17 Microsoft Dynamics 365 Driver |
Microsoft Dynamics 365 ERP apps | Finance, Retail, Supply Chain Management, Talent |
Windows Linux |
64-bit |
TSS 17 Microsoft Dynamics 365 Driver |
Microsoft SharePoint Online Lists | - |
Windows Linux |
64-bit | TSS 17 Microsoft SharePoint Driver |
Microsoft SQL Server |
2019 2017 2016 2014 2012 2008 R1, R2 2005 2000 Desktop Engine (MSDE 2000) 2000 |
Windows Linux |
64-bit
|
TSS 17 SQL Server Wire Protocol Driver |
Microsoft SQL Server | 2016 2014 2012 2008 R1, R2 2005 2000 Desktop Engine (MSDE 2000) 2000 MS SQL Server 7.0 |
Windows Linux |
64-bit |
TSS 17 SQL Server Legacy Wire Protocol Driver |
Microsoft Windows Azure for SQL Database | 12.0 11.0 |
Windows Linux |
64-bit |
TSS 17 SQL Server Wire Protocol Driver |
MongoDB |
5.0 4.0, 4.2, 4.4 3.6 |
Windows Linux |
64-bit |
TSS 17 MongoDB Driver |
MySQL Enterprise Edition |
8.0 5.0, 5.1, 5.5, 5.6 |
Windows Linux |
64-bit |
TSS 17 MySQL Driver |
Oracle |
Oracle 21c R1* (21.1*) Oracle 19c R1* (19.1*) Oracle 18c R1*, R3* (18.1*, 18.3*) Oracle 12c R1*, R2* (12.1*, 12.2*) Oracle 11g R1, R2 (11.1, 11.2) Oracle 10g R1, R2 (10.1, 10.2) Oracle9i R1, R2 (9.0.1, 9.2) Oracle8i R3 (8.1.7)
Oracle Autonomous Data Warehouse Cloud 12c R2* (12.2*)
Oracle Autonomous Transaction Processing Cloud 19c R1* (19.1*)
Oracle Database Cloud Service 18c R1* (18.1*) |
Windows Linux |
64-bit |
TSS 17 Oracle Wire Protocol |
Oracle Client |
Oracle 19c R1* (19.1*) Oracle 18c R1*, R3* (18.1*, 18.3*) Oracle 12c R1*, R2* (12.1*, 12.2*) Oracle 11g R1, R2 (11.1, 11.2) Oracle 10g R1, R2 (10.1, 10.2) Oracle9i R1, R2 (9.0.1, 9.2) Oracle8i R3 (8.1.7) |
Windows Linux |
64-bit |
TSS 17 Oracle Client Wire Protocol Driver |
Oracle Service Cloud |
Oracle Service Cloud (Oracle RightNow CX API version 1.4) 19D*, 20B* Oracle Service Cloud (Oracle RightNow CX API version 1.2) February 2014, May 2014, August 2014, May 2015, May 2016* |
Windows Linux |
64-bit |
TSS 17 Oracle Service Cloud Driver |
Pivotal HAWQ |
1.1*, 1.2* |
Windows Linux |
64-bit |
TSS 17 Greenplum Wire Protocol Driver |
Pivotal HDB (HAWQ) |
2.0* |
Windows Linux |
64-bit |
TSS 17 Greenplum Wire Protocol Driver |
PostgreSQL |
Amazon Aurora PostgreSQL 1.0* EDB Postgres Advanced Server 10.1* PostgreSQL 14.0 PostgreSQL 13.0 PostgreSQL 12.0 PostgreSQL 11.0 PostgreSQL 10.1 PostgreSQL 9.6Yellowbrick Data Warehouse |
Windows Linux
|
64-bit |
TSS 17 PostgreSQL Wire Protocol Driver |
Progress OpenEdge |
12.0* 11.0, 11.1*, 11.2*, 11.3*, 11.4*, 11.5*, 11.6*, 11.7* 10.1.x, 10.2.x |
Windows Linux |
64-bit |
TSS 17 OpenEdge Wire Protocol Driver |
REST API | CSV, JSON, XML |
Windows Linux |
64-bit | TSS 17 Autonomous REST Connector Driver |
Salesforce |
API Version 49 |
Windows Linux |
64-bit |
TSS 17 Salesforce Driver |
SAP Adaptive Server Enterprise |
SAP Adaptive Server Enterprise 16.0* Adaptive Server Enterprise 15.0, 15.5, 15.7 Adaptive Server Enterprise 12.0, 12.5, 12.5.x Adaptive Server Enterprise 11.9 |
Windows Linux |
64-bit |
TSS 17 Sybase Wire Protocol Driver |
SAP S/4HANA | SAP BW/4HANA 2.0 SAP S/4HANA Cloud 2005 SAP ODataV2 Services through SAP NetWeaver Gateway |
Windows Linux |
64-bit | TSS 17 SAP S4HANA Driver |
Snowflake |
- |
Windows Linux |
64-bit |
TSS 17 Snowflake Driver |
Sybase IQ |
SAP IQ 16.0, 16.1 Sybase IQ 15.0, 15.1, 15.2, 15.3, 15.4 |
Windows Linux |
64-bit |
TSS 17 Sybase IQ Wire Protocol Driver |
Teradata |
17.10* 16.10*, 16.20* 15.00*, 15.10* 14.00, 14.10* 13.0, 13.1 12.0 V2R6.0, V2R6.1, V2R6.2 |
Windows Linux |
64-bit |
TSS 17 Teradata Driver |
Note the following guidelines:
- * Support added in a patch or Service Pack.
-
Teradata databases require the database client to be installed on the same system
-
All supported TSS ODBC drivers are installed with the Repository Manager.