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

Minimum macOS Version

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

Mailchimp supports the following authentication methods:

• APIKey
• OAuth

API Key

The easiest way to connect to Mailchimp is to use the API Key. The APIKey grants full access to your Mailchimp account. To obtain the APIKey, log into Mailchimp and click Account -> Extras -> API Keys. You can then set the connection property APIKey to this value.

• AuthScheme: Set this to APIKey.

OAuth

An alternative method to authenticate to Mailchimp is using OAuth standard. OAuth can be used to enable other users to access their own data. To authenticate using OAuth, you need to obtain the OAuthClientId, OAuthClientSecret, and CallbackURL by registering an app with Mailchimp. OAuth requires the authenticating user to interact with Mailchimp using the browser.

• AuthScheme: Set this to OAuth.

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

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