Microsoft Azure Synapse SQL Connector > SQL ELT optimization > SQL ELT optimization scenarios
  

SQL ELT optimization scenarios

You can configure SQL ELT optimization using the Microsoft Azure Synapse SQL Connector in mappings .
You can use configure SQL ELT optimization for the following scenarios:
Source and target endpoints
Supported SQL ELT scenarios in mappings
Microsoft Azure Synapse SQL source
Microsoft Azure Synapse SQL target
Reads from and writes to Microsoft Azure Synapse SQL using the Microsoft Azure Synapse SQL connection.
SQL ELT optimization type is Source or Full.
Microsoft Azure Data Lake Storage Gen2 source
Microsoft Azure Synapse SQL target
Reads from Microsoft Azure Data Lake Storage Gen2 using a Microsoft Azure Data Lake Storage Gen2 connection and writes to Microsoft Azure Synapse SQL using a Microsoft Azure Synapse SQL connection.
SQL ELT optimization type is Full.