SAP HANA Setup Guide In Dev

Follow our setup guide to connect SAP HANA to Fivetran.

Prerequisites

To connect your SAP HANA account to Fivetran, you need:

• SAP HANA
• SAP HANA Schema (Database) name that you want to connect with
• A Fivetran-specific schema (for example, FIVETRAN_DB)
• A Fivetran-specific SAP HANA user with read and write permissions
• Password for the user you are using to connect
• IP (for example, 172.16.254.2) or host (for example, your.server.com)
• Port (for example, 30215)

  NOTE: Read SAP's Connections for Multitenant Database Containers documentation to identify the port in multitenant database containers.

• Allow Fivetran's IPs direct access to your SAP HANA database

  NOTE: To connect using SSH tunnel, see our SSH connection documentation.

Setup instructions

Create schema

1. Log in to your SAP HANA database as an Administrator.

2. Create a new schema FIVETRAN_DB, by executing the following command:

   CREATE SCHEMA "FIVETRAN_DB"
   

Create user in SAP

1. Create a new user by executing the following command:

   CREATE USER <USERNAME> PASSWORD <PASSWORD>;
   

Assign permissions

Follow these steps to assign Read, Data Definition Language (DDL), and DML access to the user:

1. Grant DDL, DML, and DQL access to the newly created user for the FIVETRAN_DB schema. Execute the following command as SYSTEM/Root user:

   GRANT CREATE ANY ON SCHEMA FIVETRAN_DB TO <USERNAME>;
   GRANT SELECT ON SCHEMA FIVETRAN_DB TO <USERNAME>;
   GRANT INSERT ON SCHEMA FIVETRAN_DB TO <USERNAME>;
   GRANT UPDATE ON SCHEMA FIVETRAN_DB TO <USERNAME>;
   GRANT DELETE ON SCHEMA FIVETRAN_DB TO <USERNAME>;
   

2. Grant permission to create triggers for the new user in YOUR_SCHEMA. Execute the following command:

   GRANT SELECT, TRIGGER ON SCHEMA <YOUR_SCHEMA> TO <USERNAME>
   

   NOTE: YOUR_SCHEMA is the SAP HANA Schema (Database) name that you want to connect.

Read SAP HANA SQL and System Views Reference documentation for more information.

Finish Fivetran configuration

1. In the connector setup form, enter the Destination schema name of your choice.

2. Enter the Host name or the IP address of the database server.

3. Enter the Port number.

4. Enter the User name you created in Step 2.

5. Enter the Password.

6. Enter the Database name.

7. Choose your Connection method. You can choose to Connect directly or Connect via an SSH tunnel. If you choose Connect via an SSH tunnel, copy or make a note of the Public Key and add it to the authorized_keys file while configuring the SSH tunnel, and provide the following information:

   • SSH Host
   • SSH Port
   • SSH User

8. (Optional) Enter the testTableName of your choice.

9. Click Save & Test. Fivetran will take it from here and sync your data from your SAP HANA database.

Setup tests

Fivetran performs the following tests to ensure that we can connect to your SAP HANA database and that it is properly configured:

• The Connecting to Host Test validates the database credentials you provided in the setup form. It then verifies that the database host is not private and checks that we can connect to the host.
• The Connecting to Database Test checks that we can access your database.
• The Validating Fivetran Schema Test checks that you created a new schema FIVETRAN_DB.
• The Checking Access to Schema Test checks that we have the correct permissions to access the schemas in your database. It then verifies that your database contains at least one table.

Related articles

description Connector Overview

account_tree Schema Information

settings API Connector Configuration

home Documentation Home