Connectors
With the connectors that are available in Spotfire, users can connect to, and analyze data from, a variety of data sources. This section describes how to configure the connectors for use in Spotfire Analyst, TIBCO Spotfire® Business Author, TIBCO Spotfire® Consumer, and TIBCO Spotfire® Automation Services.
The following connectors are currently available:
- Amazon Redshift
- Apache Drill
- Apache Spark SQL
- Attivio
- Cloudera Hive
- Cloudera Impala
- Dremio
- Google Analytics
- Google BigQuery
- Hortonworks
- IBM DB2
- IBM Netezza
- Microsoft SQL Server
- Microsoft SQL Server Analysis Services
- OData
- Oracle
- Oracle Essbase
- Oracle MySQL
- Pivotal Greenplum
- Pivotal HAWQ
- PostgreSQL
- Salesforce
- SAP BW
- SAP HANA
- Snowflake
- Teradata
- Teradata Aster
- TIBCO Cloud™ Live Apps
- TIBCO ComputeDB
- TIBCO Data Virtualization
- TIBCO Spotfire Data Streams
- Vertica
- Setting up connectors
Before you can use a data source connector on a Spotfire client, the connector must be installed on the server and the data source driver must be installed on the client computer. - Configuring connectors for use with web clients and Spotfire Automation Services
If connectors should be available for users of Spotfire web clients, or in Spotfire Automation Services, some configuration on the Spotfire Server is necessary. - Access to the connectors
After you configure the connectors, you must specify access rights to make the connectors available for users of any Spotfire client. - Installing Oracle Essbase Client on client computers
To use the Oracle Essbase connector, you must also install Oracle Essbase Client on each computer that will run the connector. - Configuring the Google Analytics and Google BigQuery connectors
To enable the Google Analytics and Google BigQuery connectors for use in Spotfire web clients, you must configure your Google Cloud Platform project. - Enabling federated authentication for the Salesforce connector in web clients
To enable the use of the authentication method Log in with Salesforce , which is required to use federated authentication, when you use the Salesforce connector in Spotfire web clients, you must first create a new app in your Salesforce instance. Then, in Spotfire, you configure the Salesforce connector to connect through the new app. - Configuring the Microsoft SharePoint Online connector
To be able to use the Microsoft SharePoint Online connector in your Spotfire web clients, you must add theapplication (client) id
andclient secret
of a registered app in Microsoft Azure in the web player service configuration.
- Setting up connectors
Before you can use a data source connector on a Spotfire client, the connector must be installed on the server and the data source driver must be installed on the client computer. - Configuring connectors for use with web clients and Spotfire Automation Services
If connectors should be available for users of Spotfire web clients, or in Spotfire Automation Services, some configuration on the Spotfire Server is necessary. - Access to the connectors
After you configure the connectors, you must specify access rights to make the connectors available for users of any Spotfire client. - Installing Oracle Essbase Client on client computers
To use the Oracle Essbase connector, you must also install Oracle Essbase Client on each computer that will run the connector. - Configuring the Google Analytics and Google BigQuery connectors
To enable the Google Analytics and Google BigQuery connectors for use in Spotfire web clients, you must configure your Google Cloud Platform project. - Enabling federated authentication for the Salesforce connector in web clients
To enable the use of the authentication method Log in with Salesforce , which is required to use federated authentication, when you use the Salesforce connector in Spotfire web clients, you must first create a new app in your Salesforce instance. Then, in Spotfire, you configure the Salesforce connector to connect through the new app. - Configuring the Microsoft SharePoint Online connector
To be able to use the Microsoft SharePoint Online connector in your Spotfire web clients, you must add theapplication (client) id
andclient secret
of a registered app in Microsoft Azure in the web player service configuration.
Parent topic: Installation and configuration