TIBCO Spotfire® Data Sources

Visualize Insights from All Your Data Sources

Data in today’s tech-savvy business world is characterized not only by its volume, but also by its velocity, veracity, and variety. Suddenly the rules of data analytics and management have changed entirely, and you need more advanced analytic capabilities to drive optimal performance.

The Spotfire business intelligence platform accesses your enterprise data stored in heterogeneous data sources in nearly any format, and combines it, so you can make sense of it and get a single, holistic view of the business. In addition, Spotfire offers the flexibility to process your data either in memory, or by accessing a database, helping you fully capitalize on your technology and data investments.

Using Spotfire, business users are truly empowered, with self-service data mash-up functionality that works without any coding requirement or IT involvement. Users have the flexibility to quickly combine their own private data stores, such as Excel spreadsheets or Access databases, with corporate data stores, such as Hadoop or cloud applications, and dynamically insert or swap out massive data sets into a unified, visually interactive analytical interface. These capabilities enable users to derive powerful insights and make educated business decisions in real time.

Spotfire provides multiple access strategies for different data sources to accommodate the needs of every organization and its technology infrastructure. It offers native support via direct connectors to a wide range of data sources, as well as a powerful data federation platform for connectivity to virtually any JDBC compliant data source. In addition, it can access custom data sources via any ODBC compliant source.

For additional details and systems requirements for any of the below Spotfire data access capabilities including Native Data Connectors, Information Services, and TIBCO Spotfire ® Advanced Data Services, please visit the TIBCO Spotfire Systems Requirements Page.

Native Connectors

Native support for in-database, in-memory and on-demand analytics via direct connectors:

  • Apache Hadoop/Hive
  • Cloudera Hive CDH4
  • Cloudera Impala CDH4, 1.2.2, 1.2.3
  • Composite Information Server 6.1, 6.2
  • Hortonworks Data Platform 1.3, 2.0
  • HP Vertica 6.0, 6.1
  • IBM Netezza 6, 7
  • Microsoft Analysis Services 2008, 2012
  • Microsoft SQL Server 2005, 2008 R2, 2012
  • Oracle MySQL 5.1, 5.5, 5.6
  • Oracle and Oracle Exadata (Oracle 11gR1 and R2)
  • Oracle Essbase 9.3, 11.1
  • Pivotal Greenplum 4.1, 4.2
  • Pivotal HAWQ
  • PostgreSQL 8.4, 9.0, 9.1, 9.2
  • SAP HANA SPS5, SPS6
  • SAP NetWeaver Business Warehouse 7.0.1 SP10, 7.3
  • Teradata 12.00.12, 13.00, 13.10, 14.00, 14.10
  • Teradata Aster 5.0, 5.11

Connectivity and Data Federation Using Information Services

TIBCO Spotfire ® Information Services is a data federation platform that comes with the TIBCO Spotfire® Server. Use Information Services to connect to virtually any JDBC-compliant data source and create a single virtual metadata layer across these sources. The result is presented to business users and authors as a single source of data ready for analysis in TIBCO Spotfire’s powerful in-memory engine – loaded on-demand for big data sets.

TIBCO Spotfire® Advanced Data Services

  • Apache Hadoop/Hive 0.8.1, 0.9.0
  • Cloudera CDH4
  • Cloudera Impala 0.6
  • HP Vertica 5.0
  • IBM DB2 LUW 8, 9, 9.5
  • IBM Netezza NPS 5.0, 6.0
  • IBM Informix 9.4
  • Microsoft Access
  • Microsoft Excel
  • Microsoft SQL Server 2000, 2005, 2008, 2012
  • Oracle 9i, 10g, 11g, 11g Type 2, RAC
  • Oracle MySQL 4.1, 5.0, 5.1, 5.5
  • Pivotal Greenplum 3.3, 4.1
  • PostgreSQL 9.0, 9.1
  • SAP Sybase 12.5, 15, 15.5
  • SAP Sybase IQ 15
  • Teradata 12, 13, 13.10
  • Read More

TIBCO Spotfire® Application Data Services: PerformancePlus Application Adapters

  • Oracle E-Business Suite 11.5.8, 11.5.10
  • Salesforce.com
  • SAP BW 3.5, BI 7.0
  • SAP R/3 4.7, mySAP 5.0, 6.0
  • Oracle Siebel 7.7, 7.8, 8.0

TIBCO Spotfire® Advanced Data Services: Enterprise Service Buses

  • TIBCO ActiveMatrix BusinessWorks™
  • Aurea Sonic 7.5

File-Based Data Sources

  • Microsoft Excel Workbooks (.xls, .xlsx, .xlsm)
  • Comma-Separated Values (.csv)
  • Text (.txt)
  • Microsoft Access Databases (.mdb, .mde)
  • SAS Data Files (.sas7bdat, .sd2)
  • Universal Data Link (.udl)
  • Sfs-File (.sfs)
  • ESRI Shape Files (.shp)
  • Spotfire Formats
-