Skip to main content

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

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

Databricks Unity Catalog

Read, Write, In-DB

Databricks Volumes

In-Database Write

Denodo

Denodo

Read, Write, In-DB

Dremio

Dremio

Read-only

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, In-DB

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

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

.xlsb

Read, Write

Microsoft Excel Macro Enabled

.xlsm

Read, Write

Microsoft Access 2007, 2010, 2013, 2016, 2019, 2021

.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, Spatial

MongoDB

MongoDB

Read, Write

MySQL

MySQL

Read, Write, In-DB, Spatial

NetSuite

NetSuite

Read-only

OpenGIS

Geography Markup Language

.gml

Write-only

Oracle

Oracle

Read, Write, In-DB, Predictive, Spatial (only with OCI)

 

Parquet file format

parquet, .pqt

Read, Write

Pivotal

Pivotal Greenplum

Read, Write, In-DB

PostgreSQL

PostgreSQL

Read, Write, In-DB, Spatial (with PostGIS)

PrestoDB

Presto

Read, Write

Qlik

QlikView

.qvx

Read, Write

Salesforce

Salesforce

Read, Write

SAP

SAP HANA

Read, Write, In-DB

Sybase IQ

Read, Write

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 Hyper Data Extract

.hyper

Read, Write

Teradata

Teradata

Read, Write, In-DB

Teradata Aster

Read-only

Trino

Trino

Read, Write (Materialized tables 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.

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.