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 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 |
|
|
|
|