ODBC Connector > Pushdown optimization > Working with databases
  

Working with databases

You can configure pushdown optimization for the following databases when you use the ODBC connection in the mapping:
You need to select the appropriate ODBC subtype to connect to a database in the ODBC connection properties.
The following table provides the ODBC subtype that you must select in the ODBC connection to connect to a specific database:
Supported database
ODBC Sub-type
Amazon Redshift
Redshift
Google BigQuery
Google BigQuery
Microsoft Azure SQL Data Warehouse
Azure DW
PostgreSQL
PostgreSQL
Snowflake
Snowflake
Data warehouses such as Netezza and Teradata1
Other
1 If you connect to Netezza or Teradata from Linux, you must select Data Direct as the Driver Manager for Linux in the ODBC connection properties.