TIBCO Spotfire® Data Access

Last updated:
5:01am Mar 05, 2021

TIBCO Spotfire® data access FAQ

Our Spotfire data access FAQ is available here.

The data access overview in the Spotfire Analyst help is available here.

TIBCO Spotfire self-service access data sources

Self-service data connectors allow Spotfire users to easily connect to and analyze data from relational databases, cubes, OData sources, and Hadoop.

Most data connectors need a corresponding ODBC or ADO .Net driver. If no driver has been installed, you will see that the connector is greyed out in the Add Data Tables list in Spotfire Analyst.

Spotfire includes self-service connectivity to a range of data sources via Spotfire Connectors. Most connectors support visual data discovery using live querying, allowing you to leave big data in the data source (in-database). All relational connectors support bringing in slices of data up front or on-demand based on user interactions in Spotfire clients. These are the available connectors today in Spotfire:

# Data Source Spotfire Data Connector
1 Amazon Aurora MySQL MySQL
2 Amazon Aurora PostgreSQL PostgreSQL
3
Amazon Redshift
Amazon Redshift
4 Amazon EMR Hive Hortonworks
5 Amazon EMR Spark SQL Apache Spark SQL
6 Amazon RDS for PostgreSQL PostgreSQL
7 Amazon RDS for MySQL MySQL
8 Amazon RDS SQL Server Microsoft SQL Server
9 Apache Drill Apache Drill
10
Apache Hive
Hortonworks
11
Apache Spark SQL
Apache Spark SQL
12
Attivio AIE
Attivio
13
Attivio Semantic Data Catalog
Attivio
14
Cloudera Hive
Cloudera Hive
15
Cloudera Impala
Cloudera Impala
16
Cloudera Spark SQL
Apache Spark SQL
17
Databricks
Apache Spark SQL
18 Dremio Dremio
19
Google Analytics
Google Analytics
20 Google BigQuery Google BigQuery
21 Google Cloud SQL MySQL MySQL
22 Google Cloud SQL PostgreSQL PostgreSQL
23 Google Cloud SQL SQL Server Microsoft SQL Server
24
Hortonworks Hive
Hortonworks
25
Hortonworks Spark SQL
Apache Spark SQL
26
IBM BigInsights Hive
Hortonworks
27
IBM BigInsights Spark SQL
Apache Spark SQL
28 IBM Big SQL IBM DB2
29
IBM DB2
IBM DB2
30
IBM Netezza
IBM Netezza
31
MapR Hive
Hortonworks
32
MapR Spark SQL
Apache Spark SQL
33 MariaDB MySQL
34 Microsoft Azure Database for MariaDB MySQL
35 Microsoft Azure Database for MySQL MySQL
36 Microsoft Azure Database for PostgreSQL PostgreSQL
37 Microsoft Azure Databricks Apache Spark SQL
38 Microsoft Azure HDInsight Hive Hortonworks
39 Microsoft Azure HDInsight Spark SQL Apache Spark SQL
40 Microsoft Azure Database for PostgreSQL PostgreSQL
41
Microsoft Azure SQL Database
Microsoft SQL Server
42
Microsoft Azure Synapse Analytics
Microsoft SQL Server
43 Microsoft SharePoint Online Lists Microsoft SharePoint Online Lists
44
Microsoft SQL Server
Microsoft SQL Server
45
Microsoft SQL Server Analysis Services
Microsoft SQL Server Analysis Services
46 MongoDB MySQL
47 MySQL MySQL
48
OData
OData
49
Oracle
Oracle
50
Oracle Essbase
Oracle Essbase
51
Pivotal Greenplum
Pivotal Greenplum
52
Pivotal HAWQ
Pivotal HAWQ
53
PostgreSQL
PostgreSQL
54
Salesforce
Salesforce
55
SAP BW (NetWeaver Business Warehouse)
SAP BW
56 SAP BW/4HANA SAP BW
57 SAP HANA SAP HANA
58 SingleStore (fka MemSQL) MySQL
59 Snowflake Snowflake
60 TIBCO Cloud Data Streams TIBCO Spotfire Data Streams
61 TIBCO Cloud Live Apps TIBCO Cloud Live Apps
62 TIBCO ComputeDB TIBCO ComputeDB
63 TIBCO Data Virtualization TIBCO Data Virtualization
64 TIBCO Live Datamart TIBCO Spotfire Data Streams
65 TIBCO Spotfire Advanced Data Services TIBCO Data Virtualization
66 TIBCO Spotfire Data Streams TIBCO Spotfire Data Streams
67
Teradata
Teradata
68
Teradata Aster
Teradata Aster
69 Vertica Vertica

Spotfire JDBC data sources (Information Services / Information Designer)

TIBCO Spotfire accesses data in virtually any JDBC compliant data source. Connections are configured in the Spotfire Analyst client using the Information Designer tool. Configured connections reside on the Spotfire Server and clients connect through the Spotfire Server as well.

Useful information:

Spotfire ODBC data sources

TIBCO Spotfire accesses data in virtually any ODBC compliant data source. Database vendors like Simba, Progress and CDATA offer ODBC drivers to a wide range of data sources and combined with Spotfire's ODBC support data can be analyzed in data sources such as MongoDB, Cassandra, DynamoDB, HBase, Google BigQuery, Twitter, Facebook, LinkedIn and many more.

Useful information:

OLAP data sources

TIBCO Spotfire accesses data in several OLAP data sources.

Useful information:

Apache Cassandra and MongoDB

A summary of how to connect to MongoDB is available here.

For self service access to Apache Cassandra and MongoDB, please use TIBCO's ODBC drivers available at:

TIBCO eDelivery

or

TIBCO Cloud™ Spotfire® (TIBCO Cloud Spotfire or trial subscription is needed)

Connect by following the instructions in https://docs.tibco.com/emp/sf_drivers/1.2.0/doc/pdf/TIB_drivers_ConnectingToODBCDataSourceUsingSpotfire.pdf.

JDBC drivers are available from Progress and Magnitude (Simba):

The JDBC driver are used in combination with Spotfire Information Services (see Spotfire JDBC data sources above). Compared with ODBC Spotfire Information Services adds support for on-demand, server side driver installation and centralized governance of data models.

Spotfire Analyst Data File Formats

  • ADO.NET
  • Comma-Separated Values (.csv)
  • ESRI Shape Files (.shp)
  • Microsoft Access Databases (.mdb, .mde)
  • Microsoft Excel Workbooks (.xls, .xlsx, .xlsm)
  • SAS Data Files* (.sas7bdat, .sd2)
  • Spotfire DecisionSite Files (.sfs)
  • Spotfire Text Data Format (.stdf)
  • Spotfire Binary Data Format (.sbdf)
  • Text (.txt)
  • TIBCO Formvine
  • Universal Data Link (.udl)

*Note: SAS files are not supported in Spotfire web clients. (system requirements)

MapR Drill

MapR Apache Drill is supported by a native connector starting with Spotfire 10.0.

Microsoft SharePoint and OData

Spotfire has a native connector for OData and SharePoint lists. For more information see the Spotfire self-service access data sources section above.

For access to SharePoint Online the custom extension from EPAM is recommended.

OSIsoft PI System

TIBCO Spotfire allows you to analyze OSIsoft PI System events either as they occur, using the context of past data for reference, or as part of a data discovery phase, combined with other data, to find root causes, trends and outliers. OSIsoft and Spotfire have worked collaboratively to build and test these solutions in the field.

By combining OSIsoft PI data ‘at-rest’ (either directly from PI Server or via Asset Framework (AF)) with data from ERP systems such as SAP, relational databases, Hadoop and unstructured sources, an organization can obtain a more holistic view of the business, allowing users to extract more meaningful insights and make educated business decisions – and thereby mitigate risks of plant failure, reduce maintenance costs, and drive improved operations.

By connecting directly with real-time streaming OSIsoft PI data ’in-motion’, via TIBCO StreamBase, organizations can compare actual readings with sophisticated statistical models that will help predict performance, downtime and running costs. Moreover, real time adjustments, alerts and instructions can be generated to avoid failures and risk or to improve operational efficiency.

See the Getting Data into Spotfire from OSIsoft PI, Asset Framework, and Event Frames Wiki page to download the OSIsoft PI custom data source.

An alternative to the custom data source above is to use the PI JDBC driver that OSIsoft provides. It's used together with Spotfire Information Services.

For more information about our OSIsoft PI System integration please contact your Spotfire sales representative or use our Contact Us form.

SAP BW

Spotfire connects to SAP BW using the self-service connector for SAP BW or TIBCO Data Virtualization.

A lot of valuable information is available in the Working with Cubes in Spotfire document.

For a guide to how to configure single sign on using Kerberos for Spotfire with SAP BW please see this WiKi.

Best practices for the Spotfire connector for SAP BW

SAP Business Objects Universe

This is one way of connecting TIBCO Spotfire to SAP Business Objects Universe

Splunk

Please see this Wiki.

TIBCO Spotfire Data Streams (Live Datamart)

TIBCO® Live Datamart has been renamed to TIBCO Spotfire Data Streams. A native connector for streaming analytics is included starting with Spotfire 10.0.

Read and write Spotfire data extracts, SBDF files

You could integrate read and write support for Spotfire Binary Data Format files (.sbdf) into your application. Source code, samples and documentation is available here:

Live monitoring of what's stored in the Library

This great Wiki gives an example of how you can monitor your data sources stored in the Library:

https://community.tibco.com/wiki/tibco-spotfire-metadata-queries

Attachments