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

Minimum macOS Version

The CData ODBC Driver for Exact Online 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 Exact Online/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.

OAuth

You can connect without setting any connection properties for your user credentials.

After setting the following connection properties, you are ready to connect:

• Region: Set to the region of the Exact Online service you want to connect to.
• Division: Set to the division of the Exact Online administration.

When you connect, the driver opens the Exact Online OAuth endpoint in your default browser. Log in and grant permissions to the driver. The driver then completes the OAuth process.

See Using OAuth Authentication for other OAuth authentication flows.

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 Exact Online"
sudo ./uninstall.sh

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