Data Sources

Last modified: May 18, 2023
Alteryx connects to a variety of data sources. Alteryx can read, write, or read and write, dependent upon the data source.

Data Sources

VERSION

2023.1

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
Denodo Denodo   Read, Write, In-DB
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
  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
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
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, 2019, 2021
Requires Access driver
.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
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
Presto Presto   Read, Write
Qlik  QlikView .qvx Read, Write
Salesforce Salesforce   Read, Write
SAP SAP Hana   Read, Write, In-DB
SAS SAS .sas7bdat  Read, Write
ServiceNow ServiceNow   Read-only
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

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

 

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.