--- title: Fivetran Reviews meta_title: 'Fivetran Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 820 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: 820 scale: '5' date_modified: '2026-07-22' 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:** 820 ## 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. Great UX and intuitive design **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Consumer Goods | Mid-Market (51-1000 emp.) **Reviewed Date:** September 21, 2022 **What do you like best about Fivetran?** The excellent UI and UX make the tool easy to pick up quickly and understand. Having never used Census before I was able to log in and fix an issue with a sync within just a few minutes. **What do you dislike about Fivetran?** I was not able to solve an error alone with a new sync due to a type case error and had to reach out to the census support team. In the end the error turned out to be different from the what was displayed in Census, so it made troubleshooting difficult. **What problems is Fivetran solving and how is that benefiting you?** We are able to create models in our DWH and send that output back to our CRM Tool Klaviyo easily. So Census is acting a reverse ETL tool for us. ### 2. Good product; exceptional customer support **Rating:** 4.5/5.0 stars **Reviewed by:** Elaine M. | VP of Data Science, Small-Business (50 or fewer emp.) **Reviewed Date:** May 04, 2022 **What do you like best about Fivetran?** Fivetran does its job well, and we've had it running for months without issues. What has really stood out about Fivetran though is the support we've gotten from our account rep, both during our trial and since. He has been very quick to respond helpfully to questions, and worked hard to resolve an issue we had that required action by another vendor (for one of the connecting SaaS products we were syncing data from). As an early stage startup, we're a small account, but we never felt de-prioritized. Knowing we can get expert help resolving questions related to Fivetran is part of making it a reliable part of our data stack, and I would be eager to choose Fivetran again in the future because of this. We had also trialed Fivetran two years prior to our ultimate adoption, and the support from a different set of folks at that time was also superb. They were very upfront about what was and was not possible, and understood when we decided it wasn't a good fit for us at the time. The positive experience I had then was part of why I reached back out when I thought we were ready to get value from Fivetran. The feeling of partnership to determine whether there was a good fit, instead of pressure to sign up no matter what, was refreshing. **What do you dislike about Fivetran?** It's hard to anticipate which connectors will be up and running with the push of a button, and where there might be snags (often outside of Fivetran's control). One of the key connectors we wanted to use required a substantial upgrade of our account with the other vendor, which we didn't realize would be necessary. However, the trial period with Fivetran was very effective in helping us identify these issues before we committed to using Fivetran, and the responsiveness of our account rep helped minimize the pain points. For the majority of the connectors we set up, it really was very easy to get going. **Recommendations to others considering Fivetran:** Make good use of the free trial period, it really helps you understand how it will work for you **What problems is Fivetran solving and how is that benefiting you?** For data sources that have Fivetran connectors, we've been able to sync data from these products into our BigQuery data warehouse with almost no setup or maintenance required. In all cases, we could have built these connections ourselves, but I'm very happy to enable my team to focus on truly custom work related to our business specifics, and pay for Fivetran to handle the rest for us. Especially in an environment where data scientists and engineers are in high demand, I don't want them to spend time re-inventing the wheel when we can access the work Fivetran has already done for common sources. ### 3. Great tool for reverse ETL **Rating:** 4.5/5.0 stars **Reviewed by:** Britta C. | Senior Data Consultant, Mid-Market (51-1000 emp.) **Reviewed Date:** August 24, 2022 **What do you like best about Fivetran?** Census is great to automate reverse ETL processes, such as uploading offline conversions to marketing channels. The tool is set up extremely fast and very intuitive. On top of that the service provider is very helpful and responsive making the tool implementation a smooth experience. **What do you dislike about Fivetran?** Census seems to be useful for quite specialized use cases. Some companies might prefer to build their own APIs or rather use a bigger CDP. While I do see advantages in using Census, it might not be the case for everyone. **What problems is Fivetran solving and how is that benefiting you?** Automated processes that needed to be done manually before and can therefore also now be done in a timely matter (and not only once per month for example). The feature of alerts when something was wrong is also very useful, so issues can be resolved quickly. ### 4. Great Product and Amazing Support **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.) **Reviewed Date:** December 14, 2022 **What do you like best about Fivetran?** One of the best things about Census is not only the amazing support team but the willingness to assist and dev new connectors that do not exist. **What do you dislike about Fivetran?** We have not seen any downsides to using Census. It has really helped out team. **What problems is Fivetran solving and how is that benefiting you?** One of the major issues we had was having a all in one solution for all our Marketing Data needs. Instead of creating custom API's we now use Census for all our ETL needs. ### 5. Reliable Extraction tool with a good number of integrations **Rating:** 4.5/5.0 stars **Reviewed by:** Siddhartha S. | Co-Founder , Small-Business (50 or fewer emp.) **Reviewed Date:** November 24, 2022 **What do you like best about Fivetran?** Connecting data sources is easy and reliable once when the connection is made. There are hardly any syncs that fail. **What do you dislike about Fivetran?** Less number of integrations on the engineering tooling space. Like say bitbucket, clickup etc. **What problems is Fivetran solving and how is that benefiting you?** Fivetran helps us build integrations with our platform in minutes instead of weeks. ### 6. Helped us a lot **Rating:** 5.0/5.0 stars **Reviewed by:** Matthew J. | Sales Operations, Mid-Market (51-1000 emp.) **Reviewed Date:** October 19, 2022 **What do you like best about Fivetran?** Census made it really easy for us to conduct simple reverse-etl tasks without having to get our engineering team involved. This made it a lot easier to make changes when we needed to do so. **What do you dislike about Fivetran?** There is a bit of a learning curve with the software, and those who are more senior level or less-technical might have a bit of a higher lift to become proficient in the tool. **What problems is Fivetran solving and how is that benefiting you?** Census allows companies to take data from disparate places such as product databases or tools that do not natively connect to crm systems. These extra connections make it much easier to share insights. ### 7. Great SaaS reverse ETL tool **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Leisure, Travel & Tourism | Enterprise (> 1000 emp.) **Reviewed Date:** December 23, 2022 **What do you like best about Fivetran?** Easy and intuitive interface with out of the box reverse ETL functionality. Minimum maintenance, variety of connectors and great uptime. **What do you dislike about Fivetran?** - Lack of version control (like Git) - Field based pricing model can get costly for certain connector types and use cases **What problems is Fivetran solving and how is that benefiting you?** Census allows us to quickly sync data from our data warehouse to a variety of business systems and eliminates unnecessary dev time ### 8. Allows us to get better use out of our data **Rating:** 5.0/5.0 stars **Reviewed by:** Sophie S. | ABM Marketing Program Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** February 28, 2023 **What do you like best about Fivetran?** Easy to integrate and use, and we get better ROI out of our other tech solutions. **What do you dislike about Fivetran?** Nothing to complain about, we love Census **What problems is Fivetran solving and how is that benefiting you?** Helps us integrated and analyze our data better in a more unified way. ### 9. Simplify your reverse etl process! **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Retail | Mid-Market (51-1000 emp.) **Reviewed Date:** August 17, 2022 **What do you like best about Fivetran?** Census makes sending data to third-party companies a breeze! It just WORKS, I rarely have to pay attention to my data feeds. When something fails, I'm immediately alerted, and Census' support team is fantastic at responding to my questions - often even finding issues with failed feeds and fixing them before I realize they're broken! **What do you dislike about Fivetran?** There is nothing I truly dislike about Census. However, I would like to see more destinations. So really my only dislike is I want Census to do more for me! **What problems is Fivetran solving and how is that benefiting you?** Census takes away the need for me to write complex feeds to our third-party vendors and set schedules for data to send to them. I am able to just feed a query to census and click run, set a schedule, and let it do it's thing! ### 10. Census has made it seamless to connect our databases with our CRM **Rating:** 4.0/5.0 stars **Reviewed by:** Rahul J. | Senior Manager, Business Operations and Strategy, Mid-Market (51-1000 emp.) **Reviewed Date:** September 21, 2022 **What do you like best about Fivetran?** I like the automated sync using cron functionality, along with the ability to easily map fields from BigQuery --> Hubspot - it makes my job easier. **What do you dislike about Fivetran?** I dislike the troubleshooting functionality when uploads fail - it'd be nice to receive more proactive support in these situations. **What problems is Fivetran solving and how is that benefiting you?** Census is solving our ability to unify our systems and create easier access to data. There should be significant long-term benefits from this system as we scale the business. ### 11. Data Engineers Shouldn't Write Reverse ETL **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Internet | Small-Business (50 or fewer emp.) **Reviewed Date:** September 16, 2022 **What do you like best about Fivetran?** Having written scripts myself to do "reverse ETL" or data activation or whatever we're calling it these days, I can confidently say that most teams shouldn't do this. Census is an excellent tool with all of the features and integrations one would expect. The support is great as well. **What do you dislike about Fivetran?** No complaints. When I started using Census, it was a bit more nascent. It took some time to figure out the nuance. However, it's improved quickly and is even easier to get started with today. **What problems is Fivetran solving and how is that benefiting you?** Census helps the teams I work with send consistent data to various tools like Salesforce, and helps establish the data warehouse as the hub for information used across the businesses. ### 12. Census a best way to manage your data warehouse ? **Rating:** 4.5/5.0 stars **Reviewed by:** Gourav R. | Co-founder, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** April 29, 2022 **What do you like best about Fivetran?** Census can sit on any of your data and helps you manipulate your data at ease. The census provides a wide range of scope to interact with your data warehouse, You name it and they have it Google big query etc. Using census is pretty simple, having a good knowledge of SQL will help you cope with the Census platform. **What do you dislike about Fivetran?** Census has many features but when we compare census with CRM platforms like salesforce, I feel census could do better and develop a CRM platform. I'm not sure about their cross-platform support but a mobile application will make census shine in the dark sky. **What problems is Fivetran solving and how is that benefiting you?** Before using Census, all the data had to be entered or retrieved manually. Census lets me automate a few of the simple yet important steps to create an impact. Census has helped me save my time and reduce manual errors drastically. ### 13. Great solution for Reverse ETL **Rating:** 5.0/5.0 stars **Reviewed by:** Joël L. | Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** September 21, 2022 **What do you like best about Fivetran?** Easy way to sync data to multiple systems. In addition, support is great through Slack channel. On demand they are willing to build additional features and/or syncs. **What do you dislike about Fivetran?** Although Census gives a notification when a sync fails, it would be a nice if Census also automatically retry the sync. Often on subsequent run, the sync does succeed. **What problems is Fivetran solving and how is that benefiting you?** Syncing data from our DWH to other systems with easy configuration which non-technicals users also understand. ### 14. Happy Fivetran User **Rating:** 4.0/5.0 stars **Reviewed by:** Michael K. | Head of ERP & Data, Small-Business (50 or fewer emp.) **Reviewed Date:** May 19, 2022 **What do you like best about Fivetran?** I like the amount of out of the box connectors that are available to use straight away which comes with step by step instructions on how to easily setup. The support which is available when you need assistance is excellent as well. **What do you dislike about Fivetran?** The enhancement requests process could be a bit better. It is difficult to see where each of the request are at and whether there is any realistic chance of them getting onto the product roadmap. **Recommendations to others considering Fivetran:** Make sure you know what data you are going to consume and plan to consume to ensure you can get an accurate estimate. **What problems is Fivetran solving and how is that benefiting you?** We needed a tool which was easy to use and required minimal maintenance and that is exactly what we are getting. We are able to setup data pipelines with ease and quickly. ### 15. Fivetran Review **Rating:** 5.0/5.0 stars **Reviewed by:** Adoba Y. | Co-Founder & Product, Small-Business (50 or fewer emp.) **Reviewed Date:** February 21, 2023 **What do you like best about Fivetran?** Best platform for building automated data pipelines. **What do you dislike about Fivetran?** Nothing to dislike about Fivetran, seamless use. **What problems is Fivetran solving and how is that benefiting you?** Needed to help our clients aggregate their data from multiple sources and then centralize it for their use. ### 16. Great team to work with **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** May 19, 2023 **What do you like best about Fivetran?** People - their team are great, very collaborative and amazing to work with! **What do you dislike about Fivetran?** Nothing - so far, so good! A pleasure to work with! **What problems is Fivetran solving and how is that benefiting you?** Reverse ETL ### 17. Great product **Rating:** 4.0/5.0 stars **Reviewed by:** Ian G. | Strategic Accounts, Mid-Market (51-1000 emp.) **Reviewed Date:** February 21, 2023 **What do you like best about Fivetran?** It gets our data back into Salesforce very quickly **What do you dislike about Fivetran?** I dont have any meaningful feedback to share **What problems is Fivetran solving and how is that benefiting you?** Integrating data back into salesforce for the purposes of managing our customer data ### 18. Reliable fast moving ETL service **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Primary/Secondary Education | Mid-Market (51-1000 emp.) **Reviewed Date:** September 21, 2022 **What do you like best about Fivetran?** They were very fast to deliver an integration that we were looking for when we were missing it initially during our trial period, and had professional and quick response times on any questions we had. **What do you dislike about Fivetran?** A downside is they haven't yet got an integration with all of the services in use at our company for which we would like to setup a Census sync, but that is something that might change given time. **What problems is Fivetran solving and how is that benefiting you?** Getting the data that we collected into the services and applications in use by the various teams within our company, and have these syncs setup in a developer and maintenace friendly way. ### 19. Easy to use **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** September 16, 2022 **What do you like best about Fivetran?** Census was really easy for us to setup and start solving data flows with. It's become a core part of our tool stack. The UI is intuative and the tool was able to make the connections we needed between AWS, BigQuery, etc. **What do you dislike about Fivetran?** Support can sometimes take a little longer to come back on requests which can cause delays. Not a major issue, and probably more driven by us being a faster organization that wants answers immediately **What problems is Fivetran solving and how is that benefiting you?** Makes the connection of data super simple. We have so much information floating around and census has accelerated our centralizing of data giving us better access to a single-source of truth ### 20. Excellent pricing model, good overall functionality **Rating:** 4.5/5.0 stars **Reviewed by:** John A. | Associate Director, Product, Mid-Market (51-1000 emp.) **Reviewed Date:** November 22, 2022 **What do you like best about Fivetran?** Fivetran's pricing model allows us to really justify our entire reporting stack and data pipeline, because rather than paying per connector, we get to pay per monthly active row. **What do you dislike about Fivetran?** At this point, I have not run into any dislikes with the platform; nothing has functioned out of the ordinary. **What problems is Fivetran solving and how is that benefiting you?** Fivetran has solved our reporting pipeline requirements; as a digital marketing agency, we have a very broad tech stack and report from several different software. ### 21. Great tool! **Rating:** 5.0/5.0 stars **Reviewed by:** Christopher A. | Marketing Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** December 23, 2022 **What do you like best about Fivetran?** User-friendly UI. Great support and staff. Pricing can be advantageous based on your needs. **What do you dislike about Fivetran?** No downsides, but I encourage consumers to evaluate competitors' pricing models to determine which software is right for you. **What problems is Fivetran solving and how is that benefiting you?** Moving data from your warehouse to other systems. "Reverse ETL". Essential for a maturing data function and a plethora of use cases. ### 22. A great tool to manage your reverse ETL **Rating:** 4.5/5.0 stars **Reviewed by:** Mario S. | Data Architect, Mid-Market (51-1000 emp.) **Reviewed Date:** March 17, 2022 **What do you like best about Fivetran?** The user interface is very clean and easy to use. The latest changes on the interface make it even better to navigate through all your syncs and to validate which tables/sources are been used to sync data into your targets. **What do you dislike about Fivetran?** The lack of information regarding the schedule of each sync. Once a sync is created it will only tell you the name of the source table used and the target and also when was the last time it was updated but it does not tell you at what time it is scheduled to run. This is difficult when you try to manage multiple syncs that affect one specific target (for example, a contact in SalesForce) because you need to go and check the details to know that info. **Recommendations to others considering Fivetran:** Sometimes the support team will take a little bit of time to get through certain issues. They will always have an answer or solution but it may not be promptly. **What problems is Fivetran solving and how is that benefiting you?** Now we can provide better analytics to our SalesForce users by syncing curated tables from our data warehouse with the right information that they need into SalesForce. This has given us the ability to use our resources more efficiently and to empower our sales representatives. **Official Response from Katy Yuan:** > Hi Mario, great to hear we help both the data and sales teams use their resources more efficiently. We'll make sync details more visible in the UI - coming soon! ### 23. Great platform that you can find anything you need **Rating:** 4.5/5.0 stars **Reviewed by:** Purevtsooj D. | Senior Full-Stack Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** February 28, 2023 **What do you like best about Fivetran?** Use everything in one place, number one Data Activation platform **What do you dislike about Fivetran?** all good, just wondering it would need more features **What problems is Fivetran solving and how is that benefiting you?** Great data warehousing system ### 24. My experience has been seamless so far **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Internet | Mid-Market (51-1000 emp.) **Reviewed Date:** November 22, 2022 **What do you like best about Fivetran?** Ease of setup. Lots of connector options. Interaction with Fivetran staff has been very pleasant. **What do you dislike about Fivetran?** Nothing that I can really think of. I don't understand the benefit of doing transformations through Fivetran instead of by myself in my connector. **What problems is Fivetran solving and how is that benefiting you?** Fivetran is helping us better to understand a product of ours with minimal technical resources. In the future it will be easy to replicate what we have for other products of ours. ### 25. I've used Census at 2 companies that were early adopters, I use Census a few times a week. **Rating:** 5.0/5.0 stars **Reviewed by:** David C. | Data & Growth, Mid-Market (51-1000 emp.) **Reviewed Date:** June 29, 2022 **What do you like best about Fivetran?** Census is helpful because with minimal effort/coding I can sync data directly to business systems. Operators can also use the tool because it is straight forward. **What do you dislike about Fivetran?** Debugging can occasionally be difficult. If a model breaks, understanding the issue with the model can take diving into DBT to understand what's wrong. It'd be nice if there was more feedback. **What problems is Fivetran solving and how is that benefiting you?** Census makes it easy for business stakeholders to use clean data in the tool of their choice. It benefits me because now I don't have to be on the line for data reliability questions, things can just match our DWH. ### 26. Census is great **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Consumer Electronics | Mid-Market (51-1000 emp.) **Reviewed Date:** September 20, 2022 **What do you like best about Fivetran?** The team has been very responsive so far. The tool helps us offload some very manual, repetitive work we've been doing forever **What do you dislike about Fivetran?** The support for source control integrations seems limited. To be fair, we do have an open conversation with them about whether we have more options than just DBT cloud, which is yet another tool to maintain -- we don't currently use it. **What problems is Fivetran solving and how is that benefiting you?** Census helps us unify and automate a bunch of either manual or disparate workstreams. We're able to more easily and granularly get data into the tool of our choice without having to maintain a bunch of different logic. ### 27. Reliable solution for reverse ETL **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** November 21, 2022 **What do you like best about Fivetran?** Census is just a reliable product. We have a need to push data from Snowflake to Salesforce and rely on Census to do this daily. It works and I rarely even have to pay attention to it. **What do you dislike about Fivetran?** Census only does batch reverse ETL, so if there were a need for near real time reverse ETL, census wouldn't be an answer. We also tried to push Json data from postgres to json data in S3 and struggled. **What problems is Fivetran solving and how is that benefiting you?** Census helps up move data from analytical database to operational system so people can see the data we've transformed in the place they're working instead of forcing them to a Bi tool. ### 28. Great software! **Rating:** 5.0/5.0 stars **Reviewed by:** Eric C. | Martech, Mid-Market (51-1000 emp.) **Reviewed Date:** September 21, 2022 **What do you like best about Fivetran?** Census has made it possible for us to simplify and expand our usage of audiences for look alikes and suppression lists. **What do you dislike about Fivetran?** There's not much to dislike but I would love to see that they add more destinations to their library. **What problems is Fivetran solving and how is that benefiting you?** Census automates data transfer in a compliance friendly way allowing us to easily scale suppression lists or build look alikes on new channels ### 29. Easy integration and significant shortens time to market **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** November 22, 2022 **What do you like best about Fivetran?** Fivetran was exceptionally easy to integrate into our tech stack and makes data centralization a breeze. We needed to quickly provide data for business side reporting into Redshift and using Fivetran significantly reduced our time to market by weeks. Highly recommend! **What do you dislike about Fivetran?** Not much to dislike really - just needed to learn that deletes in the DB are soft deletes in connected datasources. This is really a very solid tool to have especially when a system has many sources of data. **What problems is Fivetran solving and how is that benefiting you?** Business reporting and centralization of data into a warehouse from multiple sources - reports that took weeks to run, now just take hours post Fivetran integration. ### 30. Fivetran allow us to extract information from almost 20 data source with a few clicks **Rating:** 5.0/5.0 stars **Reviewed by:** Jeffrey S. | CTO, Mid-Market (51-1000 emp.) **Reviewed Date:** November 22, 2022 **What do you like best about Fivetran?** Dont need to code, just with a few clicks you can setup everyting **What do you dislike about Fivetran?** I think can add or develop more adapters **What problems is Fivetran solving and how is that benefiting you?** To have a single datawarehouse to connect our BI tools ### 31. Census works! New features / integrations frequently, but could be better on observability **Rating:** 4.5/5.0 stars **Reviewed by:** Nolan J. | Data Operations Director, Mid-Market (51-1000 emp.) **Reviewed Date:** September 21, 2022 **What do you like best about Fivetran?** There are quite a few integrations and they're always adding more. We were able to solve a significant administrative issue (product utilization) by writing SQL logic that updates Salesforce, saving our Customer Success team hours every week. **What do you dislike about Fivetran?** They're working on their pricing structure and some of their observability features that should be part of the basic paid aren't. Knowing when errors occur, how to resolve them, etc. would be nice to have features. **What problems is Fivetran solving and how is that benefiting you?** We were able to solve a significant administrative issue (product utilization) by writing SQL logic that updates Salesforce, saving our Customer Success team hours every week. ### 32. Fluid integrations requiring minimal effort **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Luxury Goods & Jewelry | Mid-Market (51-1000 emp.) **Reviewed Date:** September 17, 2022 **What do you like best about Fivetran?** Easy connector setup. Queries with relative / calculated dates are easily pulled. Processing speeds seem acceptable for now - still early days using the tool. Target integration works as expected **What do you dislike about Fivetran?** Not so much the tool limitation, however setting up a snowflake connector required adding multiple tables / permissions to snowflake to allow this to work. Made the IT department a little uneasy - monitoring performance and serve usage for now. **What problems is Fivetran solving and how is that benefiting you?** Integrating snowflake with the facebook api and gsheets. using census has rediced the number of intermetiate steps to make this possible. fewer steps, less management and lower risk of issues arising. ### 33. It was really easy to set up and does exactly what we want it to. **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** October 07, 2022 **What do you like best about Fivetran?** The UI is intuitive and makes it easy to accomplish your tasks. Data is refreshed and it's really just a set it and forget it tool. I am very pleased and would recommend! **What do you dislike about Fivetran?** I think more connectors could always be better; it would be great to be able to build a custom connector as well. But overall I've enjoyed the tool quite a bit. **What problems is Fivetran solving and how is that benefiting you?** Pushing data from other systems into Salesforce so we can build bridges/links in our data warehouse. This has been gamechanging for us and how we do analytics!!! ### 34. Set it and forget it **Rating:** 4.5/5.0 stars **Reviewed by:** Chris B. | Data Scientist, Mid-Market (51-1000 emp.) **Reviewed Date:** July 11, 2022 **What do you like best about Fivetran?** Service is reliable. Intuitive UI and configuration. Very helpful support. Informative error reporting and notifications. Easy to set up. Same datasets produced errors in HighTouch. They just worked in Census **What do you dislike about Fivetran?** Haven't found anything we don't like. Would be helpful to have a sync log covering all of our syncs. Paging through the sync logs for individual syncs takes a couple extra minutes when we're digging into the status. **What problems is Fivetran solving and how is that benefiting you?** We've replaced two home-rolled integrations for Salesforce and Hubspot with Census. This switch has allowed us to sync additional data from outside our main app to these tools. Updates to the data syncs can now be performed by analysts rather than software engineers and we have much better visibility into the progress and status of the data syncs ### 35. Good experience **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Online Media | Mid-Market (51-1000 emp.) **Reviewed Date:** September 16, 2022 **What do you like best about Fivetran?** The best feature is the wide array of integrations. Along with the wide range, the ease of setting up the integrations is also a great plus. It's truly a seamless tool. **What do you dislike about Fivetran?** No major dislikes or disadvantages as such **What problems is Fivetran solving and how is that benefiting you?** Quick integrations with other third-party tools, which is helping solve some key business use-cases. Has also helped in reducing the time to implement projects due to the seamless integration options. ### 36. Great Low/No Code ETL and takes the headache out of large, regular data lift and shifts **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Online Media | Small-Business (50 or fewer emp.) **Reviewed Date:** November 17, 2022 **What do you like best about Fivetran?** Easy to use. Quick to get in place. Lots of support for applications and standard connections **What do you dislike about Fivetran?** Can become expensive for data heavy integrations which potentially are still easy or much cheaper with other solutions which means you end up with multiple ETL tools **What problems is Fivetran solving and how is that benefiting you?** Their out of the box connector saved a huge amount of work getting data out of an enterprise platform and across to our data warehouse. ### 37. Easy and efficient way to move data **Rating:** 5.0/5.0 stars **Reviewed by:** Callum H. | Senior Revenue Operations Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** October 06, 2022 **What do you like best about Fivetran?** The error logs and messages are easy to access. Failure retry has also made our error counts fall **What do you dislike about Fivetran?** So far, there is nothing I particularly dislike **What problems is Fivetran solving and how is that benefiting you?** Census allows us to move data from our warehouse to all of our commercial tools. This means all of our data is consistent across platforms ### 38. Nice service to get sources moving. Lots of surprises regarding cost, so plan very carefully. **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in E-Learning | Mid-Market (51-1000 emp.) **Reviewed Date:** November 29, 2022 **What do you like best about Fivetran?** Overall ase of use, quick and thorough setup **What do you dislike about Fivetran?** Costs. Onboarding process with sales was either misleading or simply not thought out well enough; they had verbally assured us of guesstimate costs based on our industry, but once we were using it their estimate was very far off the mark. **What problems is Fivetran solving and how is that benefiting you?** Ease of use in gathering 3rd party data sources that we needed. ### 39. Sync data between all our tools with ease **Rating:** 4.0/5.0 stars **Reviewed by:** Océane . | Data Analyst, Small-Business (50 or fewer emp.) **Reviewed Date:** March 17, 2022 **What do you like best about Fivetran?** - It is very easy to set up a sync pipeline in Census. I can send data to a new tool (Salesforce, Zendesk, GoogleAds) in less than 1 hour and I don't need to worry about it anymore. Before I had to write pipelines in airflow or prefect and check daily if everything was running smoothly. - Support team is responsive and helpful. **What do you dislike about Fivetran?** - Census is improving quickly but some simple features are missing. For example, it is hard to modify a sync once it is created. Very often, the only way to do this is to duplicate manually the existing sync. - For big initial syncs, Census can be quite credit-consuming on Snowflake. **What problems is Fivetran solving and how is that benefiting you?** - Sending data to operational tools such as Salesforce and GoogleAds is quick and reliable. - Monitoring syncing between different tools is easy. - Even people with very light coding skills can use it and debug it. **Official Response from Katy Yuan:** > Hey Océane, great to hear that Census simplifies your operational workflow! Happy to be a part of your data stack and we're working on a way to make duplicating syncs easier. ### 40. Easy to setup, hard to configure **Rating:** 3.5/5.0 stars **Reviewed by:** Paul D. | Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** March 17, 2022 **What do you like best about Fivetran?** Decreases engineering time to create a sync from our data warehouse to 3rd party services. Very nice that Census enforces service-specific best practices and handles deduplication of append events. With Census we can empower our non-engineers to handle data syncs that would otherwise be unaccessible to them. The documentation for specific syncs is also fantastic. **What do you dislike about Fivetran?** There is not much in the way of observability into the syncs you create. They often silently reject data and the alerting is very minimal and doesn't cover these cases. Additionally, many connections are still in active development - for example Facebook CAPI. It does not offer custom event properties and we also encountered a bug after our sync was already live. While there is much less engineering work required to set up a sync, there is still work and for a new destination it roughly took the same amount of time as if we built it ourselves. **Recommendations to others considering Fivetran:** Inquire about the specific service that you plan to use Census to integrate to. The more information Census has in their docs on a particular service, the easier your time will be setting up a sync with that service. **What problems is Fivetran solving and how is that benefiting you?** We are sending data from BQ to our ad platforms. We're solving the problem of needing to delegate this specific task to our engineering department. In this we were successful. Now we are able to hand off this project to our marketing team, who will be able to reference the syncs we have so far to create new syncs for new ad data that we would like to optimize on. **Official Response from Katy Yuan:** > Hey Paul, thanks for sharing your valuable feedback. We're releasing several observability improvements over the next few months and would love your thoughts as a design partner. Glad to hear that we've helped you enable non-engineers :) ### 41. Democratizing the data pipeline **Rating:** 5.0/5.0 stars **Reviewed by:** Robert H. | Analytics Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 28, 2022 **What do you like best about Fivetran?** Census has a highly intuitive interface for any user who would like to quickly and securely sync data sitting in a cloud data warehouse to another SaaS tool. It can remove the need to maintain custom data pipelines (or at least provides a common tap for custom targets/destination APIs). This frees up time for data folks to address other parts of the stack and enables non-technical folks to make their own pipelines. **What do you dislike about Fivetran?** There are bugs to work out as they scale and experience some growing pains, but the support team is very attentive to these issues. Otherwise, there are some highly desired integrations that still need to be built, which might be a detractor for teams who want to completely do away with custom data infrastructure to support reverse ETL processes. **What problems is Fivetran solving and how is that benefiting you?** Census provides a singular place to configure outflows from our data warehouse and has allowed us to remove many of the custom data infrastrucure we were using to manage these outflows (think many different scheduled serverless functions). Their tool makes governance and observability of our pipelines much more straightforward. **Official Response from Katy Yuan:** > Hey Robert, great to hear that Census is highly intuitive and empowers both data and business folks to spend less time on repetitive tasks! ### 42. simple, reliable! **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Primary/Secondary Education | Mid-Market (51-1000 emp.) **Reviewed Date:** January 17, 2023 **What do you like best about Fivetran?** it is pretty simple, easy to use and setup **What do you dislike about Fivetran?** nothing specific, quite happy with cences! **What problems is Fivetran solving and how is that benefiting you?** it helps to sync data from our warehouse to a few other products we use e.g. hubspot, mixpanel ### 43. Great product, easily sync data between our databases with little or no code! **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** September 21, 2022 **What do you like best about Fivetran?** Easy, little or no code solution. We sync data in our databases to Salesforce and can have non-technical people own these processes. Very strong tool that we rely on **What do you dislike about Fivetran?** Nothing, think it's pretty great. Maybe They could support more tools but they already have a plethora of tools that they cover and sync too. Or they could also have their 'Success' records sync be downloadable. **What problems is Fivetran solving and how is that benefiting you?** It's a very strong no to low code solution for syncing data between databases and tools. We sync data from databases to Salesforce and other platforms with ease. ### 44. Integrates with Salesforce **Rating:** 4.0/5.0 stars **Reviewed by:** Chris F. | Salesforce Systems Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** November 21, 2022 **What do you like best about Fivetran?** Connects well with other systems like Salesforce, Databricks, etc.. **What do you dislike about Fivetran?** Not a declarative solution so it requires code **What problems is Fivetran solving and how is that benefiting you?** Contributing to tracking inventory and updating multiple systems ### 45. Does exactly what we need **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** November 30, 2022 **What do you like best about Fivetran?** The user interface is simple and effective. The ramp up time to work with the platform is low, and anyone with integration experience will easily adapt. **What do you dislike about Fivetran?** I am not a fan of the pricing model being based on destination fields. **What problems is Fivetran solving and how is that benefiting you?** It is allowing us to confidently sync data on a daily basis between systems will very little lift. ### 46. A great tool to get data easily into all the places you need it **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** November 21, 2022 **What do you like best about Fivetran?** Census connects to all the destinations that we need. Configuring syncs is easy, and the platform has been reliable. The Census team has been fast, responsive, and exceedingly helpful when we needed support. **What do you dislike about Fivetran?** I wish they let you download the complete set of sync error logs. **What problems is Fivetran solving and how is that benefiting you?** Census lets us get data into crucial business tools without integrating with each tool's API directly. ### 47. Easiest, most reliable way to get your data into Snowflake **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Real Estate | Small-Business (50 or fewer emp.) **Reviewed Date:** May 23, 2022 **What do you like best about Fivetran?** Having connectors for many of the common data sources is terrific, but having a team constantly working to offer even more connectors and improving the existing ones is absolutely amazing. **What do you dislike about Fivetran?** Since I've started using Fivetran the thing that stands out to me the most is their continual improvement. I hated the initial pricing, they changed it. I had trouble with the UI, they changed it. There was a lack of transformation ability, they added dbt. Things that I dislike are typically things that most users will also not like and having Fivetran constantly improving is great. **Recommendations to others considering Fivetran:** Give it a shot - you won't be disappointed! **What problems is Fivetran solving and how is that benefiting you?** Continual ingestion of data from a multitude of different sources has been my job for the last several years, and Fivetran has made that process point and click so I can just focus on the business rules instead of the plumbing. ### 48. census is a good data tool however I find a lot of issues when using it for data syncing to sfdc **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** September 21, 2022 **What do you like best about Fivetran?** Decent interface, decent reporting capability, can be semi confusing for new users, product updates are fairly frequent **What do you dislike about Fivetran?** Integrating and pushing data to salesforce can be patchy and inaccurate compared with other tools, however at least they do offer this ability **What problems is Fivetran solving and how is that benefiting you?** Business allows us to store data external to our CRM from our product and push into our CRM when necessary ### 49. Census review **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** September 21, 2022 **What do you like best about Fivetran?** Makes it easy to get your data from a db to other tools or from other tools to your db. An example: - Syncing properties into marketing automation tool (e.g. Customer.io) from Snowflake **What do you dislike about Fivetran?** Not much to dislike, if you aren't familiar with the data space it can be a little difficult to get started, but I've tried out other "Reverse ETL" tools in the space and Census seems like the easiest to get started with. **What problems is Fivetran solving and how is that benefiting you?** Getting useful data from your data warehouse to other tools that could benefit. Marketing automation is the use case that I've run into the most. Being able to know if a person did certain actions in-product can inform what emails they get, and make the experience feel more personalized and useful for them. ### 50. Would have saved me days **Rating:** 5.0/5.0 stars **Reviewed by:** Brayden H. | Product Manager, Small-Business (50 or fewer emp.) **Reviewed Date:** April 29, 2022 **What do you like best about Fivetran?** Ease of use. You can get up and running in minutes, with little to no training because the platform is so intuitive. The selection of connections is incredible. This would have saved me so much time at my last role where I spent days and days building these connections out bespoke. **What do you dislike about Fivetran?** More and more connections would be great. But that is more a function of the sprawl of the market than Census. Not sure how easy to use this would be without some data experience. Even more intuitive UI for more standard business user could be great. **What problems is Fivetran solving and how is that benefiting you?** Solving for the sprawl of tools in the market and in our company. It's great to have so much flexibility until you need to move data in and out. Without Census you kill yourself trying to keep all your data aligned and moving where you need to be. **Official Response from Roslyn Coutinho:** > Hey Brayden, Thanks for sharing your feedback, we really appreciate it. We totally understand how important it is to support more integrations, and we continue to ship new ones every week – don't hesitate to let us know if there's a particular integration you'd be interested in at hello@getcensus.com. We love hearing that Census is a massive time saver for you! ## 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=9§ion=pricing&secure%5Bexpires_at%5D=2026-07-22+08%3A45%3A41+-0500&secure%5Bsession_id%5D=5eb1c793-f018-4d4c-ab60-ba6500ffadd5&secure%5Btoken%5D=bdea94903c1f5e3294500b0ef9b67e9f8d61679f1d49914d1d071005425ee44a&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 (332 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)