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	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
MariaDB	MariaDB		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	Read, Write
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