When you use an ODBC connection, you can configure

SQL ELT optimization

to push transformation logic to PostgreSQL source

or target

databases. Use

SQL ELT optimization

when you use database resources to improve the performance of the task.

When you run a task configured for

SQL ELT optimization

, the task converts the transformation logic to an SQL query. The task sends the query to the database, and the database executes the query.

You cannot configure

SQL ELT optimization

for a mapping in advanced mode.

PostgreSQL Connector supports Full and Source

SQL ELT optimization

for the ODBC connection type that uses PostgreSQL ODBC drivers.