Microsoft Azure Synapse SQL Connector

Back Next

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.