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

Minimum macOS Version

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

See to connect with the driver's embedded credentials and skip creating a custom OAuth app.

These properties are required when connecting to a company file (both for Cloud and On-Premise instances).

• User: The username associated with your company file.
• CompanyFileId:The ID of the company file. If not specified, the ID of the first returned company file will be used. You can find this by querying the CompanyFiles view:
  

  SELECT Id FROM CompanyFiles

Connecting to an On-Premise instance:

When connecting to an on-premise instance, you will need to set the following connection property in addition to those above:

• Url: The Url of your MYOB instance.
• Password: The password associated with your company file.

Connecting to a Cloud Instance

Establish a connection to MYOB without setting any additional connection properties using the driver's Embedded Credentials.

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

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