--- title: Fivetran Reviews meta_title: 'Fivetran Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 824 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: 824 scale: '5' date_modified: '2026-07-31' 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:** 824 ## About Fivetran Fivetran is the data foundation for AI. One platform moves, manages, and transforms data from every application, database, event stream, and file your business runs on into a governed foundation that analytics, operations, and AI can act on. Connectors deploy in minutes, run themselves, and adjust automatically when a source changes, so your data team spends its time building, not maintaining pipelines. ## 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. Easy access to Data with Census **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Non-Profit Organization Management | Mid-Market (51-1000 emp.) **Reviewed Date:** August 03, 2023 **What do you like best about Fivetran?** Census is clear, concise, and gives me great insight to the various data sources and flows. I also appreciate the weekly email updates on sync success and other alerts that help me intervene when necessary. **What do you dislike about Fivetran?** The formatting of some of the notification emails can feel cluttered and old-fashioned. **What problems is Fivetran solving and how is that benefiting you?** Census helps us connect our data to various outputs so that other users at my organization (including me) can access data more easily and succinctly. It makes data available for all! ### 2. Easy to use Reverse ETL tool **Rating:** 5.0/5.0 stars **Reviewed by:** Michael M. | Mid-Market (51-1000 emp.) **Reviewed Date:** April 06, 2023 **What do you like best about Fivetran?** The user interface makes it easy to understand which syncs are active and when they were last run. Makes our life very easy when maintaining data cleanliness in Salesforce **What do you dislike about Fivetran?** I wish it was possible to have multiple users as the connection user so that we know who owns which sync. **What problems is Fivetran solving and how is that benefiting you?** Automating data entry and integrity between our data warehouse and Salesforce. ### 3. Tool helping to use data efficiently **Rating:** 4.5/5.0 stars **Reviewed by:** Lalit R. | Data Analyst, Financial Services, Enterprise (> 1000 emp.) **Reviewed Date:** February 23, 2023 **What do you like best about Fivetran?** I like the utilisation part its simple and helps to save time and from my usage this is the one of the best software I have used so far because it has made the data operations simple and easy from all different sources, this is the best part from my usage. **What do you dislike about Fivetran?** Implementation and setting up was something which was something very hectic and took a lot of efforts at integration part, this is something which I dislike but after implementation the tool works seamless. **What problems is Fivetran solving and how is that benefiting you?** Data transfer and utilisation of data from different sources won’t be convenient and easy without census, census has made the process easy and simple and helping to use data from different sources with effortless syncs. ### 4. Census Continues to be the BEST Reverse ETL tool to get data where we need it! **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** March 21, 2022 **What do you like best about Fivetran?** The user interface is simple, yet powerful and as a result - you can move FAST! In the last year, we've been able to replace several engineering-built processes with Census to get Data from BQ to a variety of tools across the business. If your a business that needs to get more complex with DBT and Census Segments, etc, the UX scales very well to support that. The team did a great job and technical and nontechnical team members alike will easily be able to do what they need! **What do you dislike about Fivetran?** Pricing in the last year has come up quite a bit, but it is the best tool on the market - so I guess you have to pay to play. As a business, you'll still save hundreds of thousands a year on not having to hire devs and additional data analysts... **Recommendations to others considering Fivetran:** Do it! **What problems is Fivetran solving and how is that benefiting you?** We've deprecated a backend salesforce driver and completely sync our business critical user data into SF. We also use Census to pipe data into Segment, Zendesk, and soon our accounting tools. **Official Response from Roslyn Coutinho:** > Hi there, thanks for sharing your review. I've passed on your feedback to our product team - we totally understand the little things matter! We also recently shipped the ability to see all your rejected records as a table in your data warehouse, for even greater visibility. ### 5. Very crucial to our data stack **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** April 06, 2023 **What do you like best about Fivetran?** Simple to use, very helpful to integrate **What do you dislike about Fivetran?** Maybe more documentation of the most popular use cases **What problems is Fivetran solving and how is that benefiting you?** Integration with external apps and keeping data references consistent ### 6. Pretty good rETL **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Legal Services | Mid-Market (51-1000 emp.) **Reviewed Date:** August 03, 2023 **What do you like best about Fivetran?** Let's you connect up to your data warehouse with relatively low effort. **What do you dislike about Fivetran?** Not the best connection scoping in the sense of how the connections are organized (i.e., per schema vs per data warehouse) **What problems is Fivetran solving and how is that benefiting you?** Bringing data warehouse data into Salesforce ### 7. Census has mostly met our reverse ETL but has a lot to improve **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** May 18, 2023 **What do you like best about Fivetran?** - Easy to use - Can access metadata via API - Integrates with many services I use - Support team is responsive **What do you dislike about Fivetran?** - Can be buggy/glitchy - UI can be improved - Unable to use the native dbt integration because of technical limitations - Alert configuration is pretty basic - Can only write back logs on an upgraded plan tier **What problems is Fivetran solving and how is that benefiting you?** Census is a no-code solution for reverse ETL, which saves the company engineering time and resources. ### 8. Beast tool for Data **Rating:** 5.0/5.0 stars **Reviewed by:** Alok M. | Director-Lending Operations, Financial Services, Enterprise (> 1000 emp.) **Reviewed Date:** December 16, 2022 **What do you like best about Fivetran?** Census’s have a lot of functions and they are easy to use, Census is must recommended tool for anyone that deal with data on daily operations and I found Census to be reliable solution to handle and organise large information, and is upto the mark in my use case and opinion. The best part is the user friendly user interface that I liked and habitual of as its very sharp and to the point also institutive at the same time, which makes easy to adapt and use without training. **What do you dislike about Fivetran?** Well when it comes to dislike, there is nothing which I disliked particularly and works great for daily operations and there are few bugs which I felt during usage but they gets fixed from the team, so there is nothing to be disliked and fulfilled the purpose and works great on daily basis. **What problems is Fivetran solving and how is that benefiting you?** Sync of data from different sources was never so easy and works perfectly with swift processings and handles error handling very well and sync do not gets affected if inconsistency happens with data and issues can be sorted easily as output is enough to troubleshoot. ### 9. Simple UI yet powerful tool **Rating:** 5.0/5.0 stars **Reviewed by:** Àxel R. | Co-Founder, Mid-Market (51-1000 emp.) **Reviewed Date:** March 02, 2023 **What do you like best about Fivetran?** Connecting your data sources and destinations is a matter of few clicks. Likewise you can set up syncs that will keep all your platforms in sync with your sources. **What do you dislike about Fivetran?** Nothing really. It does what it says. Connection with Firebase would be useful **What problems is Fivetran solving and how is that benefiting you?** We have our source of truth in a data warehouse which then we have to sync to our different platforms. Census allows to keep all these tools in sync with our warehouse. ### 10. Census is friendly place to start your Reverse ELT journey **Rating:** 5.0/5.0 stars **Reviewed by:** Mark S. | Mid-Market (51-1000 emp.) **Reviewed Date:** April 06, 2023 **What do you like best about Fivetran?** Helpful support. Willingness to take on new connectors and tweak existing ones. **What do you dislike about Fivetran?** The UI could use some refinement, but overall very solid. **What problems is Fivetran solving and how is that benefiting you?** Census allows us to find edge cases in our data and assign the correct person to fix very complex issues using Asana and Reverse ETL. This has been a huge benefit to our business. ### 11. Great tool for Salesforce **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** April 06, 2023 **What do you like best about Fivetran?** Our company uses census to streamline our salesforce/database sync process. This makes the sync between these 2 sources much easier and allows for the flexibility we need in a ETL tool. **What do you dislike about Fivetran?** Not much! The tool does everything we need for this solution. **What problems is Fivetran solving and how is that benefiting you?** We have some complex calculations that we perform in a system outside of salesforce. This allows us to selectively sync data back and forth between the data warehouse and SFDC. ### 12. Census Review **Rating:** 5.0/5.0 stars **Reviewed by:** Chinmay A. | Financial Business System Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** December 22, 2022 **What do you like best about Fivetran?** Census tool is very responsive and user friendly. It is easy to udernstand and use by develpoer and ens user. It also provide lot of documentation accross the board which help to gain knowledge. **What do you dislike about Fivetran?** There is not as such which i really dislike about census, but i think the documentation around census should be more in detail like how to write query for syncing data with one or two example each. **What problems is Fivetran solving and how is that benefiting you?** Census is syncing data from billing system to netsuite. since billing system has lot of cons which is easily manageable in census and developer can run query to filter the bad data to sync in NetSuite. ### 13. Fantastic Reverse ETL tool **Rating:** 5.0/5.0 stars **Reviewed by:** Matt M. | Analytics Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** November 21, 2022 **What do you like best about Fivetran?** We use Census to push data from our data warehoues (BigQuery) to third party tools like HubSpot and Salesforce. We've never run into any issues with Census and its UI is simple and intuitive. Love how focused and reliable the product is. **What do you dislike about Fivetran?** There's nothing I dislike about Census. Everyone at the company on the data team as well as those on other teams (marketing, sales) that rely on the data are huge fans. So glad we're no longer using Zapier for this. **What problems is Fivetran solving and how is that benefiting you?** Census lets us update data in HubSpot and Salesforce with data that we have in our data warehouse, BigQuery. This ensures that marketing and sales have easy access to all of the relevant data points about our customers and users. ### 14. Operationalize your data **Rating:** 4.5/5.0 stars **Reviewed by:** Erin H. | Analytics Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** October 18, 2022 **What do you like best about Fivetran?** I love the easy and intuitive interface of Census. The learning curve is very minimal and the tool is easy to pick up and run with. The number of sources and destinations offered are extensive and meet our business needs. **What do you dislike about Fivetran?** If you incorrectly set up a sync, it can be difficult to make changes to the sync without setting up an entirely new sync and deleting the original. Other than that, no complaints! **What problems is Fivetran solving and how is that benefiting you?** Reverse ETL using Census has changed the game for our organization. The ability to get data in the hands of business users without requiring them to leave Salesforce has helped to make our org much more data-driven. Census has removed a layer of friction in that users have key data points where they want them, without having to log into or learn a new tool. ### 15. Nice reverse ETL tool **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** August 04, 2023 **What do you like best about Fivetran?** Nice tool to trigger notifications among many apps and make reverse ETL. **What do you dislike about Fivetran?** Not being able to set some logic for the notifications. **What problems is Fivetran solving and how is that benefiting you?** Sending data back to some apps we retrieve data from. ### 16. My favorite tool in our martech stack!! **Rating:** 5.0/5.0 stars **Reviewed by:** Allison K. | Associate Growth Marketing Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** August 22, 2022 **What do you like best about Fivetran?** A tiny bit of SQL (or help from an analyst) is all you need to create dynamic ad audiences. I couldn't believe how easy this was to set up and start serving ads to our target accounts on LinkedIn and create dynamic exclusion lists on Google! There's almost NO maintenance with these audiences, so we're easily able to test more and more granular subsets of our target account list. I can't wait to use it to enrich our targeting with first party data and not worry about static uploads for offline conversion tracking!! Their team is so helpful if there's an integration I need, and solved a little bug that cropped up in an extremely efficient manner. **What do you dislike about Fivetran?** You can't filter or search for models by name, so if there's a lot of activity on the account, sometimes models that I need to sync from get a little lost. It would be cool to have folders or groups. It does segment your syncs by destination, however that's still tough to sort through if you have a lot. **What problems is Fivetran solving and how is that benefiting you?** The upkeep of static audience lists is essentially gone. It's so simple to exclude our employees and paid users from our ads without having to upload new lists weekly. It's giving us the option to get really granular with our targeting, especially when combined with Mixpanel cohorts. I can find a subset of users that haven't reached the aha moment and create a cohort, define that segment in Census, and sync it to our ad accounts in minutes, serving them helpful articles to nurture them towards success in our product. ### 17. Census is the gold standard for reverse ETL **Rating:** 5.0/5.0 stars **Reviewed by:** Josh M. | Account Executive, Enterprise (> 1000 emp.) **Reviewed Date:** March 01, 2023 **What do you like best about Fivetran?** Most ETL tools do not pull data back into the source and if they do they do it poorly. Census doesn't spread itself to thin but rather focuses on that one critical link in the chain relying on partners for the rest. **What do you dislike about Fivetran?** Census is a great tool but has limitations. I'd recommend really using them for their tried and true use cases like pulling data back into salesforce and using a different tool for more complex database use cases. **What problems is Fivetran solving and how is that benefiting you?** Primarily the one I mentioned of pulling data back into salesforce, they are really good at that, they can also be used to pull data back into other applications. ### 18. Makes data synchronization surprisingly easy **Rating:** 5.0/5.0 stars **Reviewed by:** Agustin B. | Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** September 21, 2022 **What do you like best about Fivetran?** We just pick the source data and fields we want as destinations, and Census does all the hard work. Their documentation is excellent, and it even has a section for common errors, which helped us debug a duplication issue in no time! They also provide an API Inspector to see the requests made during syncs. **What do you dislike about Fivetran?** Census provides many ways to configure whether you want to create new records, update existing ones, do both, delete the removed ones, etc. But when configuring each field, it only has options to update values from the source or only do it if the destination is empty. It would be nice if we could add more smart rules like only update if the source is not empty or only updating field A if field B in destination is not empty, etc. This is not a deal breaker but it would be nice to have. **What problems is Fivetran solving and how is that benefiting you?** Census is helping us keep Salesforce in sync so our business team can access the latest information from our application usage right with all their client notes. Salesforce tends to be frustrating for developers, but Census simplified everything. ### 19. The data ingestion that you neeed **Rating:** 4.0/5.0 stars **Reviewed by:** Bima Putra P. | Analytics Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** November 30, 2022 **What do you like best about Fivetran?** I really like how easily we can set up a destination and connection in Fivetran. Fivetran also supports various connection types that we can use. Moreover, their support team is helpful and responsive. **What do you dislike about Fivetran?** The thing that I dislike is the price that we need to pay. The price is relatively high. Another thing that can be improved as well for my current use case is by improving the data type support in PostgreSQL database. **What problems is Fivetran solving and how is that benefiting you?** The main problem that Fivetran is solving is the complexity and the time required to build our own data ingestion pipelines. Especially when the source was varies. Fivetran solves those issues and make it easy to do data ingestion. ### 20. Great for automating reports database <> Google Sheets! **Rating:** 4.5/5.0 stars **Reviewed by:** Zack S. | Mid-Market (51-1000 emp.) **Reviewed Date:** February 21, 2023 **What do you like best about Fivetran?** Custom queries, dynamic sync times, email alerting **What do you dislike about Fivetran?** clunky interface, difficult to manage column ordering in platform for exports **What problems is Fivetran solving and how is that benefiting you?** Automated query updates to support google-sheets based dashboards ### 21. Intuitive, powerful and reliable **Rating:** 5.0/5.0 stars **Reviewed by:** Jordan S. | Analytics & Reporting Director, Small-Business (50 or fewer emp.) **Reviewed Date:** November 24, 2022 **What do you like best about Fivetran?** After trying a handful of other ETL/ELT tools, it is amazing how intuitive it is to connect sources to your warehouse and start streaming data. We've been able to sync data at a very low latency and with very low costs, thanks to the MAR pricing model. **What do you dislike about Fivetran?** The difficulty of building custom connectors is an issue, as you'd need to have programming experience. Though I hear an easier option for creating custom connectors is on the horizon. **What problems is Fivetran solving and how is that benefiting you?** Moving data out of SaaS apps and other internal data sources into a warehouse in order to transform, model, and blend it together in the least anount of time possible - and at a very low cost ### 22. Very straight-forward and intuitive to use **Rating:** 4.5/5.0 stars **Reviewed by:** Anastasia K. | Mid-Market (51-1000 emp.) **Reviewed Date:** February 20, 2023 **What do you like best about Fivetran?** - Setting up a new connector is very simple, never seen it in such an easy way - During the trial and when trialing a new connector I love the usage estimator - Documentation is very good and very helpful **What do you dislike about Fivetran?** - Quite some time for some connectors to understand how the data is structured (e.g. Hubspot does not match completely with the UI of the tool unless you apply some filtering) - Setting up custom connectors not as intuitive **What problems is Fivetran solving and how is that benefiting you?** Allows for no code data extraction and modelling (pre-built dbt models that can be used) which is very intuitive and straight-forward even for a business user without engineering knowledge. ### 23. Very easy to use and the team is super nice! **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Consumer Goods | Mid-Market (51-1000 emp.) **Reviewed Date:** July 19, 2023 **What do you like best about Fivetran?** The UI is extremely easy to understand and the team behind it is very quick to help and just nice overall. **What do you dislike about Fivetran?** It is a new tool and therefore sometimes there may be bugs, but the team is super quick to address and solve them. **What problems is Fivetran solving and how is that benefiting you?** Census makes it really easy to take information from our own data warehouse and use it to create/modify attributes and generate user audiences for our marketing team. ### 24. Census is an easy-to-use reverse ETL tool **Rating:** 5.0/5.0 stars **Reviewed by:** Alexandra W. | Mid-Market (51-1000 emp.) **Reviewed Date:** March 06, 2023 **What do you like best about Fivetran?** It's easy to use and is user friendly. Our data team has been able to leverage Census with our data warehouse and empower other teams to enrich their data. **What do you dislike about Fivetran?** I would like an in-product user-guided tour at the first login. **What problems is Fivetran solving and how is that benefiting you?** Allows teams outside the data and analytics team to enrich their data sources with transformed data the data team has out together. ### 25. Positive, easy-to-use, non-technical interface for ETL process **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** November 22, 2022 **What do you like best about Fivetran?** Fivetran composes of a wide range of data connectors with very clear and good documentation and instructions for each of them. I have used their connector to transfer data from Salesforce to Azure SQL database. I can easily follow their instructions to set up their connection without any knowledge in their underlying applications and APIs. They also offer decent user support. **What do you dislike about Fivetran?** There are some data connectors that are missing and their product timeline is not respected. For example, I asked for a data connector on Microsoft Dynamics 365 in Q2 this year. At that time they told me that it is on their roadmap for Q3 2022. However the connector is still not ready today. **What problems is Fivetran solving and how is that benefiting you?** They are working on the Microsoft Dynamics 365 data connector. It has been very difficult to connect this application to any database as Microsoft offers a relatively closed system in data interface. Fivetran told me that the connector will be ready in Q1 2023 ### 26. Intuitive, simple tool for DIY data pipeline **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** November 24, 2022 **What do you like best about Fivetran?** Census allowed me, a fairly non-technical marketing exec, to create the report I needed within an hour using the tools I was already familiar with and basic SQL. The UI was fairly intuitive and the help center was actually helpful solving the issues I had. Additionally, our analytics team also gets a ton of value from Census creating new data pipelines easily. **What do you dislike about Fivetran?** The pricing model is confusing -- even after review, we don't understand exactly what we are paying for. The biggest obstacle we've actually had is figuring out if new reports will add to our bill. Despite this, we still got an unforeseen price increase and had to go back and remove fields. **What problems is Fivetran solving and how is that benefiting you?** We use census to connect a number of platforms without having a dedicated data engineering team. In particular, we use the connection between Pipedrive, BigQuery and Google Sheets to develop most of our standardized reporting. ### 27. Quick and easy way to sync data from DWH to business systems **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Internet | Mid-Market (51-1000 emp.) **Reviewed Date:** October 14, 2022 **What do you like best about Fivetran?** I'm not a primary user of Census, but I do admin a connected business system that relies on product data to function. Census is one of the quickest and easiest ways I've ever used to get product data from a data warehouse to a connected system. I don't even know SQL, but I was able to modify a query that our data team outlined for me to test and deploy a sync in under half a day. I'm looking forward to learning basic SQL so that I can start self-serving the data my team needs through Census. **What do you dislike about Fivetran?** My biggest con of Census currently is not knowing SQL, which is just a gap in my skill set. Once I build knowledge of basic SQL, I don't think I'll have many complaints about the system. Of course, the usability of Census is dependent upon the cleanliness and organization of our DWH, which could use some work, but that's our problem. :) **What problems is Fivetran solving and how is that benefiting you?** I've used Census to push product usage data from our data warehouse into a connected business system. There, we use the data to measure and score customer health, drive action to customer-facing teams, and visualize product usage in the system our reps are working in. ### 28. An easy to setup and powerful tool **Rating:** 4.0/5.0 stars **Reviewed by:** Aakash S. | Data Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** November 21, 2022 **What do you like best about Fivetran?** * Very easy to setup and use and supports the applications we currently use * The new edit feature for columns in existing syncs is helpful and faster than the previous case to delete and add the column again * Makes data more accessible to stakeholders who can view the information directly on the CRM without the need to query any database * Love the 'Model' features with which simple SQL queries can be used to create a custom model to sync the data **What do you dislike about Fivetran?** * One thing that can be improved is providing the test row feature when making changes to an existing sync. Right now, this is only offered when creating new sync * If a sync has too many fields, it is challenging to browse through to find the one you are looking for; a search feature would be beneficial here * Setting up an initial sync takes up some time, and it has happened before that I have been logged out when trying to save the sync only to realise that it has all gone and now I need to re-do * A feature to copy an existing sync would be helpful for situations when the same sync needs to be set up for different environments **What problems is Fivetran solving and how is that benefiting you?** * Allows non-technical stakeholders to view the data directly in the business application they use, which now has data from other sources synced to it through Census. * No need to setup any personal infrastructure to do reverse ETL * Using real-time data to feed Braze, which handles our email communications. ### 29. Census is a huge timesaver and makes onboarding new tools seamless **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** November 21, 2022 **What do you like best about Fivetran?** I love that we don't have to write a custom integration to connect our data warehouse to our applications. It's a huge time saver and allows us more freedom to experiment & add new things. **What do you dislike about Fivetran?** Not a lot of things! There are a handful of integrations that I'd like them to add, but they are typically super responsive and add them pretty quickly. I hadn't set up my error notifications correctly, so I missed a handful of times when a sync broke. But the notifications are there, you just have to remember to customize. **What problems is Fivetran solving and how is that benefiting you?** It solves the problem of being difficult/manual to connect the data in our Snowflake data warehouse to other tools that we use. This enables to do so much more with our data - connecting it to marketing automation tools to send more intelligent/relevant emails to our users, and to our CRM so sales reps know which users are most active in our product, and so much more. ### 30. Fivetran is super easy to work with **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Telecommunications | Mid-Market (51-1000 emp.) **Reviewed Date:** February 24, 2022 **What do you like best about Fivetran?** How quick I can get a feed from my data sources to my data warehouse. It has great insights and notifications if there are any troubles, but honestly we set it and forget it. **What do you dislike about Fivetran?** The logging for connectors is a little hard to decipher but all in all it has the information needed to know whats going on. If they made it a little more user friendly to understand it would be helpful. The other thing that I wished was they were quicker at getting to connector requests. I have a couple I have been waiting for that I would love to see added. **What problems is Fivetran solving and how is that benefiting you?** We are solving getting our data source data to our data warehouse in near realtime with minimal effort. This allows us to focus time on true engineered solutions without getting bogged down in how I get data from point a to point b ### 31. Great bootstrapping option for the Modern Data Warehouse, but still some way to go **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Retail | Mid-Market (51-1000 emp.) **Reviewed Date:** November 17, 2022 **What do you like best about Fivetran?** As the title suggests it's a great option for bootstrapping a brand-new data department where Data Engineers are expensive or difficult to hire. It works well with other lean-team modern data warehouse-type technologies such as Snowflake and DBT. I got 850 Shopify tables and a few other AD sources setup really quickly **What do you dislike about Fivetran?** Whilst Fivetran runs interchangeably across data warehouses, 1) There lack support for low-latency refresh which means if you need data in your apps or dashboards within 5-10 minutes you'll need to build your own custom pipeline 2) APIs are interpreted and landed nicely for you, but this also means there will be a huge switching cost once you build your pipeline on top of the Fivetran loaders. 3) More complicated or large connectors just don't live up to the low-fuss no-code philosophy. There isn't enough architectural knowledge on the Fivetran team to help deploy these connectors successfully. 4) Their logging could be better, troubleshooting really complicated issues like wrong writes has been a non-starter since no write logs take place we simply can't tell how a wrong write ended up there 5) Primary Tables work great (tables with updated timestamps), but not everything syncs and we often have missing records on secondary tables - these are REALLY hard to verify (you only find out when the business points it out) Some Examples of 3: 1) E.g. We've tried to set up a NetSuite connector for over 6 months, the lack of an ERD or data-dictionary map just makes it really tough to get it going 2) Google/Facebook Ads ==> Some connectors don't really drop data as expected - for web marketing you end up receiving jinja variables rather than the actual attribute {{ UTM }}, other tools such as Supermetrics tend to do better in imputing these for the end user. **What problems is Fivetran solving and how is that benefiting you?** Bootstrapping - As the person leading up a newly formed team, there was literally no way to build a Data Warehouse within 6 months without one of these low-code points and click connectors. I had a look at Stitch vs. Fivetran and decided to go with Fivetran even though Stitch had more connectors because Fivetran had developed DBT packages. Even though I no longer use them (the packages), they were a huge timesaver when I first started out. ### 32. Census is too easy to use **Rating:** 5.0/5.0 stars **Reviewed by:** Christian S. | Senior Software Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 17, 2023 **What do you like best about Fivetran?** Census helps us deliver the correct data to the right people without the need to use programmatic approaches; we speed out how we handle the decisions with Census. **What do you dislike about Fivetran?** Probably we need to speed up the learning curve but it's ok. **What problems is Fivetran solving and how is that benefiting you?** Census allows us to consolidate and distribute a large amount of data to the proper people and help to make better decisions about our business with flexibility. ### 33. Reverse ETL with excellent support and good integrations **Rating:** 4.5/5.0 stars **Reviewed by:** Noah B. | President, Small-Business (50 or fewer emp.) **Reviewed Date:** September 13, 2022 **What do you like best about Fivetran?** Simple, straightforward way to configure and run data syncs from a pre-processed source of truth to other tooling. Has a clean integration with dbt core so that everything can be source controlled and directly integrated with in-house model definitions. Exposes an API for Airflow (or other orchestration tools) to trigger syncs with upstream dependencies. Census support is excellent and extremely responsive, making it easy to overcome any issues that we've encountered in our pipeline work. **What do you dislike about Fivetran?** Our biggest complaints are around the UI: - Setting up new syncs can be somewhat time-consuming. - Viewing the configuration of large syncs is slightly awkward. **What problems is Fivetran solving and how is that benefiting you?** Handles data pipelines from potentially complex definitions to other tooling. For example, helps to enrich event streams (e.g. in Amplitude or Mixpanel) with calculated user features and enable product led growth motions by syncing product use data to CRMs (e.g. Salesforce or Hubspot). ### 34. A third party product for ETL data ingestion **Rating:** 3.5/5.0 stars **Reviewed by:** Andrew J. | Product Manager, Enterprise (> 1000 emp.) **Reviewed Date:** November 03, 2022 **What do you like best about Fivetran?** Fivetran is a great alternative to the previous inhouse built platforms we use. Fivetran allows us to stand up new vendors in a day rather than weeks, allowing us to test many platforms and continue growing our options. **What do you dislike about Fivetran?** I dislike the support system of Fivetran, which is not as developed as other platforms such as Hightouch. These platforms are in the same space and offer different products, but Hightouch offers much stronger customer support in my experience. **What problems is Fivetran solving and how is that benefiting you?** Fivetran is solving the issue of data ingestion via ETL for us. This allows us to bring marketing data in from vendors like Google and Facebook and then use the TOF data in our analysis in order to drive higher performance. ### 35. Easy to use and scalable **Rating:** 4.0/5.0 stars **Reviewed by:** Bukhbayar P. | Sr Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** August 12, 2022 **What do you like best about Fivetran?** Easy to use and simple to integrate ETL to data warehouses for those who have no technical knowledge or engineers, for example in Redshift and S3. It is scalable and easy to integrate with Salesforce **What do you dislike about Fivetran?** I have noticed that the census requires to be the owner of the schema in Redshift which means has full permission on that. However, it sometimes clashes with certain policies in place in the company **What problems is Fivetran solving and how is that benefiting you?** Integrating 3rd party source data into the data lake and redshift with less coding which is good for someone who knows the source data but less or zero experience in coding ### 36. Census an easy to use data synchronisation tool for anyone **Rating:** 5.0/5.0 stars **Reviewed by:** Joslyn B. | Accounting Manager, Small-Business (50 or fewer emp.) **Reviewed Date:** December 20, 2022 **What do you like best about Fivetran?** I like it because it's straightforward to use and offers powerful features to transport the data; I like the payload generation and analytics metrics exposure, plus it's very responsive, and the documentation is excellent to guide me through the processes. **What do you dislike about Fivetran?** Only minor details, interface errors, and synchronisation failures, but they do not affect the entire operation at all. **What problems is Fivetran solving and how is that benefiting you?** It helps us a lot because we import large amounts of data into our platform, and there's less effort. We also have very intuitive business tools and their use as storage. This RETL tool is excellent. ### 37. Easy reverse ETL **Rating:** 5.0/5.0 stars **Reviewed by:** Oceane V. | Small-Business (50 or fewer emp.) **Reviewed Date:** February 21, 2023 **What do you like best about Fivetran?** Census is so easy to use. It is fast to build pipelines and very easy to monitor. Support is very responsive and helpful. They release a lot of new features every few months! **What do you dislike about Fivetran?** The UI can be slightly strange, and sometimes pipelines setup can be repetitive. **What problems is Fivetran solving and how is that benefiting you?** Saving time and cost. I can build a pipeline in 20 minutes without bothering other technical teams. ### 38. Easy to maintain data synchronization **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** December 02, 2022 **What do you like best about Fivetran?** Setting up a new sync was really easy. I like the fact that so many services are available and that most fields are matched automatically. Census is especially strong at keeping data in sync between different systems. **What do you dislike about Fivetran?** Some connections are quite slow to update. This might be caused by the rate limits of the services we use, rather than Census, but it sometimes leads to runtimes of more than a day. **What problems is Fivetran solving and how is that benefiting you?** Maintaining reliable customer data across multiple systems. This enable our customer-facing departments to more quickly and reliably set up customer-oriented communication flows. ### 39. Fivetran: Simple and swift **Rating:** 4.0/5.0 stars **Reviewed by:** Dinesh B. | Senior Business Intelligence Developer, Enterprise (> 1000 emp.) **Reviewed Date:** April 16, 2021 **What do you like best about Fivetran?** Fivetran configuration to ingest data from a different data source is very simple. We have connectors available for multiple data sources. Easy to setup and simple to use. Manual File loads can be done. **What do you dislike about Fivetran?** We don't have connectors to different API applications. We will not be able to configure the table names to start with "underscore". Adding more connectored to new application will improve the reach of fivetran. **What problems is Fivetran solving and how is that benefiting you?** We are ingesting data from different applications into our data lake using FIVETRAN. It helps to reduce the time of implementation. Increased overall team productivity. Connectors are available to export data from most of the applications that we use in our IT, finance, marketing and sales. ### 40. A great, easy tool. **Rating:** 4.0/5.0 stars **Reviewed by:** Rheanna M. | People experience coordinator, Mid-Market (51-1000 emp.) **Reviewed Date:** February 14, 2023 **What do you like best about Fivetran?** Census is really easy and simple to use. It's really quick to send data to tools such as Zendesk, Hubspot, Salesforce etc. It's also been really easy to implement at our company. We've been mainly using it with Hubspot and so far, so good! **What do you dislike about Fivetran?** Can sometimes require going back and forth between HubSpot's documentation and Census' documentation to troubleshoot something. **What problems is Fivetran solving and how is that benefiting you?** Pushing data into HubSpot. ### 41. A market leading data ingestion tool that has saved my team vast amounts of time! **Rating:** 4.5/5.0 stars **Reviewed by:** Tim G. | Head of Data and Insights, Mid-Market (51-1000 emp.) **Reviewed Date:** August 23, 2022 **What do you like best about Fivetran?** Fivetran supports a breadth of connectors, with clear SLAs to provide reliable uptime. The DBT integration and scheduling are a big plus for our data engineering team. Fivetran has a clear interface that allows users to log in and understand what is going on with ease. The alerting features are also useful to keep the team up to date on any issues. **What do you dislike about Fivetran?** Currently, you cannot dual schedule on a connector ingest e.g. run every 15 minutes between 08:00-17:00 then run hourly between 17:00 and 08:00. People rarely need 15-minute refresh schedules overnight! It would also be useful to decouple the ingest and transform scheduling so that they don't auto run together in sequence. The costs of high-volume connectors are not the cheapest on the market. **What problems is Fivetran solving and how is that benefiting you?** Fivetran is allowing our data engineering team to ingest and transform data (via DBT) in our environment at speed and with reliability, the tools are designed to reduce significant overheads of maintaining and monitoring data ingestion connections and feeds. The ability to pair with DBT allows for us to run our ingest and transform processes with more ease vs. some of the competitors that we assessed. ### 42. Easy to use and useful data synchronization tool for businesses **Rating:** 5.0/5.0 stars **Reviewed by:** Donna B. | Analytics Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** December 20, 2022 **What do you like best about Fivetran?** I liked the intuitive and straightforward user interface for the data pipeline and that it is easy to use and essential for our company. Also, it has a good support team ready to support us and solve our implementation problems. It is an efficient solution. **What do you dislike about Fivetran?** We had some implementation and integration issues with the data. But that is in the past, thanks to the support team. **What problems is Fivetran solving and how is that benefiting you?** It solves our problems of sending data and synchronising it in our store simply. This solution changed our CRM environment, and everything works as expected. ### 43. Capable Software for your Data Needs **Rating:** 5.0/5.0 stars **Reviewed by:** Sagar N. | Analyst, Financial Services, Enterprise (> 1000 emp.) **Reviewed Date:** March 04, 2023 **What do you like best about Fivetran?** I like the capabilities of census to automate data collection helped a lot in saving the time and managing operations in the effective way along with security to protect sensitive data preventing unauthorised access. **What do you dislike about Fivetran?** I found many technical glitches while operating and other thing was, not getting used to it easily takes some time to get used to it also require some training . **What problems is Fivetran solving and how is that benefiting you?** Census has helped to analyse, retrieve and store data efficiently helping to save time, it has also brought accuracy and efficiency in our day to day operations. ### 44. Seamless and effortless **Rating:** 5.0/5.0 stars **Reviewed by:** Steve M. | Small-Business (50 or fewer emp.) **Reviewed Date:** March 07, 2023 **What do you like best about Fivetran?** Census saved us weeks of engineering effort and enabled our data engineer to build complicated cross-tool migrations effortlessly. I can't think of a tool that is more aptly focused on "don't waste time reinventing the wheel." Thousands of data engineers before you, have written an Airflow pipeline to shove data into HubSpot from your data warehouse. It's a solved problem. Don't waste your investor capital solving that problem again. Use Census. **What do you dislike about Fivetran?** Nothing at all. Census was perfect end to end. I only wish it had more connectors! **What problems is Fivetran solving and how is that benefiting you?** Reverse ETL ### 45. Fivetran is a great resource for ETL and has helped me organise my data! **Rating:** 5.0/5.0 stars **Reviewed by:** James H. | Data Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** November 22, 2022 **What do you like best about Fivetran?** I like that while Fivetran offers plenty of pre-built connectors, I can always use their webhooks to make my own. The service they offer directly to me through my account manager is incredibly supportive. **What do you dislike about Fivetran?** There could be more work on the transformations that Fivetran offers through DBT, as they're great but a little challenging to get started with! Other than that, there's little to find to dislike. **What problems is Fivetran solving and how is that benefiting you?** Fivetran is helping me solve my ETL problems. Getting data into the company in an automated and smooth way while retaining control over how that data is processed and transformed is really easy through Fivetran. ### 46. Connect everything **Rating:** 3.5/5.0 stars **Reviewed by:** Sigma M. | Mid-Market (51-1000 emp.) **Reviewed Date:** February 23, 2023 **What do you like best about Fivetran?** I appreciate that you can use SQL or native connectors to seamlessly connect all the information we need to any system. **What do you dislike about Fivetran?** The UI is sometimes buggy and you have to refresh/exit the page sometimes to get all the available fields to show for mapping. **What problems is Fivetran solving and how is that benefiting you?** Capture behavior data from our data warehouse and send it to other systems. ### 47. Great tool for pushing data into SFDC. **Rating:** 4.0/5.0 stars **Reviewed by:** Scott M. | Revenue Operations Lead, Mid-Market (51-1000 emp.) **Reviewed Date:** May 25, 2023 **What do you like best about Fivetran?** The UI is very intuitive and Census Support is very helpful and responsive. **What do you dislike about Fivetran?** It isn't a true ETL solution and I can't get too fancy with the update logic or push data from SFDC back to our DB. **What problems is Fivetran solving and how is that benefiting you?** It allows us to push data from our DB into SFDC ### 48. Helpful tool for reverse ETL **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** March 06, 2023 **What do you like best about Fivetran?** The UI is clear and user-friendly; integrations for source and destination are straightforward; and syncs are very flexible! **What do you dislike about Fivetran?** I wish there is an easier way to track the destination-fields being used actively, to monitor and optimize capacity. **What problems is Fivetran solving and how is that benefiting you?** Census helps us send back relevant datasets to other applications that need them! ### 49. Best Tool We've Onboarded in Years **Rating:** 5.0/5.0 stars **Reviewed by:** Andrew T. | Mid-Market (51-1000 emp.) **Reviewed Date:** February 21, 2023 **What do you like best about Fivetran?** * Easy to Use * Lots of connectors available * Easy integration with DBT * Great support * Logarithmic pricing * How-To-Guides are on POINT **What do you dislike about Fivetran?** * How we use credits can be confusing * Missing connectors to some of our largest data providers (Not really their fault) **What problems is Fivetran solving and how is that benefiting you?** * Moving data from point A to point B ### 50. Easy to use and manage **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** November 23, 2022 **What do you like best about Fivetran?** As someone who considers themselves SQL literate, I found the tool very easy to use. I manage out GTM tech stack and Census has been critical in us leveraging product data to optimize our GTM motion. The team itself is also amazing. They're always willing to help, brainstorm ideas, and share best practices. **What do you dislike about Fivetran?** Nothing really to mention at the moment. The product itself is always growing and anytime I've submitted feedback it's been reviewed and implemented quickly. **What problems is Fivetran solving and how is that benefiting you?** We are a PLG company and on the revenue side, we are most successful when we can leverage product data. Census helps us with two critical use cases: 1) moving critical product funnel data to other GTM systems to enable Sales/Marketing tactics and reporting and 2) moving usage data to our consumption billing tools, helping to automate our billing process. ## 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=6§ion=pricing&secure%5Bexpires_at%5D=2026-07-31+02%3A22%3A03+-0500&secure%5Bsession_id%5D=562615ac-0390-4107-be04-308e0db0a98a&secure%5Btoken%5D=7a95a1308af87f8f2208f902712dff72483c3c023650c0896de50e95247e20e3&format=llm_user) ## Fivetran Integrations - [ADP Workforce Now](https://www.g2.com/products/adp-workforce-now/reviews) - [Algolia](https://www.g2.com/products/algolia/reviews) - [Amazon Advertising](https://www.g2.com/products/advertising-spire-amazon-advertising/reviews) - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - [Apache Kafka](https://www.g2.com/products/apache-kafka/reviews) - [Azure Data Lake Store](https://www.g2.com/products/azure-data-lake-store/reviews) - [Bloomreach](https://www.g2.com/products/bloomreach-bloomreach/reviews) - [Braze](https://www.g2.com/products/braze/reviews) - [Chargebee](https://www.g2.com/products/chargebee/reviews) - [ClickUp](https://www.g2.com/products/clickup/reviews) - [Databricks](https://www.g2.com/products/databricks/reviews) - [dbt](https://www.g2.com/products/dbt/reviews) - [Dynamics 365 Sales](https://www.g2.com/products/dynamics-365-sales/reviews) - [Elasticsearch](https://www.g2.com/products/elastic-elasticsearch/reviews) - [Epic](https://www.g2.com/products/epic/reviews) - [Facebook](https://www.g2.com/products/facebook/reviews) - [Forma.ai](https://www.g2.com/products/forma-ai/reviews) - [Freshdesk](https://www.g2.com/products/freshdesk/reviews) - [GitLab](https://www.g2.com/products/gitlab/reviews) - [Google Ads](https://www.g2.com/products/google-ads/reviews) - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) - [Google Workspace](https://www.g2.com/products/google-workspace/reviews) - [HubSpot Sales Hub](https://www.g2.com/products/hubspot-sales-hub/reviews) - [Klaviyo](https://www.g2.com/products/klaviyo/reviews) - [LaunchDarkly](https://www.g2.com/products/launchdarkly/reviews) - [LinkedIn Ads Tracker](https://www.g2.com/products/linkedin-ads-tracker/reviews) - [Marketo-Based Systems for Growth-Driven Marketing & Sales Teams](https://www.g2.com/products/marketo-based-systems-for-growth-driven-marketing-sales-teams/reviews) - [Microsoft Fabric](https://www.g2.com/products/microsoft-fabric/reviews) - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) - [MotherDuck](https://www.g2.com/products/motherduck/reviews) - [NetSuite](https://www.g2.com/products/oracle-netsuite/reviews) - [Notion](https://www.g2.com/products/notion/reviews) - [Okta](https://www.g2.com/products/okta/reviews) - [Pendo](https://www.g2.com/products/pendo-io-pendo/reviews) - [PostgreSQL](https://www.g2.com/products/postgresql/reviews) - [Salesforce B2B Commerce](https://www.g2.com/products/salesforce-b2b-commerce/reviews) - [Salesforce B2C Commerce](https://www.g2.com/products/salesforce-b2c-commerce/reviews) - [SAP SuccessFactors HCM](https://www.g2.com/products/sap-sap-successfactors-hcm/reviews) - [Shopify](https://www.g2.com/products/shopify/reviews) - [Snowflake](https://www.g2.com/products/snowflake/reviews) - [Zendesk for Customer Service](https://www.g2.com/products/zendesk-for-customer-service/reviews) - [Zoho CRM](https://www.g2.com/products/zoho-crm/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 (322 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)