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:
- Assign the following roles to the database user you share with Emarsys:
- BigQuery Data Viewer
- BigQuery Job 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
This connector can only be used for segmentation as BiqQuery cannot provide the data quickly enough to be reliably used for personalization.
This limitation is because BigQuery is optimized for massive datasets and queries always take 2-5 seconds to run, regardless of the size of the dataset.
As a result no tables or views will be visible under the Tables & Views section of Relational Data when using a BigQuery connector.
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 Google Big Query connection.
Instead of manually configuring the connection (step 3) you can import all the information in a JSON file directly from your Google Cloud Console and go straight to step 4. For more information, see Google's documentation.
- Configure your connection as follows:
- 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.
- Project ID: the ID of your google project
- Dataset: the name of the database
- Client Email: the service account email address you want to use for this connection
- Private key: the service accounts key you want to use for this connection
- 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: