Supported data sources for data connections
The following are the external data sources that this version of Spotfire has native support for. In order to connect to a data source, you use a connector to create a data connection. Some connectors have support for more than one data source, which is why there are more supported data sources than connectors.
All these data sources are available in the
Connect to list in the
Files and data
flyout. From there you can easily
create a new connection or find shared connections in your library.
Data sources and connectors
For help and documentation about connecting to and accessing data from a specific data source, follow the link for the corresponding connector in the list.
| Data source | Connector name |
|---|---|
| Amazon Aurora MySQL | MySQL |
| Amazon Aurora PostgreSQL | PostgreSQL |
| Amazon EMR Hive | Hortonworks |
| Amazon EMR Spark SQL | Apache Spark SQL |
| Amazon RDS for MariaDB | MySQL |
| Amazon RDS for MySQL | MySQL |
| Amazon RDS for Oracle | Oracle |
| Amazon RDS for PostgreSQL | PostgreSQL |
| Amazon RDS for SQL Server | Microsoft SQL Server |
| Amazon Redshift | Amazon Redshift |
| Apache Drill | Apache Drill |
| Apache Hive | Hortonworks |
| Apache Spark SQL | Apache Spark SQL |
| Brytlyt | PostgreSQL |
| Cloudera Hive | Cloudera Hive |
| Cloudera Impala | Cloudera Impala |
| Cloudera Spark SQL | Apache Spark SQL |
| Databricks | Apache Spark SQL |
| Dremio | Dremio |
| Google Analytics | Google Analytics |
| Google BigQuery | Google BigQuery |
| Google Cloud SQL for MySQL | MySQL |
| Google Cloud SQL for PostgreSQL | PostgreSQL |
| Google Cloud SQL for SQL Server | Microsoft SQL Server |
| Greenplum | Greenplum |
| Hortonworks Hive | Hortonworks |
| Hortonworks Spark SQL | Apache Spark SQL |
| IBM BigInsights Hive | Hortonworks |
| IBM BigInsights Spark SQL | Apache Spark SQL |
| IBM DB2 | IBM DB2 |
| IBM DB2 Big SQL | IBM DB2 |
| IBM Netezza | IBM Netezza |
| MapR Hive | Hortonworks |
| MapR Spark SQL | Apache Spark SQL |
| MariaDB | MySQL |
| Microsoft Azure Analysis Services | Microsoft SQL Server Analysis Services |
| Microsoft Azure Database for MariaDB | MySQL |
| Microsoft Azure Database for MySQL | MySQL |
| Microsoft Azure Database for PostgreSQL | PostgreSQL |
| Microsoft Azure HDInsight Hive | Hortonworks |
| Microsoft Azure HDInsight Spark SQL | Apache Spark SQL |
| Microsoft Azure SQL Database | Microsoft SQL Server |
| Microsoft Azure Synapse Analytics | Microsoft SQL Server |
| Microsoft SQL Server | Microsoft SQL Server |
| Microsoft SQL Server Analysis Services | Microsoft SQL Server Analysis Services |
| Microsoft SharePoint Online | Microsoft SharePoint Online |
| MongoDB Connector for BI | MySQL |
| MySQL | MySQL |
| OData | OData |
| Oracle | Oracle |
| Oracle Essbase | Oracle Essbase |
| PostgreSQL | PostgreSQL |
| SAP BW | SAP BW |
| SAP BW/4HANA | SAP BW |
| SAP HANA | SAP HANA |
| Salesforce | Salesforce |
| SingleStore | MySQL |
| Snowflake | Snowflake |
| TIBCO Cloud Data Streams | Spotfire Data Streams |
| TIBCO Cloud Live Apps | TIBCO Cloud™ Live Apps |
| TIBCO Data Virtualization | TIBCO Data Virtualization |
| TIBCO Spotfire Advanced Data Services | TIBCO Data Virtualization |
| Spotfire Data Streams | Spotfire Data Streams |
| Teradata | Teradata |
| Vertica | Vertica |