Skip to main content

​
Supported syncing

​
Connect to SAP HANA

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.

​
Record matching

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.

​
Column types

Hightouch works out of the box with all standard column types. If you see type errors, it may be because your SQL query is producing the wrong format. Message us on Intercom if you need help.

​
Required permissions

Your HANA credentials must be able to:
  • MERGE INTO, UPDATE, INSERT and DELETE rows from the destination table.
  • Create a local temporary table
  • Perform select operations on system tables:
    • SCHEMAS
    • TABLES
    • TABLE_COLUMNS
    • CONSTRAINTS

​
Tips and troubleshooting

To see the exact API requests and responses from each sync run, use the live debugger. To get notified by Slack, PagerDuty, SMS, or email when a sync fails, set up sync alerts. If you run into an issue this page doesn’t cover, .
Last modified on February 7, 2024