The ODBC data connection allows you to directly connect to an external database (and, in some cases, data warehouse) without installing any external component. For example, using the ODBC data connection, you can read from an Oracle database without the Oracle client.
- For the ODBC connection, drivers are installed with the TSS server software. For ODBC (Vendor) connections, you use the drivers supplied by the database vendors.
- You can create a connection to access data sources residing in 64-bit databases.depending on the data source and operating system you are using.
- The ODBC data connection can be configured on Windows and Linux systems. The ODBC data connection does not require a port. It uses the same port as the TSS server and is installed as part of the server installation.
- Before using the ODBC data connection, configure a Data Source Name (DSN) with information about the specific database you want the connection to point to. You will be prompted for the DSN name when you add an ODBC data connection to the repository. For more information, see the Trillium Repository Administrator's Guide.
- Teradata databases require the database client to be installed on the same system.
- Supported Data Sources for ODBC Data Connections
-
The following table lists the supported data sources and their corresponding TSS ODBC drivers:
Data Source Version Platform Bit ODBC Driver Aha! Linux 64-bit TSS 17 Aha Driver Amazon Aurora V10.0 Linux 64-bit TSS 17 PostgreSQL Amazon Redshift - Linux 64-bit TSS 17 Redshift Driver IBM Db2 Db2 V11.1, V11.5 Linux 64-bit TSS 17 DB/2 Driver Db2 V10.1, V10.5 Linux 64-bit
Db2 V9.1, V9.5, V9.7, V9.8 Linux 64-bit
Db2 8.x Linux 64-bit
Db2 Hosted Linux 64-bit
Db2 Warehouse on Cloud (formerly dashDB) Linux 64-bit
Greenplum Greenplum 6.0
Greenplum 5, 5.1, 5.2, 5.3, 5.4, 5.5
Greenplum version 4.0, 4.1, 4.2, 4.3
Greenplum version 3.3
Linux 64-bit TSS 17 Greenplum Driver Pivotal HDB (HAWQ) V2.0 Linux 64-bit TSS 17 Greenplum Driver Pivotal HAWQ V1.1, 1.2 Linux 64-bit TSS 17 Greenplum Driver Apache Cassandra 3.7
2.0, 2.1, 2.2
Data Stax Enterprise 5.0
Data Stax Enterprise 4.7, 4.8
Linux 64-bit TSS 17 Apache Cassandra Driver Apache Hive See Apache Hadoop Hive Distribution Support Linux 64-bit
TSS 17 Hadoop Hive Driver Apache Spark SQL 3.0
2.0, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6
1.0, 1.1, 1.2, 1.3, 1.4
Linux 64-bit TSS 17 Apache Spark Driver Ā IBM Informix Informix Dynamic Server 14.1, 12.1 11.0, 11.5, 11.7 10.0 9.2, 9.3, 9.4 Linux 64-bit
TSS 17 Informix Driver Impala Cloudera Impala 3.2
Cloudera Impala 2.0, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6
Cloudera Impala 1.0, 1.1, 1.2, 1.3, 1.4
Linux 64-bit
TSS 17 Impala Wire Protocol Driver MySQL MySQL Enterprise Edition 8.0
MySQL Enterprise Edition 5.0.x server, 5.1 server, 5.5 server, 5.6
Linux 64-bit
TSS 17 MySQL Driver GitHUb Github Enterprise using Github REST API v3 Github Enterprise Cloud using Github REST API v3 Linux 64-bit TSS 17 GitHub Driver Google Google Analytics API Version 3 Big Query Linux 64-bit TSS 17 Google Analytics HubSpot API Version 3
Version 2
Linux 64-bit TSS 17 HubSpot Driver
Oracle12c R1 (12.1, 12.2)
11g R1, R2 (11.1, 11.2)
10g R1, R2 (10.1, 10.2)
Oracle Service Cloud (Oracle RightNow CX API version 1.2)
19c R1 (19.1) and later
18c R1 (18.1) and later
18c R3 (18.3) and later
12c R1 (12.1) and later
12c R2 (12.2) and later
11g R1 (11.1) and later
11g R2 (11.2) and later
10g R1 (10.1) and later
10g R2 (10.2) and later
9i R1 (9.0.1) and later
9i R2 (9.2) and later
8i R3 (8.1.7) and later
Oracle Autonomous Data Warehouse Cloud 12c R2 (12.2) and later
Oracle Autonomous Transaction Processing Cloud 19c R1 (19.1)
Oracle Database Cloud Exadata Service
Oracle Database Cloud Service 18c R1 (18.1)
Oracle Service Cloud (Oracle RightNow CX API version 1.4) 19D, 20B
Oracle Service Cloud (Oracle RightNow CX API version 1.2)
Linux
64-bit
TSS 17 Oracle Driver PostgreSQL 13.0
12.0
11.0
10.1
9.0, 9.1, 9.2, 9.3, 9.4, 9.5, 9.6
8.2, 8.3, 8.4
Linux 64-bit TSS 17 PostgreSQL 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
Linux 64-bit TSS 17 Progress OpenEdge Wire Protocol Driver Salesforce
Salesforce API version 49 Linux 64-bit
TSS 17 Salesforce Driver Snowflake
Minimum version: 2.20.5
Recommended version: 2.21.2 or later
Linux 64-bit TSS 17 Snowflake SAP Adaptive Server Enterprise V16.0 V15.0, 15.5, 15.7 V12.0, 12.5, 12.5.x V11.9 Linux 64-bit TSS 17 SAP Driver SAP IQ V16.0, 16.1 V15.0, 15.1, 15.2, 15.3, 15.4 Linux 64-bit TSS 17 SAP Driver TeamCity Community V2018.1 Enterprise V2018.1 Linux 64-bit TSS 17 TeamCity Driver Microsoft SQL Server On Premise: Microsoft Analytics Platform System 10.00 and later
Microsoft SQL Server 2016 and later
Microsoft SQL Server 2014 and later
Microsoft SQL Server 2012 and later
Microsoft SQL Server 2008 and later
Microsoft SQL Server 2005 and later
Microsoft SQL Server 2000 and later
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
Cloud:
Microsoft Azure SQL Data Warehouse 12.0 and later
Microsoft Windows Azure SQL Database 12.0 and later
Microsoft Windows Azure SQL Database 11.0 and later
7.0, 2000, 2000 Desktop Engine (MSDE 2000), 2005, 2008 R1 / R2, 2012, 2014, 2016, 2017
Linux 64-bit TSS 17 SQL Server Driver Microsoft Analytics Platform System Microsoft Analytics Platform System 10.00
Microsoft Azure SQL Data Warehouse 12.00
Linux 64-bit TSS 17 Microsoft Analytics Driver Microsoft Azure Synapse Analytics Microsoft Azure SQL Data Warehouse 12.00
Linux
64-bit
TSS 17 Microsoft Azure Synapse Driver Mongo DB V4.0, 4.2, 4.4
V3.0, 3.2, 3.4
V2.2, 2.4, 2.6
Linux 64-bit TSS 17 MongoDB Driver Sybase SAP Adaptive Server Enterprise 16.0
Sybase Adaptive Server Enterprise 15,15.5, and 15.7
Sybase Adaptive Server Enterprise 12.0, 12.5, and 12.5.x
Sybase Adaptive Server Enterprise 11.9
Linux 64-bit
TSS 17 Sybase Driver Sybase IQ SAP IQ 16.0, 16.1
Sybase IQ Server 15.0, 15.1, 15.2, 15.3, 15.4
Linux 64-bit
TSS 17 Sybase IQ Wire Protocol Driver Teradata 12.0, 13.0, 13.1, 4.00, 14.10, 15.00, 15.10, 16.10, 16.20V2R6.0, V2R6.1, V2R6.2 Linux 64-bit
TSS 17 Teradata Driver