You are here:

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 Alteryx Calgary Alteryx Spatial ZIP	.yxdb .cydb .sz	Read, Write Read-only Read, Write
Amazon	Amazon Aurora Amazon Athena Amazon Redshift Redshift Spectrum Amazon S3		Read, Write Read, Write Read, Write, In-DB Read, Write Read, Write
ASCII	ASCII	.flat, .asc	Read, Write
Apache	Apache Hadoop Avro Cassandra Hadoop Distributed File System (HDFS) Hive Spark ODBC Spark Direct	.avro	Read, Write Read, Write Read, Write Read, Write, In-DB Read, Write, In-DB Read, Write, In-DB
Autodesk	Autodesk	.sdf	Read, Write
Cloudera	Cloudera Impala Hadoop Distributed File System (HDFS) Hive		Read, Write, In-DB Read, Write 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 ESRI Personal GeoDatabase ESRI Shapefile	.gdb .mdb .shp (.dbf, .shx, .prj)	Read-only Read-only Read, Write
EXASOL	EXASOL		Read, Write, In-DB
Foursquare	Foursquare		Read-only
GIS	GIS	.grd, .grc	Read-only
Google	Google Analytics Google BigQuery Google Earth/Maps Google Sheets	.kml	Read-only Read-only Read, Write Read, Write
Hortonworks	Hadoop Distributed File System (HDFS) Hive		Read, Write Read, Write, In-DB
HP	Vertica		Read, Write, In-DB
HTML	HyperText Markup Language	.htm	Write-only
IBM	IBM DB2 IBM Netezza/Pure Data Systems IBM SPSS	.sav	Read, Write Read, Write, In-DB Read, Write
JSON	JSON	.json	Read, Write
MapInfo	MapInfo Professional Interchange Format MapInfo Professional Table	.mid, .mif .tab (.dat, .map, .id, .ind)	Read, Write Read, Write
MapR	Hadoop Distributed File System (HDFS) Hive		Read, Write Read, Write, In-DB
Marketo	Marketo		Read, Write
Microsoft	Microsoft Access 2000-2003 Microsoft Analytics Platform System Microsoft Azure ML Microsoft Azure SQL Database Microsoft Azure SQL Data Warehouse Microsoft Cognitive Services Microsoft Excel 1997-2003 Microsoft Excel 2007, 2010, 2013, 2016 Microsoft Excel Binary Requires 2010 Access driver Microsoft Excel Macro Enabled Microsoft Office Access 2007, 2010, 2013, 2016 Requires Access driver Microsoft Power BI Microsoft SQL Server 2008, 2012, 2014, 2016 Microsoft SharePoint	.mdb .xls .xlsx .xlsb .xlsm .accdb	Read, Write Read, Write, In-DB Read-only Read, Write, In-DB Read, Write, In-DB Read-only Read, Write Read, Write Read, Write Read, Write Read, Write Write-only Read, Write, In-DB Read, Write
MongoDB	MongoDB		Read, Write
MySQL	MySQL		Read, Write
Netsuite	Netsuite Suite Analytics		Read-only
OpenGIS	Geography Markup Language	.gml	Read, Write
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 Salesforce Wave		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 File	.geo	Read, Write
Tableau	Tableau Data Extract Tableau Hyper	.tde .hyper	Write-only Write-only
Teradata	Teradata Teradata Aster		Read, Write, In-DB Read-only
Text	Text	.txt	Read-only
Twitter	Twitter		Read-only
XML	Extensible Markup Language	.xml	Read-only
Zip Files	Zip Files	.zip	Read-only