Table of Contents

Search

  1. Preface
  2. Introduction to ODBC Connector
  3. Connections for ODBC
  4. Synchronization tasks with ODBC Connector
  5. Mappings and mapping tasks with ODBC Connector
  6. SQL ELT optimization
  7. Data type reference

ODBC Connector

ODBC Connector

Configure the ODBC driver

Configure the ODBC driver

To use an ODBC connection, you'll need to set up a system Data Source Name (DSN) for the database or data warehouse-specific ODBC driver, and then install the ODBC driver and ODBC client on the Secure Agent machine.
An ODBC client can access any database and data warehouse for which you install an ODBC driver. Ensure that the ODBC driver you install complies with the ODBC-compliant endpoint to which you want to connect.
An ODBC connection uses only the system DSN. You can't use the user DSN when you configure an ODBC driver. When you set up the system DSN, you need to specify the data source name and connection string.
This section provides instructions to configure the ODBC driver on Windows and Linux machines that host the Secure Agent. You can use these instructions to set up your endpoint-specific ODBC driver. In certain cases, you might need to set environment variables after the driver configuration. You can refer to the examples to help you set up your driver.

0 COMMENTS

We’d like to hear from you!