Supported Data Sources
Alteryx connects to a variety of data sources. Alteryx can read, write, or read and write, dependent upon the data source.
| Adobe | Adobe Analytics | Read-only | |
| Alteryx | Alteryx Database | .yxdb | Read, Write |
| Alteryx Calgary | .cydb | Read-only | |
| Alteryx Spatial ZIP | .sz | Read, Write | |
| Amazon | Amazon Athena | Read, Write | |
| Amazon Aurora | Read, Write | ||
| Amazon Redshift | Read, Write, In-DB | ||
| Amazon Redshift Spectrum | Read, Write | ||
| Amazon S3 | Read, Write | ||
| ASCII | ASCII | .flat, .asc | Read, Write |
| Apache | Apache Hadoop Avro | .avro | Read, Write |
| Cassandra | Read, Write | ||
| Hadoop Distributed File System (HDFS) | Read, Write | ||
| Hive | Read, Write, In-DB | ||
| Apache Spark Direct | Read, Write, In-DB | ||
| Apache Spark ODBC | Read, Write, In-DB | ||
| Apache Spark on Databricks | Read, Write, In-DB | ||
| Apache Spark on Microsoft Azure HDInsight | Read, Write, In-DB | ||
| Autodesk | Autodesk | .sdf | Read, Write |
| Cloudera | Cloudera Impala | Read, Write, In-DB | |
| Hadoop Distributed File System (HDFS) | Read, Write | ||
| Hive | Read, Write, In-DB | ||
| CSV | Comma Separated Value | .csv | Read, Write |
| Databricks | Databricks | Read, Write, In-DB | |
| DataStax | DataStax Enterprise, DataStax Community | Read, Write | |
| dBase | dBase | .dbf | Read, Write |
| ESRI | ESRI GeoDatabase | .gdb | Read-only |
| ESRI Personal GeoDatabase | .mdb | Read-only | |
| ESRI Shapefile | .shp (.dbf, .shx, .prj) | Read, Write | |
| EXASOL | EXASOL | Read, Write, In-DB | |
| GIS | GIS | .grd, .grc | Read-only |
| Google Analytics | Read-only | ||
| Google BigQuery | Read, Write | ||
| Google Earth/Maps | .kml, .gml | Read, Write | |
| Google Sheets | Read, Write | ||
| GZip | GZip Files | .tar.gz | Read-only |
| Hortonworks | Hadoop Distributed File System (HDFS) | Read, Write | |
| Hive | Read, Write, In-DB | ||
| HP | Vertica | Read, Write, In-DB | |
| HTML | HyperText Markup Language | .htm | Write-only |
| IBM | IBM DB2 | Read, Write | |
| IBM Netezza/Pure Data Systems | Read, Write, In-DB | ||
| IBM SPSS | .sav | Read, Write | |
| JSON | JSON | .json | Read, Write |
| MapInfo | MapInfo Professional Interchange Format | .mid, .mif | Read, Write |
| MapInfo Professional Table | .tab (*.dat, *.map, *.id, *.ind) | Read, Write | |
| MapR | Hadoop Distributed File System (HDFS) | Read, Write | |
| Hive | Read, Write, In-DB | ||
| Marketo | Marketo | Read, Write | |
| Microsoft | Microsoft Access 2000-2003 | .mdb | Read, Write |
| Microsoft Analytics Platform System | Read, Write, In-DB | ||
| Microsoft Azure Data Lake Store | Read, Write | ||
| Microsoft Azure ML | Read-only | ||
| Microsoft Azure SQL Database | Read, Write, In-DB | ||
| Microsoft Azure SQL Data Warehouse | Read, Write, In-DB | ||
| Microsoft Cognitive Services | Read-only | ||
| Microsoft Dynamics CRM | Read, Write | ||
| Microsoft Excel 1997-2003 | .xls | Read, Write | |
| Microsoft Excel 2007, 2010, 2013, 2016 | .xlsx | Read, Write | |
| Microsoft Excel Binary Requires 2010 Access driver |
.xlsb | Read, Write | |
| Microsoft Excel Macro Enabled | .xlsm | Read, Write | |
| Microsoft Office Access 2007, 2010, 2013, 2016 Requires Access driver |
.accdb | Read, Write | |
| Microsoft OneDrive | Write-only | ||
| Microsoft Power BI | Write-only | ||
| Microsoft SharePoint | Read, Write | ||
| Microsoft SQL Server 2008, 2012, 2014, 2016 | Read, Write, In-DB | ||
| MongoDB | MongoDB | Read, Write | |
| MySQL | MySQL | Read, Write, In-DB | |
| Netsuite | Netsuite Suite Analytics | Read-only | |
| OpenGIS | Geography Markup Language | .gml | Write-only |
| Oracle | Oracle | Read, Write, In-DB, Predictive | |
| Pivotal | Pivotal Greenplum | Read, Write, In-DB | |
| PostgreSQL | PostgreSQL | Read, Write, In-DB | |
| Qlik | Qlik Sense, QlikView | .qvx | Read, Write |
| Salesforce.com | Salesforce | Read, Write | |
| Salesforce Wave | Write-only | ||
| SAP | SAP Hana | Read, Write, In-DB | |
| SAS | SAS | .sas7bdat | Read, Write |
| Snowflake | Snowflake | Read, Write, In-DB | |
| SQLite | SQLite | .sqlite | Read, Write |
| SRC Geography | SRC Geography File | .geo | Read, Write |
| Tableau | Tableau Data Extract | .tde | Write-only |
| Tableau Hyper Data Extract | .hyper | Write-only | |
| Teradata | Teradata | Read, Write, In-DB | |
| Teradata Aster | Read-only | ||
| Text | Text | .txt | Read-only |
| Read-only | |||
| XML | Extensible Markup Language | .xml | Read-only |
| Zip Files | Zip Files | .zip | Read-only |