Move your data into HANA
Supported syncing
| Sync Type | Description | Supported Sync Modes |
|---|---|---|
| Any data set | Sync data from any source to a HANA table | Upsert |
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,INSERTandDELETErows from the destination table.- Create a local temporary table
- Perform select operations on system tables:
SCHEMASTABLESTABLE_COLUMNSCONSTRAINTS
Tips and troubleshooting
Common errors
If you encounter an error or question not listed below and need assistance, don't hesitate to . We're here to help.
Live debugger
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.
Sync alerts
Hightouch can alert you of sync issues via Slack, PagerDuty, SMS, or email. For details, please visit our article on alerting.