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

Community

Connector Improvement: Hashing in Salesforce

Not planned
Abhishek Singh User

Hi Team 

As i understand from the current setup , hashing in Fivetran connector happens by suffixing a salt value to the actual value and then performing some hashing algo on it. 

There is a need to match these hashed values with hashed values coming from various other sources. 

So it would be good if we have the ability to remove the salt value from the hashing process and just perform the hashing on the actual value. 

As this is currently not possible, putting a feature request. 

Thanks 

Abhishek 

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Official comment
    Amy Peterson Fivetranner

    Thanks for that context. The salt is actually the same across connectors, so you should be able to match at least across your Fivetran sources.

    Including a salt-less option is not currently on our roadmap, but something we may consider in the future pending additional demand. Thanks again for submitting this!

  • Amy Peterson Fivetranner

    Thanks Abhishek! One possibility that exists today is that we can securely share the salt used for your account, and you can use that to hash the data from other sources so they match. Would that be helpful in your case?

  • Abhishek Singh User

    Hi Amy, there are multiple systems that needs to be matched here, and looking at the effort involved in making changes in all the systems based on the salt value does not seem feasible. 

    I agree it can be used as an interim solution. Also i think the salt value differs from connector to connector. That would lead to more complications. 

    If we do not have the salt suffixed , we can make an easy match between systems.