The ODBC connection supports Source SQL ELT optimization when you use the Netezza ODBC driver in a mapping.
When the Secure Agent applies source SQL ELT optimization, it analyzes the mapping from source to target or until it reaches a downstream transformation it cannot push to the source database.
The Secure Agent generates and executes a SELECT statement based on the transformation logic for each transformation it can push to the database. Then, it reads the results of this SQL query and processes the remaining transformations.
You can configure a mapping to use source SQL ELT optimization if the source and target reside in different databases. For example, if a mapping contains a Netezza source and a Netezza target, you can configure source SQL ELT optimization to push some transformation logic for processing to the Netezza source.
You can configure source SQL ELT optimization in the SQL ELT Optimization section on the Runtime Options tab of the mapping task.