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 | |||
In-Database Write | |||
Denodo | Read, Write, In-DB | ||
Dremio | Read-only | ||
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 | |
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) | ||
| parquet, .pqt | Read, Write | |
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 | ||
Read, Write | |||
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 | .hyper | Read, Write | |
Teradata | Read, Write, In-DB | ||
Read-only | |||
Trino | Read, Write (Materialized tables 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 | |
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.