TIBCO Spotfire® Database Drivers
Last updated:
8:50am Jul 06, 2017

To enable TIBCO Spotfire® data connectors, download and install drivers listed here.

Often the latest driver version is supported but there are exceptions.

Please review system requirements before selecting driver version to download.

Database Driver TIBCO Spotfire Analyst version Details

Amazon Redshift

7.0 and later, Cloud

Link to Amazon's website.

Attivio 7.7 and later, Cloud The Attivio ODBC driver is downloaded from Attivio. Please see the Spotfire Analyst documentation and navigate to Home > Connectors > Attivio > Loading Data from explore.attivio.com.

Apache Spark SQL

7.5 and later, Cloud

7.5 and later: download the driver from the Spotfire Server page at TIBCO E-delivery (select the software version, your operating system and click 'Individual file download'. Select TIBCO Drivers Software.). 

Cloud: Login to Spotfire Cloud from your web browser, click on your user name in the top right corner and navigate to Downloads. Expand the menu "Show list of drivers" and select the driver for Apache Spark SQL.

Cisco Information Server

5.5 and later, Cloud

No driver installation required.

Cloudera Hive

6.0 and later, Cloud

Link to the Cloudera's website.

Cloudera Impala

6.0 and later, Cloud

Link to the Cloudera's website.

Hortonworks

6.0 and later, Cloud

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

6.0 and later, Cloud

Download the HP Vertica ADO.NET driver from HPE's myVertica website.

The driver can be downloaded by registered users. Contact your HP account manager for access to this driver.

IBM DB2

6.5 and later, Cloud

Download the IBM DB2 ODBC driver from IBM's website.

The driver can be downloaded by registered users. Contact your IBM account manager for access to this driver.

IBM Netezza

5.5 and later, Cloud

Contact your IBM account manager for access to the IBM Netezza ODBC driver.

Make sure you install the correct version (32-bit or 64-bit) on your system.

Microsoft SQL Server

5.0 and later, Cloud

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

Microsoft SQL Server Analysis Services

5.0 and later, Cloud

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

SQL Server Analysis Services 2008

SQL Server Analysis Services 2012

Click Download to enable the selection of 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

7.0 and later, Cloud

No driver installation required.

Oracle

5.0 and later, Cloud

Download the ODAC appropriate for your system (64-bit or 32-bit) from Oracle's download website.

Oracle Essbase

6.0 and later, Cloud

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

You must also configure certain environment variables on your computer.

Procedure:

  1. Log in with your Oracle account on Oracle Software Delivery Cloud and search for Oracle Enterprise Performance Management System Client Installers 11.1.2.4.0. Select the Microsoft Windows x64 (64-bit) platform version and download the driver. 
  2. Install the Essbase Client and, during the installation, make sure that both Essbase Client and Essbase Client C API are installed.
  3. Set up the following required environment variables on your computer. To create and configure environment variables, go to System Properties, click on the Advanced tab and click Environment Variables…. Under System variables, click New... and add variables with the following names and values:
    • EPMHOME
      Value: The home path for the Oracle Enterprise Management System.
      (Example: C:\oracle\Middleware\EPMSystem11R1\)
    • ARBORPATH
      Value: The path that you specified during the installation of the Essbase Client. 
      (Example: %EPMHOME%\products\Essbase\EssbaseClient\)
    • ESSBASEPATH
      Value: %ARBORPATH%
    • PATH
      Add the following value to the variable (or create the variable it if it doesn’t already exist on your system):
      %ARBORPATH%\bin;%EPMHOME%\bin;

      Note: If possible, create the variables as system environment variables, rather than user environment variables. If you are configuring a computer running Spotfire Web Player services or Automation Services services, the variables must be created as system environment variables.

Oracle MySQL

5.5 and later, Cloud

Download the Oracle MySQL Connector/Net from Oracle's website.

Pivotal Greenplum

6.0 and later, Cloud

Downlaod the Psql ODBC driver from PostgreSQL's website.

Pivotal HAWQ

6.5 and later, Cloud

Downlaod the Psql ODBC driver from PostgreSQL's website.

PostgreSQL

5.5 and later, Cloud

Downlaod the Psql ODBC driver from PostgreSQL's website.

Salesforce.com

7.5 and later, Cloud

7.5 and later: download the driver from the Spotfire Server page at TIBCO E-delivery (select the software version, your operating system and click 'Individual file download'. Select TIBCO Drivers Software.). 

Cloud: Login to Spotfire Cloud from your web browser, click on your user name in the top right corner and navigate to Downloads. Expand the menu "Show list of drivers" and select the driver for Salesforce.com.

SAP HANA

6.0 and later, Cloud

Link to SAP's Software Download Center website.

The driver can be downloaded by registered users. Contact your SAP account manager for access to this driver.

SAP NetWeaver Business Warehouse (SAP BW)

5.5 and later, Cloud

Link to SAP's Software Download Center website.

The software can be downloaded by registered users. Contact your SAP account manager for access to this software.

The SAP GUI for Windows (Version: 7.3) and, hence, the required driver for the 32-bit version can be obtained through the SAP Software Download Center.

For the 64-bit version, you also need the SAP BW OLE DB for OLAP provider 64bit. This is a standalone installation package. Download the BW ODBO Driver FCS from SAP Software Download Center.

Prerequisite: The 32-bit SAP BW OLE DB for OLAP provider (given above) has been installed.

See SAP documentation for information on how to configure the SAP BW servers on your system.

Teradata

5.0 and later, Cloud

Link to Teradata's website.

Teradata Aster

6.0 and later, Cloud

Link to Teradata's website.

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.

Feedback (1)

Attempting to download driver for Apache Spark SQL, but on eDelivery site there are no choices in the dropdown menus for Version and Operating Systems. Link

jjburnam 11:50am Sep. 28, 2016