This article helps you connect your externally hosted database and assumes that you have already prepared your database to make it usable. More information on how to prepare your database is available on the Preparing your hosted database for Relational Data page.
Prerequisites
For Emarsys to successfully access your database, it needs to be configured as follows:
- Grant SELECT and SHOWPLAN privileges to the Emarsys user.
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
Setting up the connection
The first step in using Relational Data is to set up the connection between your database and Emarsys.
- In the Emarsys platform, go to Add-ons > Relational Data > Connections.
- In the top right corner in Connections, click Create new Connection.
- Select MsSQL.
- Configure your connection as follows:
To be able to use the Quick Test function of the the Segment Template Creator the SHOWPLAN privilege must be assigned to the Emarsys user.
- Connection Name: the reference you want to give to your connection, can be the same as the database name.
This cannot contain spaces and should use underscores instead.
- Host: the host name of the database
- Port: the port to use for connecting to the database
- Database name: the name of the database
- User name: the login name of the user you want to use for this connection
- Password: the password of the user you want to use for this connection
- 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 the default parameters.
- CA Certificate: the root CA certificate you want to use, more information can be found in the Preparing your hosted database for Relational Data page.
- When all the necessary information has been added, click Test to verify that your connection works.
- Click Save to create your connector
You are done and can now either: