macOS DSN Configuration
This section shows how to set up ODBC connectivity and configure DSNs on macOS.
Minimum macOS Version
The CData ODBC Driver for WooCommerce 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 WooCommerce/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 WooCommerce
In order to connect to WooCommerce, you also must specify the URL of the instance to connect to.
- Url - Set this to the base URL of the WooCommerce instance to connect to. For Example : Url=http://localhost/woocommerce/;
Authenticate to WooCommerce
WooCommerce supports the following authentication methods: Basic Authentication, one-legged OAuth1.0 Authentication and standard OAuth2.0 Authentication.
Basic
Some plugins and some servers may interfere with the Authorization header, if not configured properly.
For these cases, Basic authentication may be used. In this authentication mode, the user provides the consumer_key and the consumer_secret as user and password respectively.
These credentials are then sent as query parameters with each request.
Specify the following properties:
- AuthScheme - Set this to Basic.
- User - Set this to your consumer key
- Password - Set this to your consumer secret
One-legged OAuth 1.0
Specify the following properties (NOTE: the below credentials are generated from WooCommerce settings page and should not be confused with the credentials generated by using WooCommerce OAuth2.0 plugin):
- AuthScheme - Set this to OAuthOneLegged.
- ConsumerKey
- ConsumerSecret
OAuth 2.0
After having configured the OAuth2 Plugin plugin, you may connect to WooCommerce by providing the following connection proeprties:
- AuthScheme - Set this to OAuth.
- OAuthClientId
- OAuthClientSecret
- CallbackURL
- InitiateOAuth - Set this to either GETANDREFRESH or REFRESH
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 WooCommerce" sudo ./uninstall.sh
Note: The script needs to be run from the installation directory.