Supported Data Sources and File Formats
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 | Flat ASCII | .flat | Read, Write |
| Apache | 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 | ||
| 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 | |
| dBase | dBase | .dbf | Read, Write |
| ESRI | ESRI GeoDatabase | .gdb | Read, Write |
| ESRI Personal GeoDatabase | .mdb | Read-only | |
| ESRI Shapefile | .shp | Read, Write | |
| EXASOL | EXASOL | Read, Write, In-DB | |
| GIS | GIS | .grc, .grd | Read-only |
| Google Analytics | Read-only | ||
| Google BigQuery | Read, Write | ||
| Google Earth/Google Maps | .kml | Read, Write | |
| Google Sheets | Read, Write | ||
| Gzip | Gzip | .gz, .tgz | Read-only |
| Hortonworks | Hadoop Distributed File System (HDFS) | Read, Write | |
| Hive | Read, Write, In-DB | ||
| HTML | HyperText Markup Language | .htm | Write-only |
| IBM | IBM DB2 | Read, Write | |
| IBM Netezza | Read, Write, In-DB | ||
| IBM SPSS | .sav | Read, Write | |
| JSON | JSON | .json | Read, Write |
| MapInfo | MapInfo Professional Interchange Format | .mif | Read, Write |
| MapInfo Professional Table | .tab | 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 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 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 | 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 | QlikView | .qvx | Read, Write |
| Salesforce | Salesforce | Read, Write | |
| 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 | .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, .asc | Read-only |
| Vertica | Vertica | Read, Write, In-DB | |
| XML | Extensible Markup Language | .xml | Read-only |
| Zip Files | Zip | .zip | Read-only |