Azure Data Factory and Azure Synapse Analytics connector overview

APPLIES TO: Azure Data Factory Azure Synapse Analytics

Azure Data Factory and Azure Synapse Analytics pipelines support the following data stores and formats via Copy, Data Flow, Look up, Get Metadata, and Delete activities. Click each data store to learn the supported capabilities and the corresponding configurations in details.

Supported data stores

Category Data store Copy activity (source/sink) Mapping Data Flow (source/sink) Lookup Activity Get Metadata Activity/Validation Activity Delete Activity
Azure Azure Blob Storage ✓/✓ ✓/✓
  Azure Cognitive Search Index −/✓
  Azure Cosmos DB (SQL API) ✓/✓ ✓/✓
  Azure Cosmos DB's API for MongoDB ✓/✓
  Azure Data Explorer ✓/✓ ✓/✓
  Azure Data Lake Storage Gen1 ✓/✓ ✓/✓
  Azure Data Lake Storage Gen2 ✓/✓ ✓/✓
  Azure Database for MariaDB ✓/−
  Azure Database for MySQL ✓/✓ ✓/✓
  Azure Database for PostgreSQL ✓/✓ ✓/✓
  Azure Databricks Delta Lake ✓/✓ ✓/✓ Use delta format
  Azure Files ✓/✓
  Azure SQL Database ✓/✓ ✓/✓
  Azure SQL Managed Instance ✓/✓ ✓/✓
  Azure Synapse Analytics ✓/✓ ✓/✓
  Azure Table Storage ✓/✓
Database Amazon RDS for Oracle ✓/−
  Amazon RDS for SQL Server ✓/−
  Amazon Redshift ✓/−
  DB2 ✓/−
  Drill ✓/−
  Google BigQuery ✓/−
  Greenplum ✓/−
  HBase ✓/−
  Hive ✓/− ✓/−
  Apache Impala ✓/−
  Informix ✓/✓
  MariaDB ✓/−
  Microsoft Access ✓/✓
  MySQL ✓/−
  Netezza ✓/−
  Oracle ✓/✓
  Phoenix ✓/−
  PostgreSQL ✓/−
  Presto (Preview) ✓/−
  SAP Business Warehouse Open Hub ✓/−
  SAP Business Warehouse via MDX ✓/−
  SAP HANA ✓/✓
  SAP Table ✓/−
  Snowflake ✓/✓ ✓/✓
  Spark ✓/−
  SQL Server ✓/✓ ✓/✓ Use Managed VNET
  Sybase ✓/−
  Teradata ✓/−
  Vertica ✓/−
NoSQL Cassandra ✓/−
  Couchbase (Preview) ✓/−
  MongoDB ✓/✓
  MongoDB Atlas ✓/✓
File Amazon S3 ✓/− ✓/−
  Amazon S3 Compatible Storage ✓/−
  File System ✓/✓
  FTP ✓/−
  Google Cloud Storage ✓/−
  HDFS ✓/−
  Oracle Cloud Storage ✓/−
  SFTP ✓/✓
Generic protocol Generic HTTP ✓/−
  Generic OData ✓/−
  Generic ODBC ✓/✓
  Generic REST ✓/✓ ✓/✓
Services and apps Amazon Marketplace Web Service ✓/−
  Concur (Preview) ✓/−
  Dataverse ✓/✓
  Dynamics 365 ✓/✓
  Dynamics AX ✓/−
  Dynamics CRM ✓/✓
  GitHub For Common Data Model entity reference
  Google AdWords ✓/−
  HubSpot (Preview) ✓/−
  Jira ✓/−
  Magento (Preview) ✓/−
  Marketo (Preview) ✓/−
  Microsoft 365 ✓/−
  Oracle Eloqua (Preview) ✓/−
  Oracle Responsys (Preview) ✓/−
  Oracle Service Cloud (Preview) ✓/−
  PayPal (Preview) ✓/−
  QuickBooks (Preview) ✓/−
  Salesforce ✓/✓
  Salesforce Service Cloud ✓/✓
  Salesforce Marketing Cloud ✓/−
  SAP Cloud for Customer (C4C) ✓/✓
  SAP ECC ✓/−
  ServiceNow ✓/−
SharePoint Online List ✓/−
  Shopify (Preview) ✓/−
  Square (Preview) ✓/−
  Web Table (HTML table) ✓/−
  Xero ✓/−
  Zoho (Preview) ✓/−

Note

Any connector marked as Preview means that you can try it out and give us feedback. If you want to take a dependency on preview connectors in your solution, please contact Azure support.

Integrate with more data stores

Azure Data Factory and Synapse pipelines can reach broader set of data stores than the list mentioned above. If you need to move data to/from a data store that is not in the service built-in connector list, here are some extensible options:

Supported file formats

The following file formats are supported. Refer to each article for format-based settings.

Next steps