List of Connectors in this Version


The following connectors are included in the current version of Spotfire.

Note: As a Spotfire administrator, you must allow access to a connector for the user groups that will use that connector. See the Spotfire Server Installation and Administration Help and the Spotfire Administration Manager User's Guide for more information on configuring access to connectors.

Connector name

Click link to view help.

Data source driver required

Click link to see system requirements.

Link to driver download

(when available)

Amazon Redshift

Yes

Download links for the latest Amazon Redshift ODBC drivers (32-bit and 64-bit) are available on this page:

http://docs.aws.amazon.com/redshift/latest/mgmt/install-odbc-driver-windows.html

Apache Spark SQL

Yes

Included in the TIBCO Drivers product.

Attivio

Yes

Driver can be downloaded from https://explore.attivio.com, if you have an Attivio DSD account. See Loading Data from explore.attivio.com for more information.

Cloudera Hive

Yes

http://www.cloudera.com/downloads/connectors/hive/odbc/2-5-20.html

Cloudera Impala

Yes

http://www.cloudera.com/downloads/connectors/impala/odbc/2-5-34.html

Google Analytics

No

No driver installation required.

Hortonworks

Yes

Download the driver from Hortonworks:

http://hortonworks.com/downloads/

Locate the Hortonworks ODBC Driver for Apache Hive (scroll down the page to the section Hortonworks Data Platform Add-Ons). Make sure you select the right version of the driver for your operating system (32-bit or 64-bit).

HP Vertica

Yes

The driver can be downloaded by registered users from this page:  https://my.vertica.com

IBM DB2

Yes

The driver can be downloaded by registered users from this page:

https://www-01.ibm.com/marketing/iwm/iwm/web/preLogin.do?source=swg-idsoc97

IBM Netezza

Yes

The ODBC driver for IBM Netezza must be obtained through IBM. Make sure the correct version (32-bit or 64-bit) is installed on your system.

Microsoft SQL Server

No

The driver is included in Microsoft.NET, so there is no need for a separate installation.

Microsoft SQL Server Analysis Services

Yes

Install the ADOMD.NET driver, available for download from Microsoft, as part of the feature pack for your version of Analysis Services:

SQL Analysis Services 2008

SQL Analysis Services 2012

SQL Analysis Services 2016

Click Download to choose individual files in the package. Locate and download the file SQL_AS_ADOMD.msi or SQLSERVER2008_ASADOMD10.msi (depending on the SSAS version) for your operating system bitness (x32 or x64).

OData

No

No driver installation required.

Oracle

Yes

Click http://www.oracle.com/technetwork/topics/dotnet/downloads/index.html to download the driver for 32-bit and 64-bit ODAC respectively.

Oracle Essbase

Yes

To use the Oracle Essbase connector, you must install version 11.1.2.4.0 of Essbase Client, which is included in Oracle Enterprise Performance Management System version 11.1.2.4.0.

Log in with your Oracle account on Oracle Software Delivery Cloud and download Oracle Enterprise Performance Management System Client Installers 11.1.2.4.0, for Microsoft Windows x64 (64-bit).

When you install Essbase Client, make sure that both Essbase Client and Essbase Client C API are installed.

You must set the following system variables on your computer (create new variables if the variables do not already exist):

EPMHOME to the home path for Oracle Enterprise Management System. (Example: C:\oracle\Middleware\EPMSystem11R1\)

ARBORPATH to the path you specified during the installation of Essbase Client. (Example: %EPMHOME%\products\Essbase\EssbaseClient\)

ESSBASEPATH to the following value: %ARBORPATH%

PATH must include the following value: %ARBORPATH%\bin;%EPMHOME%\bin

Oracle MySQL

Yes

http://dev.mysql.com/downloads/connector/net

Pivotal Greenplum

Yes

http://www.postgresql.org/ftp/odbc/versions/msi/

Pivotal HAWQ

Yes

http://www.postgresql.org/ftp/odbc/versions/msi/

PostgreSQL

Yes

http://www.postgresql.org/ftp/odbc/versions/msi/

Salesforce.com

Yes

Included in the TIBCO Drivers product.

SAP BW

Yes

The Spotfire connector for SAP BW supports the following data source drivers, which are available in the Download Software area of the SAP Support Portal:

  • SAP NetWeaver RFC SDK (BAPI driver)

  • SAP BW OLE DB for OLAP provider (ODBO driver)

For more information and instructions for installing the required drivers, see Installing Drivers for the SAP BW Connector.

SAP HANA

Yes

The ODBC driver for SAP HANA must be obtained through SAP.
Note: 64-bit versions only.

Teradata

Yes

https://downloads.teradata.com/download/connectivity/net-data-provider-for-teradata

Teradata Aster

Yes

http://downloads.teradata.com/download/aster/aster-client-tools-for-windows

Note: Make sure you download the latest released version of the Aster ODBC driver (e.g., included in the "Client Tools" package provided by Teradata). However, the driver is currently not available in each new version of the "Client Tools" package; if you encounter this issue, look for it in a previous version.

TIBCO Data Virtualization

(formerly Cisco Information Server/Spotfire Advanced Data Services)

No

No driver installation required.

See also:

Getting Started with Connectors

What is a Data Connection?

What is a Connection Data Source?