Microsoft Azure Synapse SQL Connector > Mappings and mapping tasks with Microsoft Azure Synapse SQL > Microsoft Azure Synapse SQL mappings overview

Microsoft Azure Synapse SQL mappings overview

Use a mapping to define data flow logic, such as specific ordering of logic or joining sources from different systems. Use the Data Integration Mapping Designer to configure mappings.
When you configure a mapping to describe the flow of data from source and target, you can also add transformations to transform data. A transformation includes field rules to define incoming fields. Links visually represent how data moves through the data flow.
After you create a mapping, you can run the mapping or you can deploy the mapping in a mapping task. The mapping task allows you to process data based on the data flow logic defined in a mapping.
Use the Mapping task wizard to create a mapping task. When you create a mapping task, you select the mapping for the task to use.
If you configured parameters, which are placeholders for information, in a mapping, you can define the parameters in the mapping task. Defining parameters provides additional flexibility and allows you to use the same mapping in multiple mapping tasks. For example, you can use a parameter for a source connection in a mapping, and then define the source connection when you configure the mapping task. You cannot use a parameter file if the mapping task is based on an elastic mapping.
When you create a mapping task, you can associate the task with a schedule to run it at specified times or on regular intervals. Or, you can run it manually. You can also configure advanced session properties. You can monitor tasks that are currently running in the activity monitor and view details about completed tasks in the activity log.