Spotfire® data access FAQ
Our Spotfire data access FAQ is available here.
The data access overview in the Spotfire Analyst help is available here.
Spotfire® self-service access data sources
Spotfire includes self-service connectivity to a wide 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.
For more information on each data source and connector, see Spotfire Analyst User's Guide. Most data connectors need a corresponding driver. For more information about where to find drivers, see Drivers and data sources in Spotfire.
Useful information:
- Spotfire Connectors documentation (functions, data types, connection properties)
- Spotfire Connectors system requirements (data sources, driver versions)
- How to connect to Google Analytics with Spotfire - Wiki page with Youtube video and detailed instructions
- How to Navigate Big Data with Ad Hoc Visual Discovery (white paper)
JDBC data sources (Information Services / Information Designer)
Spotfire accesses data in virtually any JDBC-compliant data source. Connections are configured in the Spotfire Analyst client using the Information Designer tool. Configured information links and data sources reside on the Spotfire Server and clients connect through the Spotfire Server as well.
Useful information:
TIBCO Data Virtualization / Spotfire Advanced Data Services
TIBCO Data Virtualization (TDV) integrates disparate data sources in real-time instead of copying their data into a Data Warehouse, allowing you to easily create logical views to integrate and secure data across disparate data sources and tailor it to your analytical needs. TDV connects to virtually any data source and provides business users access to data in Spotfire.
Spotfire Advanced Data Services is delivered as TIBCO Data Virtualization that only allows access to the Spotfire client.
From Spotfire 11.6, Business Author and Analyst users are able to browse and open connections to virtualized views directly from the Spotfire Files and data flyout.
ODBC data sources
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, Twitter, Facebook, LinkedIn and many more.
Useful information:
OLAP data sources
Spotfire accesses data in several OLAP data sources.
Useful information:
Spotfire® Analyst data file formats
Spotfire supports analyzing data from many common file formats. For the full list of supported formats, see the Spotfire Analyst User Guide.
Microsoft SharePoint Online
Spotfire has a native connector for accessing Lists located on Microsoft SharePoint Online.
For access to CSV and Excel files, it is recommended to use the Custom Connector for Spotfire® to read data from Microsoft SharePoint Online Files.
Google Drive and Google Shared Drives
For access to Google Sheets, CSV and Excel files located on Google Drive or Google Shared Drives, it is recommende to use the Custom Connector for Spotfire® to read data from Google Sheets.
Azure SQL and Azure Synapse
Spotfire has a native connector for Azure SQL and Azure Synapse.
For using Azure AD Token Authentication or an Azure AD Personal Access Token, it is recommended to use the Custom Connector for Spotfire® to Connect to Azure SQL and Azure Synapse.
Azure Databricks
Spofire has a native connector (Apache Spark SQL) for Azure Databricks.
For using Azure AD Token Authentication or an Azure AD Personal Access Token, it is recommended to use the Custom Connector for Spotfire® to Connect to Azure Databricks.
Trino
The Custom Connector for Spotfire® to Connect to Trino allows Spotfire users to connect to Trino (formerly Presto SQL). Trino is a highly parallel and distributed query engine, designed for efficient, low latency analytics.
Denodo
The Custom Connector for Spotfire® to Connect to Denodo allows Spotfire users to connect to Denodo. Denodo is a data virtualization platform, providing data integration and abstraction across a broad range of enterprise, cloud, big data and unstructured data sources.
OSIsoft PI System
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 Spotfire 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.
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.
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:
Attachments
You can download attachments from resources.
-
Spotfire Connectors documentation (functions, data types, connection properties)
-
Spotfire Connectors system requirements (data sources, driver versions)
-
How to connect to Google Analytics with Spotfire - Wiki page with Youtube video and detailed instructions
- How to Navigate Big Data with Ad Hoc Visual Discovery (white paper)
Recommended Comments
There are no comments to display.