You can set the

SQL ELT optimization

for the ODBC connection type that uses the PostgreSQL ODBC driver to enhance the mapping performance. To use an ODBC connection to connect to PostgreSQL, you must configure the ODBC connection.

After you create a PostgreSQL ODBC connection, navigate to the

SQL ELT Optimization

section, and then from the

SQL ELT Optimization

list, select

Full

or

To Source

. You cannot configure target-side

SQL ELT optimization

by using PostgreSQL ODBC driver. To verify that the

SQL ELT optimization

has taken place, you can check the session log for the job. In

Monitor

, view the log for jobs.

PostgreSQL supports PostgreSQL ODBC drivers on Windows and Linux systems. You must install the PostgreSQL ODBC 64-bit driver based on your system requirement.