Supported Data Sources - trillium_discovery - trillium_quality - 17.1

Trillium DQ Repository Administrator Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium DQ Repository Administrator Guide
Topic type
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2008

The table given below lists the supported databases (and, in some cases, data warehouses) and their corresponding Trillium ODBC drivers.

Table 1. Supported Data Sources for TSS ODBC (Trillium-Supplied) Loader Connections
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.6

Yellowbrick 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.