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.
The Relational Data HANA Connector will only connect to the HANA database, which means that any views in HANA S4 will need to be recreated in Emarsys. There is currently no CDS support that would enable HANA S4 views to be imported.