Azure Data Factory connector overview
Azure Data Factory supports 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
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 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 Azure Data Factory 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:
- For others, check if you can load data to or expose data as any ADF supported data stores, e.g. Azure Blob/File/FTP/SFTP/etc, then let ADF pick up from there. You can invoke custom data loading mechanism via Azure Function, Custom activity, Databricks/HDInsight, Web activity, etc.
Supported file formats
Azure Data Factory supports the following file formats. Refer to each article for format-based settings.
- Avro format
- Binary format
- Common Data Model format
- Delimited text format
- Delta format
- Excel format
- JSON format
- ORC format
- Parquet format
- XML format