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 Microsoft Dynamics GP 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 Microsoft Dynamics GP/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 Microsoft Dynamics GP
To connect set URL to the Web services endpoint; for example, http://{servername}:{port}/Dynamics/GPService. Additionally, set CompanyId to the unique identifier of the company you are connecting to. You can obtain this value by querying the Company table and leaving the property empty.
Authenticating to Microsoft Dynamics GP
The Microsoft Dynamics GP data source supports the following authentication methods:
- Anonymous Authentication
- WS-Security (WSS) Authentication
- Basic Authentication
- NTLM User Authentication
- Digest
- Negotiate (Kerberos)
Anonymous Authentication
In some situations, you can connect to Microsoft Dynamics GP without setting any authentication connection properties. To do so, set the AuthScheme to None, and you are ready to connect.
WS-Security (WSS)
Set the User and Password to connect and set AuthScheme to WSS.
Note: WSS Authentication is the default authentication scheme.
Basic
Set the User and Password to connect and set AuthScheme to Basic.
Windows (NTLM)
Set the Windows User and Password to connect and set AuthScheme to NTLM.
Digest
Set the User and Password to connect and set AuthScheme to Digest.
Kerberos
See Using Kerberos for details on how to authenticate with Kerberos.
Fine Tuning Data Access
The driver returns data summaries by default to save performance. Set LookupIds to true to return details such as line items; however, note that entities must be retrieved one at a time.
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 Microsoft Dynamics GP" sudo ./uninstall.sh
Note: The script needs to be run from the installation directory.