4 ms·
Is your team looking to do a 2-way sync between PG and SF for certain fields? Or is the use case something where data from SF needs to be enriched with data fro
by jimmyechan 4y ago
Is your team looking to do a 2-way sync between PG and SF for certain fields? Or is the use case something where data from SF needs to be enriched with data from PG and then pushed back to SF (or vice versa)? I'm curious to know which fields need to be synced that way.
With the approach your engineer recommended, it seems to imply that the sales team might also want to update data manually and those updates should be reflected in both PG and SF - is my understanding correct?
- stephen 4y agoHi jimmy! Yep, invariably the ask always ends up to be 2-way syncing. :-/ Fwiw realistically I think these things are generally best written as custom software anyway, b/c things like identity (of entities/mapping ids correctly across both systems), the inevitable field mapping, etc. always come up, and with custom software I can write tests for all of them. :-)
- jimmyechan 4y agoTwo-way is definitely more convenient. Custom could be a good approach, but could get difficult to maintain due corner cases or as schemas change from either side. I'd be curious to know how you end up solving for this! Good luck!