TIBCO Spotfire® Database Drivers
Last updated:
5:07am Mar 07, 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

Link to 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

Link to 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 this ODBC driver.

Make sure the correct version (32-bit or 64-bit) is installed 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

Link to Oracle's Download website.

Download the driver for 32-bit and 64-bit ODAC respectively.

Oracle Essbase

6.0 and later, Cloud

You need an Oracle account to be able to download the driver. When you reach the Media pack search page, choose Product Pack: Oracle Enterprise Performance Management System, Platform: Microsoft Windows x64 (64bit). Download EPM System Release 11.1.2.3.0 Client Installers for Microsoft Windows.

In the Custom Setup screen, make sure that both Essbase Client and Essbase Client C API will be installed.

You must create the required environment variables to access the Essbase Client C API. The environment variables must be exactly as specified, and they must point to the correct paths. Make sure no additional blank spaces are added.

Procedure

1. Open the System Properties of your computer. (On Windows 7 this is reached from Control Panel > All Control Panel Items > System , Advanced system settings.)

2. On the Advanced tab, click Environment Variables.

3. On client computers, under System variables, click New, and then create the variable EPMHOME and set its value to the home path for the Oracle Enterprise Management System. (For example, C:\oracle\Middleware\EPMSystem11R1.)

This home path contains the directories bin, bin-32, common, and products.

We recommend always using System variables, if possible. For machines running Web Player services or Automation Services services, the environment variables must be defined as System variables.

4. Create the variable ARBORPATH and set it to the destination folder chosen in the installer. (For example, C:\oracle\Middleware\EPMSystem11R1\products\Essbase\EssbaseClient (or %EPMHOME%\products\Essbase\EssbaseClient).)

5. Create the variable ESSBASEPATH and set it to %ARBORPATH%.

6. Add the following to the PATH variable (or create the PATH variable): ARBORPATH%\bin;%EPMHOME%\bin;

Oracle MySQL

5.5 and later, Cloud

Link to Oracle's website.

Pivotal Greenplum

6.0 and later, Cloud

Link to the postgresql.org website.

Pivotal HAWQ

6.5 and later, Cloud

Link to the postgresql.org website.

PostgreSQL

5.5 and later, Cloud

Link to the postgresql.org 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