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

Minimum macOS Version

The CData ODBC Driver for Adobe Commerce 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 Adobe Commerce/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 AdobeCommerce

To connect, set the URL; for example, http://yoursitename/magento2, and optionally provide the StoreCode of the store you are connecting to, if more than one are present.

Authenticating to AdobeCommerce

To authenticate to AdobeCommerce server versions, you can use either the Basic or the Token AuthScheme.

Basic

• AuthScheme Set this to Basic.
• User Set this to your user name in AdobeCommerce.
• Password Set this to your password in AdobeCommerce.

Access Token

• AuthScheme Set this to Token.
• AccessToken Set this to your AccessToken in AdobeCommerce.

To generate the AccessToken, Log in to the AdobeCommerce Stores > Settings > Configuration > Services > OAuth > Access Token.

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 Adobe Commerce"
sudo ./uninstall.sh

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