Synchronize custom table's data (RDS)

Overview

This destination service is only relevant for Emarsys accounts with Relational Data Service (RDS) enabled.

In this destination service, DinMo will export and update rows of a pre-definite custom table located in Emarsys Relational Data Service (RDS), and optionally, insert new rows into this table.

The custom table should already exist in Emarsys RDS, with its schema configured, and, one of its column corresponding to the primary key should be exactly named 'id'.

To create such an activation, you will need to go through these three steps:

• Creating an Emarsys destination. Refer to the corresponding section for more info.

• Creating a custom segment or custom model composed of all the records and their attributes that will be updated in Emarsys.

• Activating the model to the Emarsys destination to start sending data. Refer to the corresponding section for more info.

Each time the activation will be running:

• If you ticked the insert mode option, all new records in the model will be inserted in the Emarsys custom table

• All rows values that have changed since the last activation will be updated in the Emarsys custom table

If you chose not to insert new records, only records of the model which are already present in Emarsys will be updated.

Destination setup

To start synchronizing custom tables' data, you are first required to create an Emarsys destination with the corresponding destination service.

Learn how to create such a destination in our step-by-step tutorial

In this process, you must enter the connection name in which your target table is contained. The connection name can be found under the Connections tab of the Relational Data add-on in Emarsys:

Next, enter the name of the target custom table that DinMo will update. The table must have been prievously created on Emarsys side. The table must already contain all relevant columns that DinMo will be updating, and, it must have a column exactly named id, that will be used to match records between DinMo and Emarsys.

Activation configuration

Once the destination has been setup, and your DinMo model created, you can create an activation to start sending data to Emarsys right away.

Learn how to activate a segment in our step-by-step tutorial

Fields mapping

In the Fields mapping section, you are asked to specify the field contained in your DinMo model corresponding to the identifier column of the target custom table. This field will be used to link the model's records to existing rows in Emarsys.

You can then map any other column existing in your Emarsys custom table. These attributes will then be updated by DinMo during each activation.