Fivetran

What do you like best?

Some of their data sources are very high quality. The google sheets connector easy to use and much betetr than stitch. The braintree transactions connector is good as well. The netsuite connector requires a more expensive addon for netsuite, however it does have good quality data so it may be worth it.

What do you dislike?

Some connectors are outdated and missing columns; sometimes connectors fail for days straight, support is terrible, and the communication in general from Fivetran leaves a lot to be desired. I want more control over setting sync schedules for my pipelines. The email notifications that come with the starter plan aren't really good. The alerts are noisy as some connectors, depedning on sync frequency, will always be delayed. They should recommend different sync times. Slack should be available for every account. API access is only available with more expensive plans which isn't great for us.

Recommendations to others considering the product:

Check the ERDs in detail before migrating a connector. Ask about product roadmaps. Make feature requests ahead of contract signing. Ask about support and protections they have for your data. We had a lot of issues with their support and cost us a lot of time and money. They recently promised to complete revamp their support processes and policies, so any new customers should make sure to grill them about it. Ask specifically if they have ever deleted a customer's data.

What problems are you solving with the product? What benefits have you realized?

We use a few datasets for critical operational functions, and Fivetran has allowed us to deprecate our internal pipelines. Some of these datasets are high quality and reliable. The google sheets connector is excellent, and business users are able to use it to get data into our data warehouse.