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

Minimum macOS Version

The CData ODBC Driver for SAP HANA XSA 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 SAP HANA XSA/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.

SAP HANA XSA uses the OAuth authentication standard. Before connecting, it is necessary to establish an SAP HANA XSA OData Service. See Creating a Custom OAuth App for a guide.

To connect to SAP HANA XSA using the OAuthPassword Grant type set the following:

• OAuthClientId: Set this to the Client Id specified in the UAA service JSON file.
• OAuthClientSecret: Set this to the Client Secret specified in the UAA service JSON file.
• Url: Set this to the OData service endpoint.
• XSUAAURL: Set this to the UAA service url.
• User: Set your accounts username.
• Password: Set your accounts password

Once you've configured the OData Service, you can establish a connection using Custom 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 SAP HANA XSA"
sudo ./uninstall.sh

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