Viewing profile — ianyanusko

With Salesforce specifically, getting a stable and reliable event-driven stream. That's why we ended up adopting a hybrid approach of subscribing to pub/sub events, but also period…

Thank you! It means a lot to see your comment here

Hubspot and MySQL are both next on our list for deploying out of beta! I'll shoot you a message when they're out :)

Good question. Our ultimate goal is to be the go-to for any two-way data syncs. We think the Salesforce syncing market by itself is 500 million to 1B. If you start including all of…

Gotcha, that makes sense. From our perspective, the one-way sync market (backups and ETL/rETL) was already saturated with heavily-capitalized players who were hitting each other ha…

Nice! Great point about the round trip - we do something similar for formulas and auto-generated fields like `Id`. That's awesome you built this in-house. > Syncing data from Sales…

1. Yes, on our roadmap for Q1! Getting that request a lot 2. We don't currently sync metadata 3. Our footprint on your Salesforce API depends on whether you're using polling or str…

Agreed on the trickiness! Our early users largely told us they preferred one source to take precedence in a conflict, and would rather set that general rule than review every confl…

Nice, I hear you on "fun and aggravating" :) Sounds similar to the use cases we're seeing, where it's not only easier to process/build on Postgres, but also saves you on the Salesf…

> How specific is your solution to Postgres? Could it be ported to another db engine? Our polling approach is relatively database-agnostic. We just need to handle each DB's quirks …

Really helpful on both fronts, thanks for the thoughts. Both the sandbox and migration use cases make a lot of sense.

Agreed! We’re big fans of consolidating in Postgres. We’re also hearing some downstream benefits to having things scaled in Postgres (makes reporting easier, allows the data team t…

Sorry, forgot to respond to one piece: > Many clients I can think of this being most useful for would rather host it themselves, is that an option? Right now you can self-host the …

Thank you! > do you support subsetting a data source -- only sync records matching criteria? In a one-way sync from Postgres to Salesforce, yes, you can apply filters using a SQL s…

Thanks for the comment - are you saying that one-way sync has a 10x wider audience than two-way syncs?

Agreed that many technical founders build on the pain points they've experienced themselves. I'm curious your take on why the managed services approach is hard to scale? IMO, the r…

Thanks! Going to shoot you a note

We use a custom trigger to build an event log in Postgres. We actually found it more straightforward to use this approach than to use the WAL packages we considered. If you're curi…

Thanks! We've had to internalize the lesson "startups can do one thing well at a time" :) At first, it was a matter of doing discovery with people who we thought would find Bracket…

For sure, definitely has not been an easy problem to solve. The two-way syncing is one tough element (for the reasons mentioned above), and configuring our requests to the Salesfor…

Thank you!

Yeah exactly. One-way data syncing is a big market, and these companies have plenty of use cases to tackle, which is why I think two-way syncing has not been a priority for them. T…

Yup! We offer two ways of interacting with Salesforce: polling and streaming. The benefits of streaming are faster syncs and optimized Salesforce API usage. Right now, we're focusi…

Fivetran and Hightouch do ELT and reverse ETL, respectively, which are one-way syncs. While Bracket can handle one-way syncs, two-way syncs (in situations where you need writes fro…

Hey HN, I’m Ian, co-founder at Bracket ( https://www.usebracket.com ) along with Kunal and Vinesh. Bracket makes it easy to set up fast, bidirectional syncs between Salesforce and …