ODBC Connector

Back Next

Working with databases

You can configure

SQL ELT optimization

for the following databases when you use the ODBC connection in the mapping:

Amazon Redshift

DB2

Google BigQuery

Microsoft Azure SQL Data Warehouse

Netezza

PostgreSQL

Snowflake

Teradata

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 Subtype
Amazon Redshift	Redshift
DB2	DB2
Google BigQuery	Google BigQuery
Microsoft Azure SQL Data Warehouse	Azure DW
Netezza¹	Other
PostgreSQL	PostgreSQL
Snowflake	Snowflake
Teradata¹	Teradata
¹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.