Synchronize contact attributes
Sync customer and profile attributes from DinMo into an existing MySQL table using upsert or mirror behavior.
Overview
This destination service allows DinMo to sync profile or segment attributes into an existing MySQL table.
To use this service, follow these three steps:
Create a MySQL destination platform. Follow the platform setup guide to establish the connection.
Create your DinMo user segment or data model representing the profiles you want to sync.
Activate your segment or model with the MySQL Contact Attributes destination service.
Every time the activation runs:
DinMo writes mapped fields to the selected MySQL table.
The first run processes the selected records.
Later runs use DinMo delta detection to process changed records.
The selected sync mode controls whether removed source records should also be removed from MySQL.
The MySQL Contact Attributes destination is available as a beta destination service. If you do not see it in your workspace, contact your DinMo team.
Destination Setup
Before beginning data synchronization, set up your MySQL destination service:
Go to Destinations > Add a new destination.
Choose your MySQL platform.
Select MySQL Contact Attributes.
Select the target Table Name from the available MySQL tables.
Give the destination a name and save it.
DinMo lists the available tables from the connected MySQL database. The target table must already exist before you create the destination service.
Activation Configuration
Once the destination is configured, create an activation to begin syncing your data:
Select the DinMo model or segment you want to sync.
Map DinMo fields to existing MySQL table columns.
Make sure the field used to identify records is mapped to the corresponding MySQL column.
Review the sync mode and schedule.
Save and run the activation.
DinMo loads the available mapping fields from the columns of the selected MySQL table.
Sync mode
Sync modes determine how DinMo applies data changes to the destination.
For the MySQL Contact Attributes destination, the available options are:
UPSERT
Processes inserted and updated records using DinMo's delta detection logic.
Keeping an application table updated with profile attributes.
Large datasets with limited day-to-day changes.
Destinations where deleted source records should remain in MySQL.
Creates missing destination rows when needed.
Updates existing destination rows when mapped values change.
Does not delete destination rows that disappear from the source selection.
MIRROR
Keeps the MySQL table aligned with the current source selection, including removals.
Maintaining a MySQL table as a replica of the current DinMo model or segment output.
Use cases that require records removed from the source to be removed from the destination.
Creates missing destination rows when needed.
Updates existing destination rows when mapped values change.
Deletes destination rows when the corresponding source record is no longer present.
Mirror mode can delete rows from the selected MySQL table. Use it only when the table is dedicated to this activation or when deletions are expected.
Field Mapping
During activation setup, define how DinMo fields are written into MySQL:
Record identifier: map the DinMo field used to identify records to the matching MySQL column.
Attribute fields: map each DinMo field to the MySQL column you want to keep updated.
Column compatibility: mapped values must be compatible with the destination column types.
DinMo does not create MySQL tables or alter MySQL schemas for this destination service. Create the table and columns in MySQL before configuring the destination.
Scheduling
Define how frequently DinMo updates MySQL.
Choose a schedule that matches the downstream freshness requirement. Operational applications usually require more frequent updates than internal reporting or back-office workflows.
Common Use Cases
Teams typically use this destination service to:
Sync profile attributes into an application database.
Maintain customer attributes for internal tools or support workflows.
Expose selected warehouse data to backend services.
Keep a MySQL table aligned with a DinMo segment or model output.
Last updated