[mpeg]

I just gave it a go and am super impressed with the Salesforce connector, most of the tools I've tried are awful for SFDC (including data sync tools like airbyte etc)

I loaded in around 100k rows and performance was fantastic.

I think the only feature so far I haven't found is whether there is a way to join tables together in the app. With SFDC particularly it doesn't seem to have an option to write the SOQL query directly, and I can't access relationships with the field builder, so I have no easy way to do a client side join (apart from a ton of VLOOKUPs which is not ideal)

I do love how calculated columns stay even after I re-query the source data, that and the auto-expanding are killer features.

Super exciting product, very polished, I can't wait to see where it goes.

PS. $18/mo for the pro version with scheduled queries is an absolute steal

[jeanlaf]

Oh what was not working with Airbyte? (Airbyte co-founder that is very interested to see how we can improve it ;) )

[mpeg]

Hey! Airbyte was working in theory, but it was not very user friendly to handle a large Salesforce instance (this was for a client of mine with 100k+ employees)

I've just given it another go with Airbyte Cloud and I think some of the issues I had have been fixed (I remember back when I tested it was pretty clunky to select tables to sync with hundreds of custom tables) because I didn't have any major problems.

One thing that is a showstopper that is probably very specific to my use case is it doesn't allow you to filter tables before syncing, my client has offices worldwide but I mostly work within a couple regions so some of the tables I want to sync I would like to put a filter on as they have a "Market" custom field for the country.

I can of course just sync everything and then filter on the destination but as a consultant I'm wary to sync data that I have no business working with, plus it would increase the data size of the sync massively.

Overall I do love airbyte though! it's a great tool, and I use it for other data sources, just didn't work for me in this specific case

EDIT: I just noticed I was unnnecessarily harsh in the parent comment, I was more thinking about other tools that have very basic SFDC integration (only standard tables, no custom tables/fields) – airbyte's integration is overall good, it just didn't work for my specific usecase

[benmcredmond]

Thanks so much for the kind words and glad it resonates!

Joins are coming very very soon. Stay tuned.