Data Sources

Last modified: November 04, 2021
Alteryx connects to a variety of data sources. Alteryx can read, write, or read and write, dependent upon the data source.

Data Sources



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
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
Box Box .xlsx, .yxdb, .csv Read, Write
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
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
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 (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
Requires 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   Read, Write
  Microsoft Power BI   Write-only
  Microsoft SharePoint   Read, Write
  Microsoft SQL Server 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
UiPath UiPath    
XML Extensible Markup Language .xml Read-only
Zip Files Zip .zip Read-only
Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.