Data Sources

Alteryx connects to a variety of data sources. Alteryx can read, write, or read and write, depending upon the data source.

Supported Data Sources and File Formats

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 (Bulk Only)
	Amazon Aurora		Read, Write
	Amazon Redshift		Read, Write, In-DB
	Amazon Redshift Spectrum		Read, Write
	Amazon S3		Read, Write
Anaplan	Anaplan	.csv, .xlsx, .txt	Read, Write
ASCII	Flat ASCII	.flat	Read, Write
Apache	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
	Avro	.avro	Read, Write
	Apache Cassandra		Read, Write
	Apache Hive		Read, Write, In-DB
	Apache Impala		Read, Write, In-DB
	Hadoop Distributed File System (HDFS)		Read, Write
Automation Anywhere	Automation Anywhere		Read-only
Box	Box	.xlsx, .yxdb, .csv	Read, Write
CSV	Comma Separated Value	.csv	Read, Write
Databricks	Databricks		Read, Write, In-DB
	Databricks Unity Catalog		Read, Write, In-DB
	Databricks Volumes		In-Database Write
Denodo	Denodo		Read, Write, In-DB
Dremio	Dremio		Read-only
Dropbox	Dropbox	.xlsx, .yxdb, .csv	Read, Write
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, In-DB
	Google Cloud Storage		Read, Write
	Google Earth/Google Maps	.kml	Read, Write
	Google Drive	.xlsx, .yxdb, .csv, .gsheet	Read, Write
	Google Sheets		Read, Write
Gzip	Gzip	.gz, .tgz	Read-only
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 - Classic TAB Format	.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 (Azure Synapse Analytics)		Read, Write, In-DB
	Microsoft Cognitive Services		Read-only
	Microsoft Dataverse		Read, Write
	Microsoft Dynamics CRM		Read, Write
	Microsoft Excel 1997-2003	.xls	Read, Write
	Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Office365	.xlsx	Read, Write
	Microsoft Excel Binary	.xlsb	Read, Write
	Microsoft Excel Macro Enabled	.xlsm	Read, Write
	Microsoft Access 2007, 2010, 2013, 2016, 2019, 2021	.accdb, .accde	Read, Write
	Microsoft Outlook 365		Read-only
	Microsoft OneDrive		Read, Write
	Microsoft Power BI		Write-only
	Microsoft SharePoint		Read, Write
	Microsoft SQL Server 2012, 2014, 2016, and 2019		Read, Write, In-DB, Spatial
MongoDB	MongoDB		Read, Write
MySQL	MySQL		Read, Write, In-DB, Spatial
NetSuite	NetSuite		Read-only
OpenGIS	Geography Markup Language	.gml	Write-only
Oracle	Oracle		Read, Write, In-DB, Predictive, Spatial (only with OCI)
	Parquet file format	parquet, .pqt	Read, Write
Pivotal	Pivotal Greenplum		Read, Write, In-DB
PostgreSQL	PostgreSQL		Read, Write, In-DB, Spatial (with PostGIS)
PrestoDB	Presto		Read, Write
Qlik	QlikView	.qvx	Read, Write
Salesforce	Salesforce		Read, Write
SAP	SAP HANA		Read, Write, In-DB
	Sybase IQ		Read, Write
SAS	SAS	.sas7bdat	Read, Write
ServiceNow	ServiceNow		Read-only
SingleStore	SingleStore		Read, Write
Snowflake	Snowflake		Read, Write, In-DB
SQLite	SQLite	.sqlite	Read, Write
SRC Geography	SRC Geography	.geo	Read, Write
Tableau	Tableau Hyper Data Extract	.hyper	Read, Write
Teradata	Teradata		Read, Write, In-DB
	Teradata Aster		Read-only
Trino	Trino		Read, Write (Materialized tables only)
Text	Text	.txt, .asc	Read-only
Vertica	Vertica		Read, Write, In-DB
UiPath	UiPath
XML	Extensible Markup Language	.xml	Read-only
Zip Files	Zip	.zip	Read-only

Deprecated Data Sources and Tools

Even though we deprecated these connectors and we won’t support them, you can still use them in Designer or on Server. If you would like to display their hidden icons, right-click the tool ribbon and select Show deprecated tools. However, we recommend installing new replacement tools. For more information, visit the Community article.

Deprecated Tools	New Tools
SharePoint List	SharePoint
Publish to Tableau Server	Tableau Output
Dynamics CRM	Dataverse
Google Sheets	Google Drive
Salesforce Einstein Analytics
Salesforce Wave

Note

With Designer version 24.1, the default DCM mode is DCM Only. This means that the checkbox to Use DCM on tool configurations might no longer be visible by default. You can still change the DCM Mode in the System Settings or User Settings.

This change doesn’t override your previously configured DCM settings. It only applies to new Designer installs as well as installs where DCM settings have not been previously configured.Go to DCM - Designer for more information.

In this section:

Data Sources

Supported Data Sources and File Formats

Deprecated Data Sources and Tools

Search results