Search documentation...

K
ChangelogBook a demoSign up

SAP HANA

Move your data into HANA

Supported syncing

Sync TypeDescriptionSupported Sync Modes
Any data setSync data from any source to a HANA tableUpsert

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

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.

Ready to get started?

Jump right in or a book a demo. Your first destination is always free.

Book a demoSign upBook a demo

Need help?

Our team is relentlessly focused on your success. Don't hesitate to reach out!

Feature requests?

We'd love to hear your suggestions for integrations and other features.

Last updated: Feb 7, 2024

On this page

Supported syncingConnect to SAP HANARecord matchingColumn typesRequired permissionsTips and troubleshootingCommon errorsLive debuggerSync alerts

Was this page helpful?