When you use

SQL ELT optimization

, the Secure Agent converts the expression in the transformation by determining equivalent operators in the database. If there is no equivalent operator, the Secure Agent processes the transformation logic.

The following table summarizes the availability of SQL ELT operators when you configure

SQL ELT optimization

for a mapping that contains a

Microsoft Azure Synapse SQL

connection.