--- title: Fivetran Reviews meta_title: 'Fivetran Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 801 reviews by the users' company size, role or industry to find out how Fivetran works for a business like yours. aggregate_rating: rating_value: 4.3 review_count: 801 scale: '5' date_modified: '2026-07-21' parent_category: name: Cloud Data Integration url: https://www.g2.com/categories/cloud-data-integration --- # Fivetran Reviews **Vendor:** Fivetran **Category:** [ETL Tools](https://www.g2.com/categories/etl-tools) **Average Rating:** 4.3/5.0 **Total Reviews:** 801 ## About Fivetran Shaped by the real-world needs of data analysts, Fivetran technology is the smartest, fastest way to replicate your applications, databases, events and files into a high-performance cloud warehouse. Fivetran connectors deploy in minutes, require zero maintenance, and automatically adjust to source changes — so your data team can stop worrying about engineering and focus on driving insights. ## Fivetran Pros & Cons **What users like:** - Users appreciate the **ease of use** of Fivetran, enjoying seamless integration and effortless maintenance post-setup. (187 reviews) - Users appreciate the **easy setup** of Fivetran, making it straightforward to integrate with existing applications. (74 reviews) - Users value the **easy integration** of Fivetran, enabling seamless connectivity with various applications and tools. (73 reviews) - Users value the **responsive customer support** from Fivetran, enhancing their overall experience and satisfaction. (62 reviews) - Users appreciate the **intuitive and simple layout** of Fivetran, making data management effortless and enjoyable. (59 reviews) - Integrations (51 reviews) - Users value the **easy integrations** of Fivetran, appreciating the seamless connectivity across multiple data sources. (49 reviews) - Data Integration (44 reviews) - Time-saving (40 reviews) - Data Management (38 reviews) **What users dislike:** - Users experience **sync issues** with sporadic failures and confusion over usage quotas, complicating their workflow. (60 reviews) - Users note that Fivetran's pricing is **quite expensive** , which limits accessibility for many potential users. (36 reviews) - Users face **integration issues** with Fivetran, especially regarding schema ownership and modifying connections efficiently. (28 reviews) - Users find the **learning curve steep** , requiring significant technical knowledge to effectively navigate the system initially. (27 reviews) - Users consider Fivetran's **pricing issues** a barrier, wishing for lower costs and more flexible options for accessibility. (24 reviews) - Feature Limitations (21 reviews) - Data Management (18 reviews) - Insufficient Guidance (18 reviews) - Missing Features (16 reviews) - Bugs (15 reviews) ## Fivetran Reviews ### 1. Good software but expensive compared to competitor like stitch **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Semiconductors | Enterprise (> 1000 emp.) **Reviewed Date:** November 17, 2022 **What do you like best about Fivetran?** quality product, more solid than competitor's product **What do you dislike about Fivetran?** price, much much more expensive, and force customers to sync unnecessary tables that drives up the cost. stitch is much, much, cheaper when it works. **What problems is Fivetran solving and how is that benefiting you?** sourcing data from various saas software without me handling all the api calls ### 2. Census is a no brainer - saves so much time & scales our team **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** May 16, 2022 **What do you like best about Fivetran?** 1. It brings data into tools with no engineering effort - which allows us to scale out our small team & bring the data to reps they need to do their jobs more effectively 2. It automates data pulls and processes we do daily/weekly/monthly for business operations which saves us a ton of time **What do you dislike about Fivetran?** Nothing - its really intuitive to use. Only downside is you have to pay for the number of syncs you use so we have to track & optimize the ones we use vs being able to go unlimited **What problems is Fivetran solving and how is that benefiting you?** We need to get reps the data they need in the tools they're already working in. We want to be able to do that quickly & ideally without a big engineering lift. Census allows us to scale out these efforts quickly & easily. **Official Response from Roslyn Coutinho:** > Hi there, Thanks so much for sharing your review – we love hearing that Census helps you get data to your sales team without engineering requests. One small thing I wanted to clarify related to pricing is that Census charges on the number of destination fields, not the number of syncs, but I definitely still understand the sentiment. We check in regularly to make sure our pricing is the most competitive and value driven for our customers, and so we’ll definitely take that feedback into account. For some additional context, the reason we went with field based pricing is to ensure that the number of tools you sync to, the volume of rows synced, and the number of times you run a sync remains unlimited. ### 3. Well built and easy to implement **Rating:** 5.0/5.0 stars **Reviewed by:** Yannick G. | Head of Business Operations, Mid-Market (51-1000 emp.) **Reviewed Date:** November 24, 2022 **What do you like best about Fivetran?** The user experience for teams that are not specialized in data **What do you dislike about Fivetran?** Mostly the pricing as Fivetran quickly becomes expensive for huge data sources like GA or Amplitude **What problems is Fivetran solving and how is that benefiting you?** Bringing data from a variety of sources into a single ware house ### 4. Great tool for reliable low-maintenance exports **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Internet | Mid-Market (51-1000 emp.) **Reviewed Date:** September 16, 2022 **What do you like best about Fivetran?** Set-up and forget, variety of available connectors **What do you dislike about Fivetran?** Can be pricy, especially for small exports **What problems is Fivetran solving and how is that benefiting you?** Exporting data to external vendors without the need to set up and manage our own ETL pipelines ### 5. Most Comprehensive ELT tool **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Apparel & Fashion | Mid-Market (51-1000 emp.) **Reviewed Date:** November 22, 2022 **What do you like best about Fivetran?** The simplicity of adding connectors and start schedules is fantastic. The pricing model is easier to understand and reasonable. Dashboards to monitor MAR usage across connectors and accounts help us keep the bills in check. The in-built SQL editor is my most used component. **What do you dislike about Fivetran?** The built-in SQL editor is not the best (small window to code), perhaps because you are deprecating it in 2023. **What problems is Fivetran solving and how is that benefiting you?** Integrating data from multiple sources helps us to have a consolidated view. ### 6. The service census provides is great and the customer support is responsive and great **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** October 24, 2022 **What do you like best about Fivetran?** The service itself. We don't need to integrate with 3rd party by ourselves. save eng resources. **What do you dislike about Fivetran?** There's still some glitch for some integration. But the customer support is very helpful **What problems is Fivetran solving and how is that benefiting you?** It solves the problem of integrating with different marketing and sales tools. We save eng resources of integrating those APIs by ourselves ### 7. Census is great when we want to sync the data to our salesforce org from different application. **Rating:** 4.0/5.0 stars **Reviewed by:** Anoop V. | Architect, Enterprise (> 1000 emp.) **Reviewed Date:** August 30, 2022 **What do you like best about Fivetran?** The connection is easy to use. With 3 clicks we can easily connect to salesforce. **What do you dislike about Fivetran?** when we add a new field mapping and if we try to sync next day, the changes are not saved. But when we do the sync during the same day, we dont see any issues.Hard to find the logs. **What problems is Fivetran solving and how is that benefiting you?** Data sync timing is reduced with Redshift to salesforce. Before it was taking 4 hrs to sync data but it reduced to 15 min now. ### 8. great product **Rating:** 4.0/5.0 stars **Reviewed by:** Joanne L. | analytics engineer, Enterprise (> 1000 emp.) **Reviewed Date:** December 06, 2022 **What do you like best about Fivetran?** easy to use. nice integration. straight forward UI design **What do you dislike about Fivetran?** not sure. it works for fine me and my team. **What problems is Fivetran solving and how is that benefiting you?** pushing and syncing data from our data warehouse to different applications ### 9. Using Census on a daily bases **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** January 12, 2023 **What do you like best about Fivetran?** Helps a lot to sync the data from our data warehouse to other essential platforms. **What do you dislike about Fivetran?** Haven't faced yet with any drawbacks. Everything seems to work fine **What problems is Fivetran solving and how is that benefiting you?** With it's help, we are able to sync the data to other platforms, which teams use everyday ### 10. I wish Census had existed years ago **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Internet | Mid-Market (51-1000 emp.) **Reviewed Date:** March 24, 2022 **What do you like best about Fivetran?** Census just works. It's so simple to create a new sync that we're don't need to rely on data engineers to start moving data to the tools used by other teams: Salesforce, Hubspot, Google Sheets... **What do you dislike about Fivetran?** We're missing a sandbox environment, where we can create and test syncs without actually updating the data in the platform. A sandbox mode would be great to isolate environments effectively in our data stack. **What problems is Fivetran solving and how is that benefiting you?** We are able to send data to the tools used by other teams with a very low effort. As a data engineer, in the past, I had to create custom scripts to sync tables in our data warehouse with our CRM, and now it just takes 5 minutes to start sending data to other platforms. We don't need to care about state management, breaking changes in the APIs, maintaining custom scripts...That's saving our team a lot of time. **Official Response from Roslyn Coutinho:** > Glad to hear we're saving valuable engineering time! Thanks for sharing such insightful feedback regarding a sandbox environment. Enabling a more seamless DataOps workflow is on our roadmap, and version control and environments is very much top of that list. ### 11. Very easy to use and very useful to automate and avoid unnecessary repetitive work **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** September 19, 2022 **What do you like best about Fivetran?** Using the tool to automate processes and avoid unnecessary work by making things very efficient thru queries and scheduled runs **What do you dislike about Fivetran?** Tool is easy to use when you get the hang of it, but maybe would make a quick runthru tool to make sure you know what to use while onboarding **What problems is Fivetran solving and how is that benefiting you?** Automating processes that would otherwise require a whole team to stay on top of and manage ### 12. Easy to use for nontechnical people **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Entertainment | Small-Business (50 or fewer emp.) **Reviewed Date:** November 23, 2022 **What do you like best about Fivetran?** Has a lot of integrated sources and destinations **What do you dislike about Fivetran?** The connection to apple store is not the best, but I think it is from apple side. **What problems is Fivetran solving and how is that benefiting you?** Connect our marketing and sales data to our DWH. ### 13. Amazing tool **Rating:** 5.0/5.0 stars **Reviewed by:** Virginia L. | Data engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** September 16, 2022 **What do you like best about Fivetran?** Very easy to used, my team really likes it **What do you dislike about Fivetran?** I don't think that Census have anything bad **What problems is Fivetran solving and how is that benefiting you?** Synchronising the data with our analytics tools ### 14. All I need to push data from my DWH back to CRM **Rating:** 4.5/5.0 stars **Reviewed by:** Jure K. | Business Intelligence Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** September 21, 2022 **What do you like best about Fivetran?** Easy use, good overview, lots of connectors... **What do you dislike about Fivetran?** Could use more sync fields in the lower packages... **What problems is Fivetran solving and how is that benefiting you?** Getting important data and calculations from our DWH into our CRM. ### 15. Redefining Data Synchronization **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Automotive | Small-Business (50 or fewer emp.) **Reviewed Date:** August 22, 2022 **What do you like best about Fivetran?** The best thing about Census is that it helps in managing data on the client side and using the same data for synchronizing across different platforms using integrations. The best thing is that data is being managed on a single side. **What do you dislike about Fivetran?** Sometimes is it not easy to use as it involves setting up integration and establishing database connections. It can be enhanced by working on a better API integration setup. **What problems is Fivetran solving and how is that benefiting you?** The major problem is often with managing the database and synchronizing it across other platforms. It not only enables data synchronization but also ensures data security. Moreover, data sync scheduling is also the best feature that actually helps in setting up campaigns on Facebook and Linkedin. ### 16. Reduces the workload of a small team & good customer support while onboarding **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** November 17, 2022 **What do you like best about Fivetran?** Easy to use. Good documentation. Good Customer Support. Exhaustive. **What do you dislike about Fivetran?** Expensive. Needs work for more complex data sources. Doesnt pull all data from sources such as Drip & Intercom **What problems is Fivetran solving and how is that benefiting you?** Data extraction from varied number of sources ### 17. With Census, our entire team has access to the right data in the tool they are using **Rating:** 5.0/5.0 stars **Reviewed by:** Ophely N. | Co-founder, Small-Business (50 or fewer emp.) **Reviewed Date:** November 21, 2022 **What do you like best about Fivetran?** The quick onboarding and the integrations **What do you dislike about Fivetran?** Everything is working so well and they are the only major player on the market **What problems is Fivetran solving and how is that benefiting you?** Access to the right data in the right format to make decisions ### 18. FiveTran Gets it Done **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Human Resources | Small-Business (50 or fewer emp.) **Reviewed Date:** May 10, 2022 **What do you like best about Fivetran?** FiveTran isn't perfect, and we had some concerns about their pricing model -- but DAMN does it work really well. It took us about 30 minutes to configure everything and have data replicating from source system to data warehouse. Well worth the cost. **What do you dislike about Fivetran?** Pricing model gives me some pause, and I don't like that there is an upcharge to version data (e.g. store different permutations of rows as data changes... but again it's worth it). **Recommendations to others considering Fivetran:** Make sure to re-evaluate and investigate other vendors (e.g. AirByte), but if you need to move quickly and can afford it, Fivetran is best in class. **What problems is Fivetran solving and how is that benefiting you?** Replicating data from source systems to data warehouse. This helps our small team focus on modeling data and driving business value rather than on extracting and loading data. ### 19. Phenomenal Product **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** May 11, 2022 **What do you like best about Fivetran?** The best part about Census is it allows us to send data from our warehouse back into data sources such as Salesforce and Intercom. Additionally, it has the capabilities to use data models to drive slack alerts. **What do you dislike about Fivetran?** The one function that doesn't exist yet is direct messaging someone in slack. Right now you can only sync data into a slack channel. It'd be great to have the ability to direct message, someone, from slack via Census **What problems is Fivetran solving and how is that benefiting you?** We have solved a variety of problems, the biggest being helping operationalize our data and give it to employees that can quickly take action on it. Additionally we have enhanced our salesforce environment with custom metrics and KPIs from data in our warehouse. **Official Response from Roslyn Coutinho:** > Hi there, thanks for taking the time to share your review. We have some exciting improvements to our Slack integration on the roadmap – so watch this space! ### 20. Census for data-driven sales team **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** March 17, 2022 **What do you like best about Fivetran?** Census is a great tool to operationalize the data warehouse data. Our main use case was sending data to salesforce. Easy to setup, use, create syncs, trigger syncs with dbt cloud! Syncs are much faster and reliable than the alternative tools I've tried. Great support team, always timely with their answers. **What do you dislike about Fivetran?** Some features I would suggest: 1. Being able to change the dbt model of an existing sync. 2. Improvements on Amplitude sync to be more flexible 3. Admin controls I would also suggest having a user generated content on how users use census and how they solve challenges. Sharing best practices would also go a long way, specially during onboarding phase. **What problems is Fivetran solving and how is that benefiting you?** Our use cases are mainly sales analytics and behavioral analytics. We are using census to sync data to Salesforce and Amplitude. Our use cases may grow to also include marketing automations **Official Response from Katy Yuan:** > Hi there, amazing to hear that Census is faster and more reliable than the other alternatives you tried. We're working on everything you suggested so stay tuned for big improvements! ### 21. A fantastic tool that is only getting better **Rating:** 5.0/5.0 stars **Reviewed by:** Matthew C. | Analytics Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** February 16, 2022 **What do you like best about Fivetran?** Census allows us to quickly and securely sync bespoke audiences with our third party marketing tools, such as Braze, Google Ads and Facebook. While Census itself is fantastic, what sets this product apart is the team behind it. They are highly responsive to service inquiries and are always receptive to feature requests that meet the demands of our growing business. **What do you dislike about Fivetran?** Census has some work to do before it becomes a mature product. Technical issues impacting syncs are more frequent than ideal, though these are typically resolved quickly. Some of our third party marketing tools charge us for the volume of data we send. Census occasionlly struggles to find the right balance between economically processing updates with sync speed. **What problems is Fivetran solving and how is that benefiting you?** Census allows us to have one centralized platform for sending company data outside the organization to our third-party providers. This eliminates the need to interact with multiple different systems, which is ideal from both an efficiency and security perspective. **Official Response from Katy Yuan:** > Hey Matthew, appreciate the shoutout for our product & success teams! We're grateful for customers like you who help us grow and improve :) ### 22. Census review **Rating:** 2.5/5.0 stars **Reviewed by:** Verified User in Retail | Mid-Market (51-1000 emp.) **Reviewed Date:** September 20, 2022 **What do you like best about Fivetran?** The ability to automatically sync audiences is a big win for us. **What do you dislike about Fivetran?** No downsides so far. A small annoyance from a marketing perspective is the term "reverse ETL." For me, that term comes off as a buzzword in a field that is already bogged down by buzzwords. **What problems is Fivetran solving and how is that benefiting you?** Census is helping us to gather insights across multiple ad platforms. ### 23. A very valuable, resilient, and flexible Reverse ETL Tool **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Photography | Mid-Market (51-1000 emp.) **Reviewed Date:** June 24, 2022 **What do you like best about Fivetran?** Census supports more integration destinations than I've seen in the market, and their team is always open to feedback on connector improvements and additions to their suite. **What do you dislike about Fivetran?** The pricing structure has been difficult to navigate at times. Depending on the destination, its addition can have a very large impact to cost (ex. Netsuite, SalesForce). **What problems is Fivetran solving and how is that benefiting you?** We use Census to push customer data down to a variety of tools from our enterprise data warehouse. This includes tools such as SalesForce Marketing Cloud, and Zendesk. Additionally, upon signing with Census, they partnered with us to develop a Pendo connector, which we still use today. ### 24. Census is a great tool for the modern stack **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** September 19, 2022 **What do you like best about Fivetran?** Simple, easy to use, and straightforward interface **What do you dislike about Fivetran?** End users have troubles defining segments **What problems is Fivetran solving and how is that benefiting you?** Loading data from a central data warehouse to an external tool such as Salesforce ### 25. Make reverse ETL easier to maintain and enable non-engs **Rating:** 5.0/5.0 stars **Reviewed by:** Frances F. | Senior Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 28, 2022 **What do you like best about Fivetran?** Census UI is clean and user-friendly. Non-engineers can config the connections, edit mappings and check the status of syncs. It also makes reverse ETL (multiple destinations) easier to maintain for the data eng team. **What do you dislike about Fivetran?** I asked Census about connector supporting Mixpanel lookup table a while ago and it is live now! So please developing more connectors and more supported objects. Role based permission managment is also needed. For example, admin is able to create and config source and destinations, while basic user can only edit mappings/schedule in syncs, etc.. **What problems is Fivetran solving and how is that benefiting you?** I used to develop reverse ETL system with Python and Airflow for destinations like Eloqua, Mixpanel, Braze, Intercom, and Salesforce. Every destination requires different data types, formats, rate limits, and API requests. Census sets me from maintaining my custom code, so I can spend more time to optimize the system itself. The user-friendly UI enables non-engineers and stakeholders to adjust columns, mappings, and schedules. They can check the status of syncs anytime they want; they no longer need to ask if the data was synced successfully and when was the last sync. **Official Response from Katy Yuan:** > Hey Frances, love how you're enabling both data and ops teams with Census, and syncing to so many different tools. We're working on role-based access controls and will continue to develop cool new integrations. ### 26. Great Reverse ETL Tool **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Retail | Mid-Market (51-1000 emp.) **Reviewed Date:** September 16, 2022 **What do you like best about Fivetran?** Easy to use and works with dbt! We love it for getting data into google sheets out of our snowflake database. Its also great for getting data into google ads or hubspot/salesforce. **What do you dislike about Fivetran?** Nothing to complain about! They initially didn't have an airtable connection - but it appears they have that now. Will be going back and checking that out soon! **What problems is Fivetran solving and how is that benefiting you?** Avoiding having to write ETL with talend or manually writings jobs to get data out of our database(s) and into various cloud based platforms and apps. Using Census is about 10x faster that the traditional methods. ### 27. Census Review!! **Rating:** 4.5/5.0 stars **Reviewed by:** Piyush C. | Software engineer , Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** May 12, 2022 **What do you like best about Fivetran?** Some incredible features I would like to mention are, 1. With Census sharing data is very easy. 2. Census is the best tool for the data team, it is very optimized! 3. Good support team! **What do you dislike about Fivetran?** Overall, there aren't any big issues with Census, but few things which can be improved are: 1. Slack integration can be improved, for example- sending DM's. **What problems is Fivetran solving and how is that benefiting you?** Many things have improved in our day-to-day routine, like sending data to tools such as Salesforce is a lot quicker. **Official Response from Roslyn Coutinho:** > Hi Piyush, thanks for your feedback. We have some exciting improvements coming to our Slack integration soon, so watch this space! ### 28. Fivetran is the best ETL in the industry. No questions! **Rating:** 5.0/5.0 stars **Reviewed by:** Kaleb B. | marketing engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** August 23, 2022 **What do you like best about Fivetran?** The ease of use and dashboard The support team The documentation **What do you dislike about Fivetran?** Pricing model can be a bit confusing and hard to understand **What problems is Fivetran solving and how is that benefiting you?** Helping us solve our entire data ingestion stack ### 29. Great tool for connecting warehouse to other tools **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** August 04, 2022 **What do you like best about Fivetran?** Really easy setup Census and they have great customer support. Whenever I've had a problem, they have managed to resolve my problem promptly and efficiently. I'd recommend Census to a friend. **What do you dislike about Fivetran?** Their new jump in pricing was a surprise to us. **What problems is Fivetran solving and how is that benefiting you?** Moving data from our Snowflake warehouse to our other tools such as Hubspot. This helps create a singular source of truth across all of our business units. The logs and alerting are also really helpful ### 30. Functional tool and great support, but mediocre docs **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** May 19, 2022 **What do you like best about Fivetran?** Fivetran is easily one of the most robust ETL platforms I've seen and I was tasked with vetting quite a few of them when looking for extraction solutions. They offer a wide variety of data sources and destinations, covering a broader range of integrations that are relevant to our business than many competitors. They are also one of the few providers I've seen that have a decently functional web interface with comparable API capabilities. We use Powered by Fivetran, which enables us to extract data on behalf of clients without storing credentials or creating apps on our end, which is not a use case many providers support. The overall user and developer experiences for authorization via Fivetran are also fairly seamless. One of the best parts of Fivetran is their support system. My perspective may be biased since my company is on a plan with priority support, but my team has submitted quite a few support tickets and our experience with Fivetran has consistently been far better than our experience with other third-party providers (and we pay for premium support for most partners who offer it). With other partners, we typically run into issues where the first response to a ticket is unhelpful, as lower-level support folks tend to not have the answers we need (or sometimes will provide us with incorrect answers) and we usually have to wait for a ticket to be escalated at least once or twice before we have any resolution. However, most of our Fivetran inquiries and issues have been resolved within 1 or 2 responses, and the level of detail provided is top-notch! **What do you dislike about Fivetran?** Fivetran's documentation is organized in a more intuitive way than that of most software companies, but like many others, the documentation falls out of date quickly and contradicts itself in many locations. Documentation maintenance is difficult, especially when there is so much of it to manage, but we've had several issues where key details are either missing or incorrect (e.g. incorrect connector configs in their API docs, missing data sources on their list of priority-first syncs). The caveat to this is that their support system is great, so we've never had trouble receiving timely responses when we reach out about the discrepancies, but it would be nice to not have to reach out for such trivial questions. **What problems is Fivetran solving and how is that benefiting you?** My company aggregates data from a broad range of data sources and the parts of the integration process that continually proves to be the hardest are authentication and extraction. We don't use Fivetran for transformation, but Powered by Fivetran has allowed us to integrate quickly by eliminating the need to develop apps, build auth flows, and automate API calls. ### 31. Census is a very powerful tool that operates in a very unique space. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Networking | Mid-Market (51-1000 emp.) **Reviewed Date:** August 23, 2022 **What do you like best about Fivetran?** Serves as a key component of the modern data structure, by minimizing data silos and enabling your warehouse as your single source of truth for your data. Census allows customers to leverage their data and activate it in downstream tools. **What do you dislike about Fivetran?** Must be paired with a variety of other tools. Although the value of Census is clear at the moment, if the rETL feature is embedded in other tools moving forward, Census may lose its place in the market. **What problems is Fivetran solving and how is that benefiting you?** Moving data via reverse ETL. Activation of warehouse data in downstream tools. Our customers need Census to activate their warehouse data in downstream destinations. ### 32. most reliable, low-lift solution to data ingestion **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Health, Wellness and Fitness | Mid-Market (51-1000 emp.) **Reviewed Date:** May 17, 2022 **What do you like best about Fivetran?** The product is clean and straightforward to use. Other folks at my company had never used Fivetran before and were able to get their connectors up and running within 15 mins. We are a very small data team relative to the size of our company and having a product that we can essentially set up and not give another thought to has been a gamechanger. Fivetran simply does what I need it to do and my CSM has been super-responsive and helpful whenever I need some additional support. **What do you dislike about Fivetran?** Fivetran has a heftier price tag than the other products in the ELT space. I would like the integrations with dbt to be stronger and more robust (I think this is in the roadmap). I think it would be useful to have more detailed dbt run logs, for dbt run pricing model to better match how users actually use dbt (don't penalize for using high # of modular dbt models). I would find it immensely helpful if Fivetran produced more content on getting everything we need out of the Fivetran-dbt integration: how-to blogs or follow-along videos for leveraging Fivetran's pre-built models, implementing good CI/CD, etc. **What problems is Fivetran solving and how is that benefiting you?** As a small data team, we need to be able to surface the high-level KPIs and metrics that company leaders need - and we need to do it in a way that's both scalable and flexible. Fivetran frees up our time to build data products with our data, and not have to sink any time in to getting our data to some place we can work with it. ### 33. A very easy-to-use interface for your data pipeline needs **Rating:** 4.0/5.0 stars **Reviewed by:** David K. | Data Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** March 21, 2022 **What do you like best about Fivetran?** I use the service for putting data into Salseforce. It is very easy to use and provides an excellent messaging service when there are errors in the data transfer. This is very useful for debugging. **What do you dislike about Fivetran?** The per field billing option is not the best for us given we have a low number of rows, however, every company needs a billing model of some kind. Other than this I have no other complaints. **What problems is Fivetran solving and how is that benefiting you?** pumping data into Salesforce. This saves on the task of writing and maintaining this pipeline ourselves. This is from out data warehouse BigQuery. I have no other uses at current. **Official Response from Roslyn Coutinho:** > Hi David, really appreciate you sharing your feedback, and glad you're enjoying our observability features. As you alluded to, choosing a pricing model is hard :) but we check in regularly to make sure our pricing delivers the most value for our customers, so we’ll definitely take your feedback into account. ### 34. Great user experience and support **Rating:** 5.0/5.0 stars **Reviewed by:** Cecil A. | Analytics Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** October 18, 2022 **What do you like best about Fivetran?** The user interface is so intuitive and the docs are helpful. **What do you dislike about Fivetran?** The recovery can be dangerous if you don't sync properly **What problems is Fivetran solving and how is that benefiting you?** I can centralize data from all my tools and then push to my systems. ### 35. Amazing tool fits in very well for our use cases **Rating:** 4.5/5.0 stars **Reviewed by:** Foram G. | Business Intelligence Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** September 20, 2022 **What do you like best about Fivetran?** The UI is super simple to use and navigate around very easy to test **What do you dislike about Fivetran?** I would like to see some feature upgrades but there is nothing I dislike about it **What problems is Fivetran solving and how is that benefiting you?** Census is helping us with our marketing data sync - Forget me request automation, updating auduiences in Mailchimp ### 36. Most powerful tool in our Stack **Rating:** 5.0/5.0 stars **Reviewed by:** Jeff R. | GTM Operations Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** March 02, 2022 **What do you like best about Fivetran?** The ease of use, the number of connections, and just the overall optimized experience. We use this with Snowflake, Salesforce, and every other tool in our GTM stack. **What do you dislike about Fivetran?** Not a single thing about it, they are constantly improving how the tool works and implementing new features consistently to make it an even better experience. 100/10 - total fanboy **What problems is Fivetran solving and how is that benefiting you?** Ensuring data consistency across all systems, creating automations outside of applications like Salesforce to improve speed and efficiancy, as well as leveraging the write-back ability from to do things that are traditionally not possible with in-app solutions. **Official Response from Katy Yuan:** > Hey Jeff, LOVE that you're starting the Census fan club! We're happy to have amazing customers like you. ### 37. Great tool for analytics engineers **Rating:** 4.0/5.0 stars **Reviewed by:** Elizabeth Y. | Analytics Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** October 18, 2022 **What do you like best about Fivetran?** The ease of setting up syncs and scheduling them. **What do you dislike about Fivetran?** Looking for historical logs of the syncs. **What problems is Fivetran solving and how is that benefiting you?** We had issues managing and pushing data into our multiple systems. Census helped us solve this with ease. ### 38. Gets your data where you need it! **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** August 23, 2022 **What do you like best about Fivetran?** Census allows us enormous flexibility with our data. We aren't wedded to doing everything in salesforce (and therefore restricted by salesforce's limitations). **What do you dislike about Fivetran?** I just wish Census integrated with everything! **What problems is Fivetran solving and how is that benefiting you?** Census allows us to bring the valuable insights from our BI tool back into Salesforce, so we can use Redshift as our source of truth. ### 39. Lume Fivetran Experience **Rating:** 5.0/5.0 stars **Reviewed by:** Greg J. | VP - Business Intelligence, Mid-Market (51-1000 emp.) **Reviewed Date:** May 10, 2022 **What do you like best about Fivetran?** The ease with which connections can be established and the manner in which FiveTran handles delta loads **What do you dislike about Fivetran?** Sometimes we have challenges with the default API connector and the MySQL connectors. **Recommendations to others considering Fivetran:** Leverage built-in connectors with FiveTran as much as possible. Have a DBA ready when working on connections as there are often little nuances that they are needed for. **What problems is Fivetran solving and how is that benefiting you?** Data loading from multiple data sources. Scheduling of data extractions on a daily basis. Love the product. ### 40. Nice no-code ETL solution **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Marketing and Advertising | Small-Business (50 or fewer emp.) **Reviewed Date:** February 21, 2022 **What do you like best about Fivetran?** Flexible table schemas if the API allows. Setting up most of the connectors is straightforward and they have heaps of documentation on the others. I appreciate that they're leaning in to dbt to handle transforms instead of trying to write their own UI. That might be less approachable for some teams, but if you're already converted to dbt it's great. **What do you dislike about Fivetran?** I thought I wouldn't run in to anything it couldn't connect to--but it turns out I do fairly frequently. There are also some undocumented features that are a little frustrating. More than once I've had a customer service rep say they could enable something for me--but if I had not contacted them I wouldn't know that feature existed. Finally you are locked in to schema and table names very early in the process, so if you are going to be connecting a lot of tables in a lot of databases you need to be conscientious about naming conventions early on because changing is a pain. **What problems is Fivetran solving and how is that benefiting you?** Data aggregation for a host of marketing clients. We connect mostly Google Analytics, Google Ads, Facebook Ads. ### 41. Great for mature tech stacks and startups alike **Rating:** 5.0/5.0 stars **Reviewed by:** Xavier S. | Product Manager, Computer Software, Mid-Market (51-1000 emp.) **Reviewed Date:** August 25, 2022 **What do you like best about Fivetran?** ease of use, plug and play, detail of schemas, pre-built dbt packages **What do you dislike about Fivetran?** Pricing is excessively expensive, it is based on volume rather than value. Some datasets are high volume low value and vice versa. We are not willing to spend so much money for low value high volume sets **What problems is Fivetran solving and how is that benefiting you?** Connectors between data sources and warehouse, e.g. Jira, Github etc ### 42. Decent reverse ETL tool **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Insurance | Mid-Market (51-1000 emp.) **Reviewed Date:** June 24, 2022 **What do you like best about Fivetran?** For the most part, Census works well and is easy to use. It does what it says on the tin with little struggle. The Census team also seems to be continuously upgrading their product, and already some complaints I previously would have had have been addressed. **What do you dislike about Fivetran?** - can be difficult to debug errors - unable to see past versions of queries - testing a new sync or a sync change is very limited **What problems is Fivetran solving and how is that benefiting you?** Census allows us to get all of our customer data into Salesforce quickly and easily. ### 43. Exposing advanced analytics metrics to Salesforce **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** September 16, 2022 **What do you like best about Fivetran?** Query-based input payload generation and integration with DBT. **What do you dislike about Fivetran?** Insert jobs to more complex data models with many dependencies. **What problems is Fivetran solving and how is that benefiting you?** Census removes the dev-up requirements for reverse-ETL operations. It simplified the same in our org so Salesforce Architects and Analytics Engineers could easily create transfer jobs without a heavy reliance on Data Engineers. ### 44. Easy button for creating data pipelines into Snowflake **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Medical Devices | Mid-Market (51-1000 emp.) **Reviewed Date:** February 17, 2022 **What do you like best about Fivetran?** After struggling for years to reliably move data from our various cloud and on-prem systems into our data warehouse environment, using custom code, legacy technology, other point solutions, we found Fivetran. In one afternoon with just a little bit of config, Fivetran started replicating data from our cloud-based CRM system into a Snowflake database every 15 minutes, capturing full history of every row update, insert, delete. It's really easy, and it just works. **What do you dislike about Fivetran?** Minor stuff to quibble about. The user interface to select tables (and columns if desired) for replication is fairly limited and manual, especially when trying to switch to history mode on hundreds or thousands of tables one by one. There is an API available to automate some (but not all) of that, but that defeats the easy button aspect. Fortunately, it does many ongoing things automagically, so it was largely a one-time setup thing we had to go through, not difficult, just lots of mouse clicking. With history mode it creates new change records on rows that have changed in the source, even if I have deselected the column(s) that are changing in the source, so a field like "last viewed on" that is frequently changing during the day will create a lot of target record changes and use more credits. **What problems is Fivetran solving and how is that benefiting you?** Fivetran is helping us to get ALL of our essential business data in one place for analysis, alerting, etc. We spent way less time and effort developing and maintaining custom Python scripts just to move data from one place to another, so we can be more responsive to getting data in the hands of business data analysts faster, helping them get insights and take actions to grow revenue or identify and eliminate sources of waste and excess cost. ### 45. Census makes my job easier! **Rating:** 5.0/5.0 stars **Reviewed by:** Aniruddha L. | Director of Engineering, Mid-Market (51-1000 emp.) **Reviewed Date:** March 01, 2022 **What do you like best about Fivetran?** The best part about Census is how quickly I can go from a table in BigQuery to data in Mixpanel. The experience is seamless and a joy to use. **What do you dislike about Fivetran?** The product definitely has some rough edges. For example, I'd love the ability to duplicate a sync so that I don't have to type out redundant information multiple times. However, their team has been really responsive in addressing gaps! **What problems is Fivetran solving and how is that benefiting you?** Using Census, We've been able to get data from our applicant tracking system (Greenhouse) into Mixpanel, and for the first time we have visibility into our entire recruiting funnel! **Official Response from Katy Yuan:** > Hi Aniruddha, happy that your experience with Census has been great! We'll continue to grow & improve to serve customers like you. ### 46. It works very well once setup correctly. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Oil & Energy | Small-Business (50 or fewer emp.) **Reviewed Date:** November 27, 2022 **What do you like best about Fivetran?** Fivetran is very easy to use and it works without much of a hassle. **What do you dislike about Fivetran?** It doesnt have enough connectors and adding more connectors is not as easy. **What problems is Fivetran solving and how is that benefiting you?** I am using Fivetran to connect our excel data in sharepoint with Snowflake and it worked quite well. ### 47. The product has been very good and the people have been very good to work with. **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Food & Beverages | Enterprise (> 1000 emp.) **Reviewed Date:** June 24, 2022 **What do you like best about Fivetran?** The product is very simple to implement and was very intuitive. **What do you dislike about Fivetran?** It would be nice to send data to and from multiple sources. For example, if you could send data from Netsuite into Anaplan that would be great. Another example would be instead of just Google Sheets to Anaplan, there was a way to send data back from Anaplan to Google Sheets. **What problems is Fivetran solving and how is that benefiting you?** Helping us get data that was previously in a silo out to a source that's now much more scalable and more insightful. ### 48. Great **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Internet | Mid-Market (51-1000 emp.) **Reviewed Date:** September 23, 2022 **What do you like best about Fivetran?** It's a great Reverse ETL Tool that works well from Redshift to Salesforce **What do you dislike about Fivetran?** Curious about why Census is only a "Reverse" ETL tool and not doing regular ETL functionality like fivertran **What problems is Fivetran solving and how is that benefiting you?** loading data from our product backend into Salesforce ### 49. Very helpful for specific use cases! **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** September 21, 2022 **What do you like best about Fivetran?** Easy to set up and get the data where we need it **What do you dislike about Fivetran?** Sometimes sync fails for no specific reason but usually resolves itself **What problems is Fivetran solving and how is that benefiting you?** We have data stored in various tools/systems and this is helpful in getting everything to sync together ### 50. Great number of connectors, straightforward and easy to optimize pricing **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Health, Wellness and Fitness | Small-Business (50 or fewer emp.) **Reviewed Date:** August 05, 2021 **What do you like best about Fivetran?** Very easy to get started, large number of well maintained connectors, and good support **What do you dislike about Fivetran?** Transformations product is not very well developed, not allowing me to use Fivetran to cover more of the data value chain **Recommendations to others considering Fivetran:** Ensure that you have enough connector coverage into your needs, and also be careful about varying row counts (Segment is going to be notoriously expensive compared to a snapshot view like for Shopify or some other SaaS tool). **What problems is Fivetran solving and how is that benefiting you?** Fetching data from SaaS services, not having to maintain API contracts for these services saves engineering time. ## Fivetran Discussions - [How else are you using Census?](https://www.g2.com/discussions/how-else-are-you-using-census) - 1 comment, 2 upvotes - [How to sync data from Snowflake to Salesforce.](https://www.g2.com/discussions/how-to-sync-data-from-snowflake-to-salesforce) - 1 comment, 2 upvotes - [When will an s3 destination be made available?](https://www.g2.com/discussions/when-will-an-s3-destination-be-made-available) - 1 comment, 1 upvote - [Is there a way to reduce the premium fee?](https://www.g2.com/discussions/is-there-a-way-to-reduce-the-premium-fee) - 1 comment, 1 upvote - [Can I reuse a google sheet's name that I just deleted?](https://www.g2.com/discussions/50619-can-i-reuse-a-google-sheet-s-name-that-i-just-deleted) - 1 comment, 1 upvote - [View Fivetran pricing details and edition comparison](https://www.g2.com/products/fivetran/reviews?page=37§ion=pricing&secure%5Bexpires_at%5D=2026-07-21+09%3A40%3A15+-0500&secure%5Bsession_id%5D=85739cd7-9c92-40eb-9235-55d6608e88b9&secure%5Btoken%5D=d5de1a6f89e78135cfa9be30390198bf7e1e2ec2b38eb58dfe2b15932b9fc137&format=llm_user) ## Fivetran Integrations - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - [Databricks](https://www.g2.com/products/databricks/reviews) - [Google Ads](https://www.g2.com/products/google-ads/reviews) - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) - [PostgreSQL](https://www.g2.com/products/postgresql/reviews) - [Shopify](https://www.g2.com/products/shopify/reviews) - [Snowflake](https://www.g2.com/products/snowflake/reviews) ## Fivetran Features **Functionality** - Diverse Extraction Points - Data Structuring - Consolidation - Data Cleaning - Cloud Extraction - Visualization **Management** - Reporting - Auditing **Management** - Real-Time Analytics - Solution Integration - Infrastructure Compatibility - Monitoring **Management** - Disaster Recovery - Remote Backup - Storage Formats - Scheduled Backups - On-Demand Restoration **Functionality** - Extraction - Transformation - Loading - Automation - Scalability **Solution Provision** - System Failover - Pay by Usage - Service Provision **Diverse Extraction Points** - Diverse Extraction Points **Reporting** - Activity Monitoring - Documentation - Alerts/Notifications **Security** - Data Encryption - Security and Compliance - Deduplication ## Top Fivetran Alternatives - [Skyvia](https://www.g2.com/products/skyvia/reviews) - 4.8/5.0 (331 reviews) - [Hevo Data](https://www.g2.com/products/hevo-data/reviews) - 4.4/5.0 (287 reviews) - [Boomi Data Integration](https://www.g2.com/products/boomi-data-integration/reviews) - 4.7/5.0 (120 reviews)