Connecting to supported data sources

Spotfire has native support for a wide range of data source types. For connecting to the supported data sources, Spotfire uses self-service data connectors, each of which is designed and optimized specifically for loading data from its corresponding data sources.

All self-service data connectors are available in the Files and data flyout, under Connect to, where you can easily create new connections or open connections that have been saved in your Spotfire library.

Connecting to a supported data source with a connector

  1. To connect to a natively supported data source, click Files and data.

  2. In the Files and data flyout menu, click Connect to, and in the list of data sources, select the type data source you want to connect to.

  3. In the connection flyout to the right, you can either create a new connection by clicking New connection, or you can open a saved connection from your Spotfire library.

Where do you store your data?

  1. Amazon Aurora MySQL
  2. Amazon Aurora PostgresSQL
  3. Amazon EMR Hive
  4. Amazon EMR Spark SQL
  5. Amazon RDS for MySQL
  6. Amazon RDS for Oracle
  7. Amazon RDS for PostgreSQL
  8. Amazon RDS for SQL Server
  9. Amazon Redshift
  10. Apache Drill
  11. Apache HAWQ
  12. Apache Hive
  13. Apache Spark SQL
  14. Attivio
  15. Brytlyt
  16. Cloudera Hive
  17. Cloudera Impala
  18. Cloudera Spark SQL
  19. Databricks
  20. Dremio
  21. Google Analytics
  22. Google BigQuery
  23. Google Cloud SQL for MySQL
  24. Google Cloud SQL for PostgreSQL
  25. Google Cloud SQL for SQL Server
  26. Greenplum
  27. Hortonwork Hive
  28. Hortonworks Spark SQL
  29. IBM BigInsights Hive
  30. IBM BigInsights Spark SQL
  31. IBM Big SQL
  32. IBM DB2
  33. IBM Netezza
  34. MapR Hive
  35. MapR Spark SQL
  36. MariaDB
  37. Microsoft Azure Analysis Services
  38. Microsoft Azure Database for MariaDB
  39. Microsoft Azure Database for MySQL
  40. Microsoft Azure Database for PostgreSQL
  41. Microsoft Azure Databricks
  42. Microsoft Azure HDInsights Hive
  43. Microsoft Azure HDInsights Spark SQL
  44. Microsoft Azure SQL Database
  45. Microsoft Azure Synapse Analytics
  46. Microsoft SharePoint Online
  47. Microsoft SQL Server
  48. Microsoft SQL Server Analysis Services
  49. MongoDB Connector for BI
  50. OData
  51. Oracle
  52. Oracle Essbase
  53. Oracle MySQL
  54. PostgreSQL
  55. Salesforce
  56. SAP BW
  57. SAP BW/4HANA
  58. SAP HANA
  59. SingleStore
  60. Snowflake
  61. Teradata
  62. Teradata Aster
  63. TIBCO Cloud™ Live Apps
  64. TIBCO® Data Virtualization
  65. TIBCO® Live Datamart
  66. TIBCO Spotfire® Advanced Data Services
  67. Spotfire® Data Streams
  68. Vertica


Can't find your data source in the list?

There might not be a dedicated Spotfire data connector with native support for the external data source you want to connect to. But you can probably connect to your data with one of Spotfire's other methods for loading data.