DinMo Documentation
  • 📙Core Concepts
  • Guides
    • ⚡Get started with DinMo
      • Initial Configuration of DinMo
        • Connect a Source
        • Create your Models
        • Create a Destination
      • Create and Activate Segments on DinMo
        • Create your first Segment
        • Activate your first Segment
    • 🌐Workspaces & Organizations
    • 💭Need Help?
  • Integrations
    • Data Sources
      • AWS Redshift
      • Databricks
      • Google BigQuery
      • PostgreSQL
      • Snowflake
    • Destination Platforms
      • Actito
        • Synchronize users attributes
        • Export contact lists
      • All My SMS
      • Batch
        • Synchronize contacts (MEP)
        • Synchronize profiles (CEP)
        • Send events (CEP)
      • Braze
        • Synchronize users attributes
        • Send track events
        • Synchronize subscription statuses
        • Export user lists
      • Brevo
        • Synchronize contacts
        • Export contact lists
      • Criteo
        • Export contact lists
      • Dialog Insight
        • Synchronise Contacts
      • Emarsys
        • Export contact lists
        • Synchronize contacts data
        • Synchronize custom table's data (RDS)
      • Firestore
        • Create and update Collection Documents
        • Export Audiences
      • Google Ads
        • Export audiences
        • Enhanced Conversions for Web
        • Upload click or offline conversions
          • Prerequisites and walkthrough
        • Adjust conversion events
        • Retract conversion events
      • Google Display & Video 360
        • Export audiences
      • Google Search Ads 360
      • Hubspot
        • Synchronize objects
      • Intercom
        • Export segments
        • Synchronize contacts
        • Synchronize companies
      • Iterable
        • Synchronize user attributes
        • Export contact lists
      • June Email Marketing
        • Export Contact Lists
      • Klaviyo
        • Export contact lists
        • Synchronise contacts
        • Create subscription list
      • LinkedIn Ads
        • Export user audiences
        • Export company audiences
      • Mailchimp
        • Export segments
      • Meta Ads
        • Export audiences
        • Send conversion events
      • Microsoft Ads (Bing)
        • Export audiences
      • Pinterest Ads
        • Export audiences
        • Send conversions
      • Reddit Ads
        • Export Audiences
      • Salesforce Marketing Cloud
        • Synchronize data extensions
      • SendGrid
        • Synchronize contacts
        • Export contact lists
      • Selligent
      • Snapchat Ads
        • Export Audiences
      • Splio
        • Synchronize contacts
      • TikTok Ads
        • Export Audiences
        • Send Offline Conversions
        • Send Web Conversions
      • X (Twitter)
        • Export audiences
      • Zendesk
        • Synchronize users
        • Synchronize custom objects' data
  • Models
    • Overview
    • Primary Keys
      • Detect duplicate primary keys
    • Calculated Fields
  • Identity resolution
    • Overview
  • Segments
    • Visual Builder
    • Breakdowns
    • Overlap Analysis
  • Activations
    • Overview
    • Sync Scheduling
    • Troubleshooting Syncs
      • Automatic pause or resume Activations
      • Sync warnings
  • AI PREDICTIONS
    • Overview
    • LTV and Churn
    • Product Recommendations
  • WORKSPACE MANAGEMENT
    • Set Up
    • Managing Users & Roles
    • Audit Logs
    • Enterprise Single Sign-On (SSO)
  • Security & Privacy
    • Overview
    • Networking
    • Privacy
    • Data Processing
Powered by GitBook
On this page
  • Overview
  • Destination setup
  • Activation configuration
  • Fields mapping
  • Custom Attributes
  • Clear Data Extension
  1. Integrations
  2. Destination Platforms
  3. Salesforce Marketing Cloud

Synchronize data extensions

PreviousSalesforce Marketing CloudNextSendGrid

Last updated 3 months ago

Overview

In this destination service, DinMo will synchronise your data with an existing data extension or create a new one if it does not exist.

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

  • If your data extension does not already exist,

    • Click on Create a new data extension on the destination creation page.

    • Enter the following information:

      • The Data Extension name

      • The Data folder used by your data extension

      • The field used as primary key and its type

  • If your data extension already exists:

    • Create a Salesforce Marketing Cloud destination targeting this data extension. Refer to the for more info.

    • Create a segment or a model composed of all the rows that will populate the Salesforce data extension. The data extension's primary key must be one of the model's fields.

    • Activate the model or segment to the Salesforce destination to start sending data. Refer to the 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 data extension

  • All attributes values that have changed since the last activation will be updated in the data extension

If you chose not to insert new records, only records of the model with a primary key already present in the data extension will be updated.

Destination setup

To start synchronizing objects, you are first required to create a Salesforce Marketing Cloud destination with the corresponding destination service.

In this process, you must specify:

  • How data will be transferred:

    • Either using a FTP user. In this case, you must indicate the file transfer location (by default, ExactTarget Enhanced FTP)

    • Either through Amazon S3. In this case, you must again indicate the file transfer location.

  • Which existing data extension will be updated in this destination. If you wish to update different data extensions, please create one distinct destination for each of these objects

Configuring Amazon S3 Access

Amazon S3 Access requires you to input an AWS role ARN to give DinMo write access to your S3 bucket at the file transfer location.

In order to do so, you must add this role arn to the role's trust policy : arn:aws:iam::724998534403:role/DinmoS3AccessorRole-dinmo-prod

Here is an example of a trust policy with that role :

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Effect": "Allow",
            "Principal": {
                "AWS": "arn:aws:iam::724998534403:role/DinmoS3AccessorRole-dinmo-prod"
            },
            "Action": "sts:AssumeRole"
        }
    ]
}

Here is a minimal policy granting s3 access to a role

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Effect": "Allow",
            "Action": [
                "s3:ListBucket"
            ],
            "Resource": "arn:aws:s3:::example-bucket"
        },
        {
            "Effect": "Allow",
            "Action": [
                "s3:GetObject",
                "s3:PutObject",
                "s3:DeleteObject"
            ],
            "Resource": "arn:aws:s3:::example-bucket/*"
        }
    ]
}

Important note: The data extension must have a primary key configured on Salesforce's side.

Activation configuration

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

Fields mapping

In the Fields mapping section, you are asked to specify the field contained in your DinMo model corresponding to the primary key of the target data extension. This field will be used to link the model's records to existing records in Salesforce.

You can then map any other attribute existing in Salesforce. These attributes will then be updated by DinMo during each activation.

Custom Attributes

In this section, any field you select will be exported as a new column in your Salesforce data extension. The associated field will have the same name in Salesforce and DinMo.

The values of the attributes selected here will then also be updated at each activation.

Clear Data Extension

You can clear a Data Extension when configuring a sync. This functionality is available only for Sync Data Extensions.

You can enable Clear Mode in the activation setup. When enabled, this option allows you to clear the existing data within a Data Extension before inserting new data. To do so:

  • Navigate to the activation setup.

  • Select the target Data Extension.

  • Enable the Clear Mode toggle.

  • Ensure that the sync mode is set to Full.

  • Run the activation

Learn how to create such a destination in our

Learn how to activate a segment in our

step-by-step tutorial
step-by-step tutorial
corresponding section
corresponding section