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

Minimum macOS Version

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

Note: For now, only connecting to self hosted wordpress instances is supported by CData ODBC Driver for WordPress.

To connect to data, set the Url and provide authentication. You must set the URL to your wordpress site, otherwise an error will be thrown indicating that the site was not found.
For example, if your site is hosted in 'http://localhost/wp/wordpress', the URL should be 'http://localhost/wp/wordpress' and not 'htpp://localhost' .

Authenticating to WordPress

WordPress uses Basic or OAuth2.0 authentication.

Basic

Basic authentication is recommended for a testing environment only.

Configure Access to WordPress

1. Go to your WordPress host and login with your admin credentials when prompted.
2. Make sure your WordPress supports the REST API. Wordpress 4.7 and later support it natively, earlier versions will need to install the REST API plugin.
3. Install an authentication plugin such as Basic Authentication to secure access to the REST API.

4. To create custom taxonomies, you need to install the Simple Taxonomy Refreshed
   

   Alternatively, to install the plugins manually, extract the compressed folders to the wp-content\plugins folder and then enable the plugins via the WordPress admin interface.

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

• AuthScheme Set this to Basic.
• Url: Set this to your WordPress URL.
• User: Set this to your username.
• Password: Set this to your password.

OAuth 2.0

You can use OAuth to authenticate with WordPress.OAuth requires the authenticating user to interact with WordPress using the browser. Set AuthScheme to OAuth while using OAuth Authentication.

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

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