Table of Contents

Search

  1. Preface
  2. Introduction to Microsoft SQL Server Connector
  3. Connections for Microsoft SQL Server
  4. Synchronization tasks with Microsoft SQL Server Connector
  5. Mappings and mapping tasks with Microsoft SQL Server Connector
  6. Replication tasks with Microsoft SQL Server
  7. Data type reference

Microsoft SQL Server Connector

Microsoft SQL Server Connector

Full SQL ELT optimization

Full
SQL ELT optimization

When the Secure Agent applies full
SQL ELT optimization
, it pushes all the transformation logic in the mapping to the target database.
You can configure full
SQL ELT optimization
in the
SQL ELT Optimization
section.
Full
SQL ELT optimization
is ideal when the source and target are in the same connections. For example, if a mapping contains a Microsoft SQL Server source and a Microsoft SQL Server target, configure full
SQL ELT optimization
to push all the transformation logic for processing from a Microsoft SQL Server source database to a Microsoft SQL Server target database.

0 COMMENTS

We’d like to hear from you!