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.
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 |