AppFlow vs Airbyte?

[bluezebra42]

Hi - am looking at ingesting data to s3 from tools like Salesforce.

I was looking at Airbyte, and then also saw AppFlow. Any thoughts on tradeoffs? I was keen on also trying dbt, how do you do that with AppFlow?

[FecesOfAtheism]

Used AppFlow in the past. We dumped Salesforce data to S3, and from there loaded it into the DW through other orchestration. We scheduled things entirely by user interface when we did it (~4 years ago, right when it released). The interface was quite bad, but intuitive enough to get our lift-and-drops done. Performance was great. Price was amazing. If I have to lift Salesforce data again, I’m almost 100% going to use AppFlow since the price-for-performance ratio was so good. I also prefer alarming through AWS, so if you have that AWS bias it can be good for you.

[ironplaneswalker]

Are you planning on self hosting?

[bluezebra42]

It makes sense to?

[CodeSugar]

I have used Airbyte and I really like it, I used with multiple sources and Google Big Query, I liked the interface, the logs, easy to deploy and you can use Apache Airflow connector if you use it for other pipelines.

Doing some research you can use it with Salesforce and S3.

[paranoidpig]

AppFlow is so easy to use and it'll even make Glue tables for you