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

Minimum macOS Version

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

There are several authentication methods available for connecting to Pipedrive: Basic and OAuth.

Basic

Begin by obtaining an API token:

1. Click on the the account name (on the top right) on PipeDrive.
2. Click on Company Settings, Then Click on Personal Preferences -> API -> Generate Token.
3. Note the API token.
4. Note the CompanyDomain ,which is visible in the PipeDrive HomePage URL.

Set the following to authenticate to Pipedrive

• APIToken: Set to the noted API token.
• CompanyDomain: Set to the noted company domain from the developer sandbox URL.
• AuthScheme: Set to 'Basic'.

to your login credentials. The API Token can be found in PipeDrive by going to account name (on the top right) >Company settings > Personal preferences > API.

OAuth

If you do not have access to the user name and password or do not want to require them, use the OAuth user consent flow. See Using OAuth Authentication for an authentication guide.

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

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