Supported data sources

In the on-premise version of Spotfire Business Author, which runs on your company's own servers, most Spotfire data connectors are available. When working with connectors in the web client, you have different capabilities for different data sources.

For some connectors, you have full authoring and access capabilities in Spotfire Business Author. This means you can set up connections to the corresponding data sources directly in the web client, to add data to a new analysis or one that you are working on.

For some other connectors, you only have access capabilities in the Spotfire web client. This means that connections to the corresponding data sources must be authored in an installed client. You can then continue to work on analyses that contain connections to these data sources in the web client. You can also use connections that have been saved to the library.

Supported connectors in Spotfire Business Author

In the on-premise version of Spotfire Business Author, most connectors that are available in the installed client can be used.

You do not need to install any drivers on the computer that you will access the web client from. However, the connectors you want to use must be turned on for your web client instance and the data source drivers must be installed on the computer on which the web clients are running. Contact your Spotfire administrator if you need access to more connectors in your web client instance. For more information about deploying connectors, see the Spotfire Server and Environment Installation and Administration Help available at https://docs.tibco.com/products/tibco-spotfire-server.

Note: If you want to author data connections in a Spotfire installed client, some connectors require that you install data source drivers on your computer. See TIBCO Spotfire Database Drivers for more information.
Supported connectors
Connector name Web client authoring
Amazon Redshift NO
Apache Drill NO
Apache Spark SQL NO
Attivio NO
Cloudera Hive NO
Cloudera Impala NO
Dremio NO
Google Analytics YES
Google BigQuery NO
Hortonworks NO
IBM DB2 NO
IBM Netezza NO
Microsoft SharePoint Online NO
Microsoft SQL Server NO
Microsoft SQL Server Analysis Services NO
OData NO
Oracle Essbase NO
Oracle MySQL NO
Pivotal Greenplum NO
Pivotal HAWQ NO
PostgreSQL NO
Salesforce YES
SAP BW NO
SAP HANA NO
Snowflake NO
Teradata NO
Teradata Aster NO
TIBCO Cloud™ Live Apps NO
TIBCO ComputeDB NO
TIBCO Data Virtualization NO
TIBCO Spotfire Data Streams NO
Vertica NO