You are here: Supported Data Sources

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 & Write  
  Alteryx Spatial Zip .sz Read & Write  
  Alteryx Web .vlmn Read-only  
Amazon Amazon Aurora   Read & Write  
  Amazon Redshift   Read & Write In-DB Support
  Amazon S3   Read & Write  
ASCII ASCII .flat, .asc Read & Write  
Apache Hadoop Apache Hadoop Avro .avro Read & Write  
  Cassandra   Read & Write  
  Hadoop Distributed File System (HDFS)   Read & Write  
  Hadoop Hive   Read & Write In-DB Support
  Spark   Read & Write In-DB Support
Autodesk Autodesk .sdf Read & Write  
Cloudera Cloudera Impala   Read & Write In-DB Support
  Hadoop Distributed File System (HDFS)   Read & Write  
  Hadoop Hive   Read & Write In-DB Support
CSV Comma Separated Value .csv Read & Write  
Databricks Databricks   Read & Write In-DB Support
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  
Exasolution EXASOL   Read & Write  
Foursquare Foursquare   Read-only  
GIS GIS .grd, .grc Read-only  
Google Google Analytics   Read-only  
  Google BigQuery   Read-only  
  Google Earth/Maps .kml Read & Write  
  Google Sheets   Read & Write  
Hortonworks Hadoop Distributed File System (HDFS)   Read & Write  
  Hadoop Hive   Read & Write In-DB Support
HP Vertica   Read & Write  
IBM IBM DB2   Read & Write  
  IBM Netezza/Pure Data Systems   Read & Write
  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  
  Hadoop Hive   Read & Write In-DB Support
Marketo Marketo   Read & Write  
Microsoft Microsoft Access 2000-2003 .mdb Read & Write  
  Microsoft Azure ML   Read-only  
  Microsoft Azure SQL Data Warehouse   Read & Write In-DB Support
  Microsoft Excel 1997-2003 .xls Read & Write  
  Microsoft Excel 2007, 2010, 2013, 2016 .xlsx Read & Write  
  Microsoft Excel Macro Enabled .xlsm Read & Write  
  Microsoft Office Access 2007, 2010, 2013, 2016 .accdb Read & Write  
  Microsoft Power BI   Write  
  Microsoft SQL Server 2008, 2012, 2014, 2016   Read & Write In-DB Support
  Microsoft Sharepoint   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 Support & Predictive Support
Pivotal Pivotal Greenplum   Read & Write  
PostgreSQL PostgreSQL   Read & Write  
Qlik Qlik Sense, QlikView .qvx Read & Write  
Salesforce.com Salesforce   Read & Write  
  Salesforce Wave      
SAP SAP Hana   Read & Write
  Sybase Adaptive Server Enterprise   Read & Write  
  Sybase SQL Anywhere 10   Read & Write  
SAS SAS .sas7bdat Read & Write  
SQLite SQLite .sqlite Read & Write  
SRC Geography SRC Geography File .geo Read & Write  
Tableau Alteryx Web Data Connector for Tableau   Publish  
  Publish to Tableau Server   Publish  
  Tableau Data Extract .tde Write-only  
Teradata Teradata   Read & Write In-DB Support
  Teradata Aster   Read  
Twitter Twitter   Read-only  
XML Extensible Markup Language .xml Read-only  
Zip Files Zip Files .zip Read-only