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 |
Netezza1 | Other |
PostgreSQL | PostgreSQL |
Snowflake | Snowflake |
Teradata1 | Teradata |
1If you connect to Netezza or Teradata from Linux, you must select Data Direct as the Driver Manager for Linux in the ODBC connection properties. |