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

Community

Connector Improvement: Announced Oct 1 change to Salesforce connector re: Formula fields is a step back

Not planned
Tim Nickason User

I received an email from Fivetran today mentioning the fact that come Oct 1 2023, the replication of SFDC formula fields (on new connectors) will require customers to use the API to enable formula field replication.   While we understand the implications of formula field replication, forcing customers to wade through the API to enable this seems like a step back.  We selected Fivetran for it's ease of use (so we didn't have to do this).   Can this decision be reconsidered.

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Ray User

    Hi Tim,

    I appreciate your concern here. All existing connectors which are directly syncing formula fields will continue to do so without needing an API call. Our team has configured the setup to support this for you already. For all newly created connectors, the API will be the recommended way to achieve this behavior until further notice. Our support team will always be available to assist as well. 

    Meanwhile, I do urge you and others to consider using transformations to replicate formula fields. Our solution has been increasing in quality and we now also support the much-requested rollup summary fields.

  • Tim Nickason User

    Ray, I'm familiar with the pitfalls of using replicated SFDC formula fields in Fivetran, but certain internal customers still want them available and I rather not have to get formula fields on a connector by connector basis (currently it is all or none from what I recall).   We are not in a position to utilize Fivetran/dbt transformations at this point in time.