ODBC Connector

Back Next

Connect to ODBC

Let's configure the ODBC connection properties to connect to ODBC-compliant databases.

The ODBC connection provides subtypes to connect to a specific database and perform operations. You can use the following ODBC subtype based on the database:

ODBC Subtype	Description
Azure DW	Select Azure DW to enable SQL ELT optimization when you read from or write to Microsoft Azure SQL Data Warehouse.
DB2	Select DB2 to read from or write to DB2. You can also enable SQL ELT optimization when you read from or write to DB2. If you select DB2, the Authentication Mode property appears from which you can use Kerberos authentication to connect to DB2 databases. For more information about how to configure Kerberos authentication, see Prepare for Kerberos authentication.
Google BigQuery	Select Google BigQuery to enable SQL ELT optimization when you read from or write to Google BigQuery.
PostgreSQL	Select PostgreSQL to enable SQL ELT optimization when you read from or write to PostgreSQL.
Redshift	Select Redshift to enable SQL ELT optimization when you read from or write to Amazon Redshift.
SAP IQ	Select SAP IQ to read data from the SAP IQ database.
SAP Sybase ASE	Select SAP Sybase ASE to read from or write to Sybase ASE databases. If you select SAP Sybase ASE, the Authentication Mode property appears from which you can use Kerberos authentication to connect to Sybase ASE databases. For more information about how to configure Kerberos authentication, see Prepare for Kerberos authentication.
Snowflake	Select Snowflake to enable SQL ELT optimization when you read from or write to Snowflake.
Teradata	Select Teradata to enable SQL ELT optimization when you read from or write data to Teradata. You can also enable SQL transformation in a mapping to call a stored procedure in Teradata or to process SQL saved queries against the Teradata database. If you want to use an SSL-enabled ODBC Teradata connection, ensure that the SSL Mode option under WebSocket is set to an appropriate value while configuring the Teradata ODBC driver.
Other	Select Other to enable SQL ELT optimization when you read from or write to Microsoft Access, Microsoft Excel, or Netezza.