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

Minimum macOS Version

The CData ODBC Driver for Sage 200 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 Sage 200/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 Sage 200

Before connecting, you must ensure that your account is registered for Sage API access. You can easily do this by following this link: https://developer.columbus.sage.com/docs/services/api/uk/subscribe.
You will need to select a subscription that contains the API of your Sage 200 edition (StandardUK or ProfessionalUK). The Sage 200 Unlimited subscription should contain the APIs of both editions.

To connect to Sage 200, specify the following connection properties:

• Schema: Determines which Sage 200 edition you are connecting to. Specify either StandardUK or ProfessionalUK.
• SubscriptionKey: After subscribing to the API, you can find the subscription key in your profile after logging into Sage 200.

Authenticating to Sage 200

Sage 200 uses the OAuth authentication standard. See Using OAuth Authentication for an authentication guide.

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 Sage 200"
sudo ./uninstall.sh

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