ODBC Connector

Back Next

Connect to ODBC

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

You can use the ODBC connection to connect to any ODBC-compliant endpoint. However, the connection also provides you with ODBC subtypes to connect to specific endpoints. The subtype defines the additional capabilities that you can configure in the connection or the mapping when you connect to the endpoint to read from or write data.

See the following table for the ODBC subtypes and the defined functionalities:

ODBC Subtype	Endpoint	Functionality
Azure DW	Microsoft Azure SQL Data Warehouse	Enable SQL ELT optimization in mappings for read and write operations.
DB2	DB2 databases	Enable SQL ELT optimization in mappings for read and write operations. Call a stored procedure using an SQL transformation. Use Kerberos authentication to connect to DB2.
Google BigQuery	Google BigQuery	Enable SQL ELT optimization in mappings for read and write operations.
PostgreSQL	PostgreSQL	Enable SQL ELT optimization in mappings for read and write operations.
Redshift	Amazon Redshift	Enable SQL ELT optimization in mappings for read and write operations.
SAP IQ	SAP IQ database	Read data from the SAP IQ database.
SAP Sybase ASE	Sybase ASE databases	Read from or write to Sybase ASE databases. Use Kerberos authentication to connect to SAP Sybase ASE.
Snowflake	Snowflake	Enable SQL ELT optimization in mappings for read and write operations.
Teradata	Teradata	Read from and write to a Teradata database. Enable SQL ELT optimization in mappings for read and write operations. Call a stored procedure using an SQL transformation. Run SQL queries in Teradata using saved queries from an SQL transformation. If you want to use an SSL-enabled ODBC Teradata connection, ensure that you set an appropriate value for the SSL Mode option under WebSocket while configuring the Teradata ODBC driver.
Other	Microsoft Access, Microsoft Excel, and Netezza	Enable SQL ELT optimization in mappings for read and write operations on the Microsoft Access, Microsoft Excel, or Netezza endpoint. You can also use the Other subtype to connect to any ODBC-compliant endpoint to read or write data.