The ODBC connection supports Source SQL ELT optimization when you use the Netezza ODBC driver in a mapping.
You can configure full SQL ELT optimization only when the source and target are in the same database.
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 on the Runtime Options tab of the mapping task.
Full SQL ELT optimization is ideal when the source and target are in the same connections. For example, if a mapping contains a Netezza source and a Netezza target, configure full SQL ELT optimization to push all the transformation logic for processing from a Netezza source database to a Netezza target database.