SAP S/4 Setup Guide PRIVATE PREVIEW
Follow our setup guide to connect SAP S/4 to Fivetran.
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,
SYSTEM/Rootuser with permissions to grant DDL and DML access (for example,
- 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.
Create a schema
Create a new schema
FIVETRAN_DB, by executing the
CREATE SCHEMA "FIVETRAN_DB" command.
Create a user in SAP
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.
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_DBschema. Execute the following command as
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.
- 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 configuration
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.