This section shows how to set up ODBC connectivity and configure DSNs on macOS.

Minimum macOS Version

The CData ODBC Driver for Zendesk driver requires macOS Sierra (10.12) or above.

Licensing the Driver

In a terminal, run the following commands to license the driver. To activate a trial, omit the <key> input.

cd "/Applications/CData ODBC Driver for Zendesk/bin"
sudo ./install-license.sh <key>

You'll be prompted for a name and password. These refer to your name and your machine's password.

Connecting to Zendesk

To connect, set the URL and provide authentication. The URL is your Zendesk Support URL: https://{subdomain}.zendesk.com.

Authenticating to Zendesk

Zendesk uses Basic authentication or the OAuth 2 authentication standard.

To authenticate to Zendesk, you can use either Basic authentication or the OAuth standard. Use Basic to connect to your own data. Use OAuth to allow other users to connect to their data.

Basic

To use Basic authentication, specify your email address and password or your email address and an API token. Set User to your email address and follow the steps below to provide the Password or ApiToken.

1. Enable password access in the Zendesk Support admin interface at Admin > Channels > API. Set AuthScheme to Basic while using APIToken Authentication.
2. Manage API tokens in the Zendesk Support Admin interface at Admin > Channels > API. More than one token can be active at the same time. Deleting a token deactivates it permanently.

OAuth

OAuth requires the authenticating user to interact with Zendesk using the browser. Set AuthScheme to OAuth while using OAuth Authentication.

NOTE: By using UseIncrementalAPI property we can get the archived data for TicketMetrics table.

Uninstalling the Driver

The easiest way to uninstall the driver is to open a terminal and run the included uninstall.sh script, located in the installation directory. For example:

cd "/Applications/CData ODBC Driver for Zendesk"
sudo ./uninstall.sh

Note: The script needs to be run from the installation directory.