#Activity diagram data store driver#

You can use the Copy activity to copy files as-is between two file-based data stores, in which case the data is copied efficiently without any serialization or deserialization. Refer to each article for format-based settings. Supported file formatsĪzure Data Factory supports the following file formats. If you want to take a dependency on preview connectors in your solution, contact Azure support.

If a connector is marked Preview, you can try it out and give us feedback.

#Activity diagram data store driver#

Sink supported only with the ODBC Connector and the SAP HANA ODBC driver Supported data stores and formats Category In case if a self-hosted integration runtime is used in either source or sink data store within a copy activity, than both the source and sink must be accessible from the server hosting the integartion runtime for the copy activity to be successful.

Writes data to the sink/destination data store.

It performs these operations based on the configuration of the input dataset, output dataset, and Copy activity.

Performs serialization/deserialization, compression/decompression, column mapping, and so on.

To copy data from a source to a sink, the service that runs the Copy activity performs these steps: For information about how the Copy activity determines which integration runtime to use, see Determining which IR to use.

When you're copying data to and from data stores that are located on-premises or in a network with access control (for example, an Azure virtual network), you need to set up a self-hosted integration runtime.Īn integration runtime needs to be associated with each source and sink data store.

This integration runtime is secure, reliable, scalable, and globally available.

When you're copying data between two data stores that are publicly accessible through the internet from any IP, you can use the Azure integration runtime for the copy activity.

You can use different types of integration runtimes for different data copy scenarios: The Copy activity is executed on an integration runtime. You can also use the Copy activity to publish transformation and analysis results for business intelligence (BI) and application consumption. After you copy the data, you can use other activities to further transform and analyze it. In Azure Data Factory and Synapse pipelines, you can use the Copy activity to copy data among data stores located on-premises and in the cloud.