Live data from Hacker News

Launch HN: Bracket (YC W22) – Two-Way Sync Between Salesforce and Postgres

news.ycombinator.com

51–60 of 82 posts

Re: Launch HN: Bracket (YC W22) – Two-Way Sync Between Salesforce and Postgres

#51

Get in touch if you want to expand to NetSuite. We can have a chat...

I built an in-house one-way sync from NS to Google BigQuery. Two-way is pretty hard as their REST API is still “in beta”.. and nobody wants to deal with SOAP.. how big of an opportunity do you think this is?

Re: Launch HN: Bracket (YC W22) – Two-Way Sync Between Salesforce and Postgres

#52

Neat. I once wrote a Salesforce to Oracle sync app. I think the goal was to bulk pull data out of Salesforce for processing in Oracle to avoid Salesforce API costs. This was years ago. It was a fun and aggravating project.

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 Salesforce API.

Re: Launch HN: Bracket (YC W22) – Two-Way Sync Between Salesforce and Postgres

#53

Earlier quoted context omitted.

Yeah, so far, we’ve found that this combination of the three APIs is a happy medium between reliability, simplicity, and API limit consciousness.

I'm curious what's the biggest table you've tested on? Things start to get really interesting in Salesforce when your object has a million rows.

Yeah definitely agree, we had to rework our logic for these cases. We've worked with ~4 Million row objects. In general with our polling strategy syncs, the problem was more the size of each record. So a table with 1M rows but 400 fields was way more problematic than 2M of just 5 fields.

Re: Launch HN: Bracket (YC W22) – Two-Way Sync Between Salesforce and Postgres

#54

Earlier quoted context omitted.

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 reason many YC companies struggle with enterprise sales is because it's generally much harder than PLG, with long sales cycles and delayed feedback loops. It was definitely a learning curve for us!

(opinions as ex-AWS GTM specialist for AI) An underrated challenge with enterprise sales is often that customers often misguidedly believe that 1) they can build it themselves, 2) they are worried about your companies ability to "scale" to their needs, and/or 3) the customer wants to "own" that responsibility for personal/political/career reasons. Sales is hard for everyone including Azure, AWS, etc, just gotta keep…

[deleted]

Re: Launch HN: Bracket (YC W22) – Two-Way Sync Between Salesforce and Postgres

#55

Even if this only accomplished one-way directional sync with backup and disaster recovery capabilities, it'd probably find a 10x wider audience.

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

Without knowing the target market, I'm thinking the taxonomy of "two-way sync" is understood by a very narrow community. ISVs have been using this approach for years. So maybe that's the audience?

If so, then Heroku connect probably does need an alternative.

A business user (non-technical 10x audience) just wants to sleep at night knowing their daily backup was successful and they have recovery capabilities on-demand.

There are unicorn scale companies in this space (such as https://www.owndata.com/). And Salesforce is getting back into the backup game.

Re: Launch HN: Bracket (YC W22) – Two-Way Sync Between Salesforce and Postgres

#57
post #49

Neat! How specific is your solution to Postgres? Could it be ported to another db engine? (And, how are conflicts resolved? In a huge system with millions of records coming from everywhere it can fast become nightmarish?)

> 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 with our transformers (e.g. dealing with MySQL's lack of BOOL field types). Streaming is currently Postgres-specific. We're planning on rolling out support for MySQL next, after we've finished our Hubspot integration. Do you have a specific…

> The primary source wins any merge conflicts that happen within a sync period.

This is a very fancy way of saying that you just drop conflict and pretend they didn't happen. Syncing databases is very, very tricky. Conflicts are a big part of the trickiness.

Re: Launch HN: Bracket (YC W22) – Two-Way Sync Between Salesforce and Postgres

#58

Earlier quoted context omitted.

> 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 with our transformers (e.g. dealing with MySQL's lack of BOOL field types). Streaming is currently Postgres-specific. We're planning on rolling out support for MySQL next, after we've finished our Hubspot integration. Do you have a specific…

> The primary source wins any merge conflicts that happen within a sync period. This is a very fancy way of saying that you just drop conflict and pretend they didn't happen. Syncing databases is very, very tricky. Conflicts are a big part of the trickiness.

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 conflict manually. But a handful have expressed interest in the latter approach, so it's on our roadmap to build.

Re: Launch HN: Bracket (YC W22) – Two-Way Sync Between Salesforce and Postgres

#59
post #17

Salesforce reps don't even know what Heroku Connect is. I couldn't get someone to sell it to me! I think the idea is great, glad to see someone picking it up.

Yeah, I used it quite successfully for a local nonprofit that kept most of their data in Salesforce. The eventually consistent syncing sidestepped a ton of headache for us and we could read straight from PostgreSQL. We just used API calls then writes to PostgreSQL for important changes (registrations, etc) originating from the website.

Re: Launch HN: Bracket (YC W22) – Two-Way Sync Between Salesforce and Postgres

#60
I'm currently on a team tasked with thinning out our Salesforce App Exchange app. Bracket looks very cool.

1. Do you have any plans to release an API rather than utilizing a webapp for defining the sync? 2. Does your Salesforce integration support syncing metadata, including custom metadata? 3. Do you have data on the impact Bracket has on platform events and other Salesforce limits? 4. Can you share any information on pricing?

Thanks!

Post reply on HN