Supported data sources in Spotfire Business Author On-Premise

In the on-premise version of Spotfire Business Author, which runs on your company's own servers, all Spotfire data source 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 Spotfire Business Author. 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, all connectors 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.
Connector name Web client authoring
Amazon Redshift NO
Apache Spark SQL NO
Attivio NO
Cisco Information Server NO
Cloudera Hive NO
Cloudera Impala NO
Google Analytics YES
Hortonworks NO
HP Vertica NO
IBM DB2 NO
IBM Netezza 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.com YES
SAP BW NO
SAP HANA NO
Teradata NO
Teradata Aster NO