Hello all, Does anyone have experience or insights in using Airbyte for moving data from BigQuery into Salesforce? We already use Airbyte when moving our data into BigQuery, and are trying to figure out whether creating a custom connection for Salesforce is worth it just to keep everything in Airbyte. Any advice is highly appreciated!

Hi, this is a great use case and something we are aware of. Unfortunately we don't have a lot of tooling around this (most of our tooling is for HTTP/DB sources and DB destinations). You are definitely welcome to contribute something and we will work with you to make it as easy as possible 🙂

We are tracking work for this on https://github.com/airbytehq/airbyte/issues/3982 . So please comment there

I'm also tagging @s who leads our connector team and might have more to add

I see, thanks @Davin Chia (Airbyte)!

have you considered using an automation software like integromat?

We use this right now to get around some of salesforce’s API limits: https://www.heroku.com/connect

We just update the data in the heroku postgres instance and it syncs to salesforce. If you could use something like that, it would just be a postgres destination I believe. We don’t actually have any heroku apps that use it, but instead use a VPC endpoint to connect it to our AWS account to move data between our warehouse and salesforce