Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
Azure Data Factory and Azure Synapse Analytics connector overview
APPLIES TO: 👁 Image
Azure Data Factory 👁 Image
Azure Synapse Analytics
Tip
Data Factory in Microsoft Fabric is the next generation of Azure Data Factory, with a simpler architecture, built-in AI, and new features. If you're new to data integration, start with Fabric Data Factory. Existing ADF workloads can upgrade to Fabric to access new capabilities across data science, real-time analytics, and reporting.
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. Select each data store to learn the supported capabilities and the corresponding configurations in details.
Supported data stores
Note
Connectors marked Preview are available to try, but are not recommended for production workloads. Certain features might not be supported or might have constrained capabilities.
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 isn't in the service built-in connector list, here are some extensible options:
- For database and data warehouse, usually you can find a corresponding ODBC driver, with which you can use generic ODBC connector.
- For SaaS applications:
- If it provides RESTful APIs, you can use generic REST connector.
- If it has OData feed, you can use generic OData connector.
- If it provides SOAP APIs, you can use generic HTTP connector.
- If it has ODBC driver, you can use generic ODBC connector.
- For others, check if you can load data to or expose data as any supported data stores, for example, Azure Blob/File/FTP/SFTP/etc, then let the service pick up from there. You can invoke custom data loading mechanism via Azure Function, Custom activity, Databricks/HDInsight, Web activity, etc.
Supported file formats
The following file formats are supported. Refer to each article for format-based settings.
- Avro format
- Binary format
- Common Data Model format
- Delimited text format
- Delta format
- Excel format
- Iceberg format
- JSON format
- ORC format
- Parquet format
- XML format
Support TLS 1.3
Transport Layer Security (TLS) is a widely adopted security protocol that's designed to secure connections and communications between servers and clients. In Azure App Service, you can use TLS and Secure Sockets Layer (SSL) certificates to help secure incoming requests in your web apps. TLS 1.3 is the latest and most secure version. For more information, see this article. The following connectors support TLS 1.3 for Copy activity:
- Amazon RDS for SQL Server (version 2.0)
- Azure Data Explorer
- Azure Database for PostgreSQL (version 2.0)
- Azure File Storage
- Azure SQL Database (version 2.0)
- Azure SQL Managed Instance (version 2.0)
- Azure Synapse Analytics (version 2.0)
- Azure Table Storage
- DB2
- Oracle (version 2.0)
- PostgreSQL V2
- Snowflake V2
- SQL Server (version 2.0)
Related content
Feedback
Was this page helpful?