Configuring a Netezza ODBC connection for SQL ELT optimization
Configuring a Netezza ODBC connection for
SQL ELT optimization
You can set the
SQL ELT optimization
for the ODBC connection that uses the Netezza ODBC driver to enhance the mapping performance.
You must first configure the Netezza ODBC drivers and create a Netezza ODBC data source name. Netezza supports Netezza ODBC drivers on Windows and Linux systems.
After you configure the Netezza ODBC DSN, you must create an ODBC connection to connect to Netezza. In the ODBC connection properties, select
ODBC Subtype
as
Other
and the
Driver Manager
as
Data Direct
.
For more information about creating an ODBC connection to connect to Netezza, see the "Creating an ODBC Connection" topic in the help for ODBC Connector.
Use the configured Netezza ODBC connection in a mapping, and select the value of the
ASK INFAPreview
