For Emarsys to successfully access your database, it needs to be configured as follows:

• Grant SELECT and OPTIMIZER_ADMIN privileges to the user for the used schema.
• Add the following IP addresses to the relevant allowlist: 34.89.173.3, 34.89.137.140, 35.246.249.205, 185.4.123.112

The first step in using Relational Data is to set up the connection between your database and Emarsys.

1. In the Emarsys platform, go to Add-ons > Relational Data > Connections.

1. In the top right corner in Connections, click Create New Connection.
2. Select SAP HANA Cloud.
3. Configure your connection as follows:

• Connection Name: the reference you want to give to your connection, can be the same as the DB name.

• 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. There is no need to copy the .hanacloud.ondemand.com section, 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 you want to use for this connection.
• Password: password for the HANA user you want to use for this connection.
• Schema (optional): the database schema you want to use, leave empty to use the default schema.
• Connection parameters (optional): specify additional Java DataBase Connectivity (JDBC) (version 2.1) connection parameters you would like to use when establishing the connection, or leave it empty to use default parameters.

4. When you finished adding all the necessary data, Test your connection.
5. Click Save to create the connector you just set up

You are done and can now either:

• Create Relational Data segment templates
• Define Relational Data reference fields