Microsoft Azure Synapse SQL Connector > Mappings and mapping tasks with Microsoft Azure Synapse SQL > Elastic mapping example
  

Elastic mapping example

You work for an organization that stores large amount of purchase order details, such as customer ID, item codes, and item quantity for all regions in Microsoft Azure Data Lake Storage Gen2. You need to port the data from Microsoft Azure Data Lake Storage Gen2 to Microsoft Azure Synapse SQL to quickly analyze the purchase order details and to increase future revenues.
Create an elastic mapping that runs on the elastic cluster to achieve faster performance when you read all the purchase records from Microsoft Azure Data Lake Storage Gen2 source and write the records to a Microsoft Azure Synapse SQL target.
    1. In Data Integration, click New > Mappings > Elastic Mapping > Create.
    The New Mapping dialog box appears.
    2. Enter a name, location, and description for the mapping.
    3. On the Source transformation, specify a name and description in the general properties.
    4. On the Source tab, perform the following steps to provide the source details to read data from the Microsoft Azure Data Lake Storage Gen2 source:
    1. a. In the Connection field, select the Microsoft Azure Data Lake Storage Gen2 source connection.
    2. b. In the Source Type field, select the type of the source.
    3. c. In the Object field, select the required object.
    4. d. In the Advanced Properties section, provide the appropriate values.
    5. On the Fields tab, map the source fields to the target fields.
    6. On the Target transformation, specify a name and description in the general properties.
    7. On the Target tab, perform the following steps to provide the target details to write data to theMicrosoft Azure Synapse SQL target:
    1. a. In the Connection field, select the Microsoft Azure Synapse SQL target connection.
    2. b. In the Target Type field, select the type of the target.
    3. c. In the Object field, select the required object.
    4. d. In the Operation field, select the required operation.
    5. e. In the Advanced Properties section, provide appropriate values for the advanced target properties.
    8. Map the flat file source and the Microsoft Azure Synapse SQL target.
    9. Click Save > Run to validate the mapping.
    In Monitor, you can monitor the status of the logs after you run the task.

Rules and guidelines for elastic mappings

Consider the following rules and guidelines when you create elastic mappings: