Salesforce Marketing Cloud (SFMC) Intelligent Sync Connector

The SFMC Intelligent Sync Connector supports custom data extensions. Through configuration, customers can sync to Nitro data from any custom data extensions configured on the SFMC platform. For example, data extensions housing activity data generated from the SFMC Customer Journey module. This enables marketing organizations to do extensive analysis on marketing related activities not related to the SFMC Email application.

Adding Objects to SFMC Allowlists

In order to bring additional objects from custom data extensions into the scope of the SFMC intelligent sync connector, you must add them to the allowlist.

These objects can be included in the Intelligent Sync connector by creating a .yml file and uploading it as a part of the allowlist library.

Example

Copy
name: custom_object
source: SFMC
mappings:
- sourceSchema: SFMC
targetSchema: STG
pattern: pt_sfmc_stg_de_nokey_fullextract__v
- sourceSchema: STG
targetSchema: ODS
pattern: pt_sfmc_ods_de_nokeypattern__v

For each object type, these patterns are supported to allowlist the objects for SFMC:

Object Type

Supported Pattern from source to STG

Supported Pattern from STG to ODS

No Primary Key Table

pt_sfmc_stg_de_nokey_fullextract__v

pt_sfmc_ods_de_nokeypattern__v

Primary Key(s) table

pt_sfmc_stg_de_keyed_fullextract__v

pt_sfmc_ods_de_ed_keyedpattern_latest__v

pt_sfmc_ods_de_ed_keyedpattern_history__v