Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Salesforce Marketing Cloud

Answered
Ramon Jackson User

Hi Team,
Could you please explain why we cannot use the same table schema provided by Salesforce? Kindly review the link below for the tables provided by Salesforce and explore how we can integrate them into the existing Salesforce connector:
https://dataviews.io/

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Lucas Alexander Fivetranner

    Hi Ramon,

    Luke from the Product team here. Thanks for submitting this request and for providing the helpful link to the Data Views tables. 

    The table names in Fivetran’s ERD (e.g., EMAIL, SEND, CAMPAIGN_ASSET) represent replicated tables from the SFMC API. The table names in our schema generally match the name of the endpoint that Fivetran fetches data from (e.g. Email, Send, CampaignAssets). 

    Data Views are system tables within Salesforce Marketing Cloud. These are read-only, system-maintained tables accessible via SQL queries within SFMC. They are specific to the platform's internal tracking system and are not exposed via APIs or replication tools like Fivetran.

    While we cannot replicate Data Views directly, equivalent metrics can be derived using Fivetran’s EVENT table for information on clicks, opens, and bounces, combined with SQL transformations in your destination to emulate the logic of Data Views.

    Cheers,
    Luke