Microsoft Azure Synapse SQL Connector

Back Next

Mappings for Microsoft Azure Synapse SQL

When you configure a mapping, you describe the flow of data from the source to the target.

A mapping defines reusable data flow logic that you can use in mapping tasks.

When you create a mapping, you define the Source, Target, and Lookup transformations to represent a Microsoft Azure Synapse SQL object. Use the Mapping Designer in Data Integration to add the Source, Target, or Lookup transformations in the mapping canvas and configure the Microsoft Azure Synapse SQL source, target, and lookup properties.

In advanced mode, the Mapping Designer updates the mapping canvas to include transformations and functions that enable advanced functionality.

You can use Monitor to monitor the jobs.

Microsoft Azure Synapse SQL sources in mappings

Microsoft Azure Synapse SQL targets in mappings

Microsoft Azure Synapse SQL lookups in mappings

Process SQL queries and stored procedures using an SQL transformation

Dynamic schema handling

IDENTITY column

Parameterization

Rules and guidelines for mappings and mapping tasks

Mappings in advanced mode example

Download Guide