Preparations
To let Emarsys access your database, do the following on your database host:
- Add the IP address
185.4.123.112(Emarsys) to the relevant allowlist. - Grant the SELECT privilege to the user for the used schema.
Setting up the connection
- Go to Add-ons → Relational Data → Connections on the Emarsys platform.
- Click Create SAP Hana Cloud connection to set up a connection of this type.
- Enter the details for a single or multiple connections to create.
All fields are case-sensitive!-
Instance ID: This is the ID of the instance that you want us to connect to. The ID contains 36 character digits, the word hana, subaccount name and an indication of where the database is hosted. You can find this in the Database overview in SAP Hana in the Host field. No need to copy the
.hanacloud.ondemand.comsection, this part is automatically added to all IDs. An example of what to copy:5c30262b-2a57-46af-a535-27a0d88a2dc1.hana.trial-eu10. - User name: login name for the HANA user for this connection.
-
Password: password for the HANA user for this connection.
Fields marked with an asterisk (*) on the interface are mandatory.
-
Instance ID: This is the ID of the instance that you want us to connect to. The ID contains 36 character digits, the word hana, subaccount name and an indication of where the database is hosted. You can find this in the Database overview in SAP Hana in the Host field. No need to copy the
- When you finished adding all the necessary data, Test your connection.
- Click Save to create the connector you just set up.
- Once successfully saved, verify that Emarsys can access the right tables and views using the provided user by navigating to the Tables & Views tab.
This Relational Data connector will only connect to the underlying HANA database, giving access to the source data that is used by S4 to generate the views. This connector does not support virtual views such as CDS, meaning that the data visible in S4 would not be accessible via this connector.