SAP S/4 Setup Guide BETAlink
Follow our setup guide to connect SAP S/4 to Fivetran.
Prerequisiteslink
To connect your SAP S/4 account to Fivetran, you need:
- SAP S/4 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)
Read SAP's Connections for Multitenant Database Containers documentation to identify the port in multitenant database containers.
- Access to your SAP HANA using Fivetran's IPs
To connect using SSH tunnel, see our SSH connection documentation.
Setup instructionslink
Create a schemalink
Create a new schema FIVETRAN_DB
, by executing the CREATE SCHEMA "FIVETRAN_DB"
command.
Create a user in SAPlink
Follow these steps to create a new user:
-
Log in to SAP HANA Studio as an Administrator.
-
In the left panel, select System > Security > Users.
-
Right-click Users and then click New User.
-
In the User tab, enter the User name of your choice.
-
Uncheck the Disable ODBC/JDBC access option.
-
In the Authentication section, select Password as the authentication mechanism.
-
Enter the password and then confirm your password.
-
In the Force password change on next logon: option, select No.
-
Click Deploy.
Assign permissionslink
Follow these steps to assign Read, Data Definition Language (DDL), and DML access to the user:
-
In Granted Roles tab, click +.
-
In the Select Roles window, select ABAP_READ and then click OK.
-
Click Deploy to assign a role to the user.
-
Grant DDL and DML access to newly created user for the
FIVETRAN_DB
schema. Execute the following command asSYSTEM/Root
user,GRANT ALL PRIVILEGES ON SCHEMA FIVETRAN_DB TO "NEW USER"
. -
Grant permission to create triggers for the new user in
YOUR_SCHEMA
. Execute the following command,GRANT TRIGGER ON SCHEMA YOUR_SCHEMA TO "NEW USER"
.
Read SAP HANA SQL and System Views Reference documentation for more information.
Reset passwordlink
- In the User tab, enter a new password for the user you created in Step 2.
- In the Force password change on next logon: option, select No.
- Click Deploy.
Finish Fivetran configurationlink
-
In the connector setup form, enter the Destination schema name of your choice.
-
Enter the Host name.
-
Enter the Port number.
-
Enter your User Name.
-
Enter the Password.
-
Enter the SAP HANA Database name.
-
Enter the Test Table name of your choice.
-
Select your Connection Method. You can Connect directly or Connect using a SSH tunnel.
-
Click Save & Test. Fivetran will take it from here and sync your data from your SAP account.