Go to the Destinations overview page and click the Add destination button. Select SAP HANA and click Continue. If you're not using a tunnel, you can then authenticate Hightouch to SAP HANA by entering the following fields:
Host: The hostname or IP address of your SAP HANA server. You don't need to include the https://.
Port: The port number of your SAP HANA server.
User: The user that has access through Hightouch to the database and tables you want to sync to.
Password: The password for the user specified above.
To ensure your credentials are correct, click Test connection. This confirms if Hightouch can connect to your database by running a basic SELECT query.
Hightouch requires a unique identifier in the destination HANA table to add, remove, and update rows. The column must be either a UNIQUE or PRIMARY KEY column. At least one Hightouch field must map to a unique column.
If you map to an incompatible column, Hightouch will fail the sync with an error message.
Hightouch provides complete visibility into the API calls made during each of your sync runs. We recommend reading our article on debugging tips and tricks to learn more.