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