search

estuary / connectors

Connectors for capturing data from external data sources
Other
50 stars 16 forks source link

Request a connector to Snowflake to Salesforce #1952

Open ameer-cp opened 1 month ago

ameer-cp commented 1 month ago

System Name

Salesforce

Type

Materialize

Details

I want to materialize / capture data from Snowflake models to Salesforce

dyaffe commented 1 month ago

Thanks @ameer-cp, can you expand on your use case at all? We're definitely planning on adding a Salesforce destination but don't have it yet.

Are there any streams you'd like to push? Is real-time important?

ameer-cp commented 1 month ago

hi @dyaffe - i will get you details on how we are currently implementing reverse ETL on hightouch (with specific streams and operations), but for now i just wanted to create a placeholder request.

essentially we are enriching account, user, contacts and tenant objects after doing some ETL and modelling to see what already exists - what we try to then push are just new details from our Goodfit data source, that dont exist in the Salesforce Account object yet. these are update and insert operations based on respective PKs. real-time is not important but we do these syncs at a regular interval (hourly)

its not a massive amount of data but we feel this can be done cheaper and in a simpler manner via Estuary

dyaffe commented 1 month ago

Thanks @ameer-cp, we will let you know when we add a Salesforce destination.