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

Minimum macOS Version

The CData ODBC Driver for Magento 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 Magento/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 Magento 2.x

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 Magento

To authenticate to Magento 2.x 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 Magento.
• Password Set this to your password in Magento.

Access Token

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

To generate the AccessToken, Log in to the Magento 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 Magento"
sudo ./uninstall.sh

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