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 | Read-only | ||
Alteryx | .yxdb | Read, Write | |
Alteryx Calgary | .cydb | Read-only | |
Alteryx Spatial ZIP | .sz | Read, Write | |
Amazon | Read, Write (Bulk Only) | ||
Read, Write | |||
Read, Write, In-DB | |||
Read, Write | |||
Read, Write | |||
Anaplan | .csv, .xlsx, .txt | Read, Write | |
ASCII | .flat | Read, Write | |
Apache | Read, Write, In-DB | ||
Read, Write, In-DB | |||
Read, Write, In-DB | |||
Read, Write, In-DB | |||
.avro | Read, Write | ||
Read, Write | |||
Read, Write, In-DB | |||
Read, Write, In-DB | |||
Read, Write | |||
Automation Anywhere | Read-only | ||
Box | .xlsx, .yxdb, .csv | Read, Write | |
CSV | Comma Separated Value | .csv | Read, Write |
Databricks | Read, Write, In-DB | ||
Read, Write, In-DB | |||
Denodo | Read, Write, In-DB | ||
Dropbox | .xlsx, .yxdb, .csv | Read, Write | |
dBase | dBase | .dbf | Read, Write |
ESRI | .gdb | Read, Write | |
ESRI Personal GeoDatabase | mdb | Read-only | |
ESRI Shapefile | .shp | Read, Write | |
EXASOL | Read, Write, In-DB | ||
GIS | GIS | .grc, .grd | Read-only |
Read-only | |||
Read, Write, In-DB | |||
Google Earth/Google Maps | .kml | Read, Write | |
.xlsx, .yxdb, .csv, .gsheet | Read, Write | ||
Read, Write | |||
Gzip | .gz, .tgz | Read-only | |
Hortonworks | Read, Write | ||
HTML | HyperText Markup Language | .htm | Write-only |
IBM | Read, Write | ||
Read, Write, In-DB | |||
.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 | Read, Write | ||
Read, Write, In-DB | |||
Marketo | Read, Write | ||
Microsoft | Microsoft Access 2000-2003 | .mdb | Read, Write |
Read, Write, In-DB | |||
Read, Write | |||
Read, Write, In-DB | |||
Microsoft Azure SQL Data Warehouse (Azure Synapse Analytics) | Read, Write, In-DB | ||
Read-only | |||
Read, Write | |||
Read, Write | |||
Microsoft Excel 1997-2003 | .xls | Read, Write | |
.xlsx | Read, Write | ||
Microsoft Excel Binary | .xlsb | Read, Write | |
Microsoft Excel Macro Enabled | .xlsm | Read, Write | |
.accdb, .accde | Read, Write | ||
Read-only | |||
Read, Write | |||
Write-only | |||
Read, Write | |||
Read, Write, In-DB, Spatial | |||
MongoDB | Read, Write | ||
MySQL | Read, Write, In-DB, Spatial | ||
NetSuite | Read-only | ||
OpenGIS | Geography Markup Language | .gml | Write-only |
Oracle | Read, Write, In-DB, Predictive, Spatial (only with OCI) | ||
Pivotal | Read, Write, In-DB | ||
PostgreSQL | Read, Write, In-DB, Spatial (with PostGIS) | ||
PrestoDB | Read, Write | ||
Qlik | QlikView | .qvx | Read, Write |
Salesforce | Read, Write | ||
SAP | Read, Write, In-DB | ||
SAS | .sas7bdat | Read, Write | |
ServiceNow | Read-only | ||
Snowflake | Read, Write, In-DB | ||
SQLite | SQLite | .sqlite | Read, Write |
SRC Geography | SRC Geography | .geo | Read, Write |
Tableau | .tde | Write-only | |
.hyper | Read, Write | ||
Teradata | Read, Write, In-DB | ||
Read-only | |||
Text | Text | .txt, .asc | Read-only |
Vertica | Read, Write, In-DB | ||
UiPath | |||
XML | .xml | Read-only | |
Zip Files | .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 | |