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 and mappings in advanced mode.
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.
Source SQL ELT optimization is not applicable to mappings in advanced mode.
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.
Doesn't apply to mappings in advanced mode.
Note: You can use the Secure Agent or the Hosted Agent to run mappings enabled with SQL ELT optimization.