Spotfire® System Requirements

Spotfire Connectors 7.8

This page lists system requirements for all connectors in TIBCO Spotfire® version 7.8.

System requirements for connectors in TIBCO Spotfire® 7.8

Table 1. TIBCO Spotfire® Connector for Amazon Redshift
Category Requirement
Data source
  • Amazon Redshift
Driver
  • Amazon Redshift ODBC Driver (recommended)
  • psqlODBC 9.x
Note: The Amazon Redshift ODBC Driver is included in TIBCO Spotfire Drivers (versions 1.0-1.2), which is available for download on the TIBCO eDelivery site.
Note: The driver must be installed on the computer running the data connector.
Authentication methods
  • Username and password (SSL)
SSL support Yes
Table 2. TIBCO Spotfire® Connector for Apache Spark SQL
Category Requirement
Data source
  • Apache Spark SQL 1.6.0 to 2.0.2 (if using a driver of version 1.2.0 or higher)
  • Apache Spark SQL 1.4.0 (if using a driver of version 1.0.8 or 1.1.1)
Note: Cloudera currently does not support Spark SQL.
Note: Hortonworks supports Spark SQL in HDP 2.3.4 and later.
Note: For a description of MapR's Spark SQL support, see the official MapR documentation here and here.
Note: Apache Spark SQL is included with IBM® Open Platform with Apache Hadoop (part of IBM BigInsights®).
Note: There are currently Kerberos reliability issues in the Spark Thrift server. The use of Kerberos with Apache Spark SQL is therefore not recommended.
Driver
  • Simba ODBC Driver for Apache Spark SQL, Version 1.0.8 or higher

The driver from Simba listed above is also available under the following brands:

  • TIBCO ODBC Driver for Apache Spark SQL, Version 1.0.8 or higher
Note: The TIBCO Spotfire ODBC Driver for Apache Spark SQL is included in TIBCO Drivers, which is available for download on the TIBCO eDelivery site.
  • TIBCO Drivers 1.3 contains Simba ODBC Driver for Apache Spark SQL, Version 1.2.0
  • TIBCO Drivers 1.2 contains Simba ODBC Driver for Apache Spark SQL, Version 1.1.1
  • TIBCO Drivers 1.1 contains Simba ODBC Driver for Apache Spark SQL, Version 1.0.8
  • TIBCO Drivers 1.0 contains Simba ODBC Driver for Apache Spark SQL, Version 1.0.8
Note: The driver must be installed on the computer running the data connector.
Authentication methods
  • Anonymous
  • Username
  • Kerberos
  • LDAP
Table 3. TIBCO Spotfire® Connector for Attivio
Category Requirement
Data source
  • TIBCO Spotfire® Data Catalog 5.2.6 or higher
  • Attivio 5.1.9 or higher
Driver
  • Postgres Unicode Driver
Note: The driver must be the version that is included in the distribution of TIBCO Spotfire® Data Catalog or Attivio Sematic Data Catalog, which you are connecting to.
Note: The driver must be installed on the computer running the data connector.
SSL Support

Yes

Note: If you are using Kerberos authentication with delegated credentials on your Spotfire Server, you cannot use this connector with TLS/SSL in Spotfire web clients. The ODBC driver provided by the database vendor expects to find TLS/SSL certificate information in user specific directories or Windows registry entries. None of these are available on the server when using Kerberos with delegated credentials.
Table 4. TIBCO Spotfire® Connector for Cloudera Hive
Category Requirement
Data source
  • Cloudera CDH4.x
  • Cloudera CDH5.x
  • Cloudera Hive on Spark, Tez or MapReduce (where applicable)
HiveServer
  • HiveServer2
Driver
  • Cloudera ODBC Driver for Apache Hive, Version 2.5.5 or higher
Note: The driver must be installed on the computer running the data connector.
Note: If you have installed the Cloudera ODBC Driver for Apache Hive, you can use the Hortonworks connector to connect to Cloudera Hive data sources. Try using the Hortonworks connector if you want to use Kerberos when connecting to Cloudera Hive.
Authentication methods
  • Anonymous
  • Username
  • Kerberos
  • LDAP
  • LDAP (SSL)
Table 5. TIBCO Spotfire® Connector for Cloudera Impala
Category Requirement
Data source
  • Any Impala version supported by the Hadoop distributions listed below. For more information on this, please refer to each distribution's link below.
Hadoop distribution
HiveServer HiveServer2
Driver
  • Cloudera Impala ODBC Driver, Version 2.5.30 or higher
Note: The driver must be installed on the computer running the data connector.
Authentication methods
  • Anonymous
  • Username
  • Kerberos
  • LDAP
  • LDAP (SSL)
Table 6. TIBCO Spotfire® Connector for Cisco Information Server
Category Requirement
Data source
  • Cisco ("Composite") Information Server 6.2.x, 7.0.x
  • TIBCO Spotfire Advanced Data Services 6.2.x, 7.0.x
Driver The required driver is included out-of-the-box in the Spotfire installation.
Table 7. TIBCO Spotfire® Connector for Google Analytics
Category Requirement
Data source
  • Google Analytics
Driver No driver is required to use this connector.
Authentication methods
  • OAuth 2.0
Table 8. TIBCO Spotfire® Connector for Hortonworks
Category Requirement
Data source
  • Hortonworks Data Platform (HDP) 2.1.x and later
  • Apache Hive on Spark, Tez or MapReduce (where applicable)
  • Apache Hive on Spark, Tez or MapReduce (where applicable) on MapR distributions
  • Apache Hive on Spark, Tez or MapReduce (where applicable) on IBM BigInsights®
Note: Hortonworks currently provides LLAP as a technical preview as part of HDP 2.5 with Hive 2.1.
HiveServer HiveServer2
Driver The following drivers are supported:
  • Hortonworks ODBC Driver for Apache Hive, version 2.1.5 or higher
  • Cloudera ODBC Driver for Apache Hive version 2.05.20 or higher
Note: The Spotfire Hortonworks connector can be used to connect to other Apache Hive data sources. Also, you can connect to Cloudera Hive with the Hortonworks connector, if the Cloudera ODBC Driver is installed.
Note: The driver must be installed on the computer running the data connector.
Authentication methods
  • No Authentication
  • Kerberos
  • Username
  • Username and Password
  • Username and Password (SSL)
Table 9. TIBCO Spotfire® Connector for HP Vertica
Category Requirement
Data source
  • HP Vertica 6.x, 7.x, 8.x
Driver
  • HP Vertica ADO.NET driver 6.x, 7.x, 8.x
Note: The driver must be installed on the computer running the data connector.
Table 10. TIBCO Spotfire® Connector for IBM DB2
Category Requirement
Data source
  • IBM DB2 LUW 9.x, 10.x (LUW = Linux, Unix, Windows)
Driver
  • IBM DB2 ODBC driver 10.5
Note: The driver must be installed on the computer running the data connector.
Table 11. TIBCO Spotfire® Connector for IBM Netezza
Category Requirement
Data source
  • IBM Netezza NPS 6, 7
Driver
  • IBM Netezza ODBC Driver version 7.0.0.x
Note: The driver must be installed on the computer running the data connector.
Table 12. TIBCO Spotfire® Connector for Microsoft SQL Server
Category Requirement
Data source

Supported data sources:

  • Microsoft Azure SQL
  • Microsoft Azure SQL Data Warehouse
  • Microsoft SQL Server 2016
  • Microsoft SQL Server 2014
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2008 R2
Driver

The required driver is included in Microsoft.NET - no need for a separate installation.

Table 13. TIBCO Spotfire® Connector for Microsoft SQL Server Analysis Services
Category Requirement
Data source

Supported data sources:

  • Microsoft SQL Server Analysis Services 2014 in Multidimensional or Tabular Mode
  • Microsoft SQL Server Analysis Services 2012 in Multidimensional or Tabular Mode
  • Microsoft SQL Server Analysis Services 2008 R2
Driver
Supported drivers:
  • Microsoft ADOMD.NET driver for SQL Server 2016*
  • Microsoft ADOMD.NET driver for SQL Server 2014
  • Microsoft ADOMD.NET driver for SQL Server 2012
  • Microsoft ADOMD.NET driver for SQL Server 2008 R2
Note: * Microsoft ADOMD.NET driver for SQL Server 2016 is supported from TIBCO Spotfire 7.8.0 hotfix HF-003.
Note: The driver must be installed on the computer running the data connector.
Table 14. TIBCO Spotfire® Connector for OData
Category Requirement
Data source
  • OData 1,2,3,4
Driver

No driver is required to use this connector.

Authentication methods
  • Anonymous
  • Username and Password (Basic)
  • Windows Authentication
  • Microsoft Azure Marketplace
SSL Support

Yes

Table 15. TIBCO Spotfire® Connector for Oracle
Category Requirement
Data source

Supported data sources:

  • Oracle 11gR1, 11gR2, 12c
  • Oracle Exadata X2 (11gR2, 12c)
Driver

Supported drivers:

  • ODAC (ODP.NET) 12c
  • ODAC (ODP.NET) 11.2.0.x (11.2.0.0 or higher)
Note: The driver must be installed on the computer running the data connector.
Table 16. TIBCO Spotfire® Connector for Oracle Essbase
Category Requirement
Data source
  • Oracle Essbase 9.3, 11.1
Driver
  • Oracle Enterprise Performance Management System Media Pack for Microsoft Windows x64, EPM System Release 11.1.2.4.0 or higher Client
Note: The driver must be installed on the computer running the data connector.
Table 17. TIBCO Spotfire® Connector for Oracle MySQL
Category Requirement
Data source
  • Oracle MySQL 5.1, 5.5, 5.6
Driver
  • Oracle MySQL Connector/Net 6.6.5 or higher
Note: The driver must be installed on the computer running the data connector.
Table 18. TIBCO Spotfire® Connector for Pivotal Greenplum
Category Requirement
Data source
  • Greenplum Database 4.1, 4.2, 4.3
  • HAWQ
Driver
  • PsqlODBC 9.x
  • DataDirect 7.1 Greenplum ODBC
Note: The driver must be installed on the computer running the data connector.
Table 19. TIBCO Spotfire® Connector for Pivotal HAWQ
Category Requirement
Data source
  • Pivotal HD 1.0.7
Driver
  • PsqlODBC 9.x
  • DataDirect 7.1 Greenplum ODBC
Note: The driver must be installed on the computer running the data connector.
Table 20. TIBCO Spotfire® Connector for PostgreSQL
Category Requirement
Data source
  • PostgreSQL 8.4, 9.0, 9.1, 9.2, 9.3, 9.4
Driver
  • psqlODBC 9.x
Note: The driver must be installed on the computer running the data connector.
SSL Support

Yes

Note: If you are using Kerberos authentication with delegated credentials on your Spotfire Server, you cannot use this connector with TLS/SSL in Spotfire web clients. The ODBC driver provided by the database vendor expects to find TLS/SSL certificate information in user specific directories or Windows registry entries. None of these are available on the server when using Kerberos with delegated credentials.
Table 21. TIBCO Spotfire® Connector for Salesforce
Category Requirement
Data source
  • Salesforce
Driver
  • TIBCO Spotfire ODBC driver for Salesforce.com 2.0.2.1002 or higher
Note: The TIBCO Spotfire ODBC Driver for Salesforce.com 2.0.2.1002 is included in TIBCO Drivers (version 1.3.0 and higher), which is available for download on the TIBCO eDelivery site. Cloud Workgroup users that need access to this driver can download it from the Spotfire Cloud site, on the Downloads page.
Note: The driver must be installed on the computer running the data connector.
Table 22. TIBCO Spotfire® Connector for SAP HANA
Category Requirement
Data source
  • SAP HANA SPS8 server or higher
  • AWS SAP HANA One
Driver
  • SAP HANA ODBC driver 1.00.60.x or higher
Note: The driver must be installed on the computer running the data connector.
Authentication methods
  • Username and Password
  • Kerberos
SSL Support

Yes

Note: If you are using Kerberos authentication with delegated credentials on your Spotfire Server, you cannot use this connector with TLS/SSL in Spotfire web clients. The ODBC driver provided by the database vendor expects to find TLS/SSL certificate information in user specific directories or Windows registry entries. None of these are available on the server when using Kerberos with delegated credentials.
Table 23. TIBCO Spotfire® Connector for SAP NetWeaver Business Warehouse (SAP BW)
Category Requirement
Data source
  • SAP NetWeaver Business Warehouse 7.01 SP10, 7.3, 7.4
Driver
  • SAP BW OLE DB for OLAP provider
Note: The driver must be installed on the computer running the data connector.
Table 24. TIBCO Spotfire® Connector for Teradata
Category Requirement
Data source
  • Teradata 13.x, 14.x, 15.x
Driver
  • .NET Data Provider for Teradata 13.x, 14.x, 15.x
Note: The driver must be installed on the computer running the data connector.
Note: The driver version must match the Teradata version you are using. For example, if your Teradata version is 14, then the driver version must also be 14.
Table 25. TIBCO Spotfire® Connector for Teradata Aster
Category Requirement
Data source
  • Teradata Aster 5.0, 5.11, 6.0
Driver
  • Aster ODBC Driver 6.0 or higher
Note: The driver must be installed on the computer running the data connector.
Note: Make sure you download the latest released version of the Aster ODBC driver (for example included in the Client Tools package provided by Teradata). Note that the driver is currently not available in each new version of the Client Tools package - if you encounter this issue, look for the driver in a previous version.
Copyright © Cloud Software Group, Inc. All rights reserved.