--- title: Fivetran Reviews meta_title: 'Fivetran Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 800 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: 800 scale: '5' date_modified: '2026-07-17' 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:** 800 ## 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. Solid RETL tool. Great support **Rating:** 4.5/5.0 stars **Reviewed by:** Kenny W. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** November 21, 2022 **What do you like best about Fivetran?** * UI is intuitive and easy to understand. * API Debugger within the Census UI helps us to identify issues quickly. * Amazing support from Census' team. * Census listens & takes action -- Census' team turns your product feedback into features (Ask them for examples!) **What do you dislike about Fivetran?** * Lack of version control (Git sync), detailed audit log and the ability to reverse changes * Lack of granular role management - I'd love to control who has access/can do what in what tool. **What problems is Fivetran solving and how is that benefiting you?** Census is a robust RETL tool that abstracts data team away from all the integration works needed when shipping data to third-party tools (Rate limiting, field mapping, translation, change delta capture), so, as a data engineering team, we can focus on generating & building out datasets, rather than figuring out, for example, how to write a Python code to call a third-party API and figure out how to handle rate limiting/outages gracefully. ### 2. Overall easy to use platform and an engaged product/support team **Rating:** 4.5/5.0 stars **Reviewed by:** Hadi H. | Senior Data Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** September 20, 2022 **What do you like best about Fivetran?** It's very easy to set up and schedule new syncs. I'm happy with the platform itself as it's intuitive to use and troubleshoot where there are any errors. The team support we get as well is top-notch. I really appreciate the thorough responses and feel that the team there does everything possible to resolve any questions or requests we have. Census also agreed to help build out some functionality we needed for our use case and they delivered it quickly. **What do you dislike about Fivetran?** On the platform side, it can be tedious to test as once a sync is created we cannot change the destination. So if I build and test a large sync to the salesforce sandbox, the sync has to be recreated for prod. This just opens a window for error particularly when many columns are named too similarly in either the data or SFDC directly. **What problems is Fivetran solving and how is that benefiting you?** We have a lot of data that needs to be shifted from system to system. Census makes that process 10x easier than doing these syncs without a service provider, and makes it far less error prone. ### 3. Critical Tool for Data Processing **Rating:** 5.0/5.0 stars **Reviewed by:** Dominick A. | Mid-Market (51-1000 emp.) **Reviewed Date:** April 11, 2023 **What do you like best about Fivetran?** Sleek Design, Intuitive Search Functionality, Flexible Sync Scheduling, AirTable Integration **What do you dislike about Fivetran?** Quirky Behavior at Times (will sometimes be forced back to the Sync page, or Large Syncs with 20+ fields will sometimes fail to load the individual fields when choosing Google Sheets as a Destination) **What problems is Fivetran solving and how is that benefiting you?** Census has promoted synergy between our Data Warehouse where we perform custom calculations and scoring for several data-points and our CRM (SFDC) and has reduced the reliance on tools such as Tableau to access vital information. ### 4. Simple, Quick, and Efficient **Rating:** 4.5/5.0 stars **Reviewed by:** David F. | Data Science Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** November 29, 2022 **What do you like best about Fivetran?** It is very simple, quick, and efficient to set up new sources. It provides great reporting on active rows and is easy to select and de-select tables to include. It has handled schema changes quite well. I have not had to spend time doing "data engineering" for EL since we got Fivetran. **What do you dislike about Fivetran?** Customization options are limited. Like forcing us into soft-deletes rather than allowing an option for hard-deletes. Single tables can get shockingly expensive. Where 95% of our cost for a database is coming from our messages table. DBT support is not available for SQL Server. **What problems is Fivetran solving and how is that benefiting you?** Burning too much time doing data engineering without a qualified resource. Not having pipelines fail due to schema changes or dropped or added columns. Having new columns added immediately is huge and saves so much time. Not having to manually create columns and tables in SQL is a blessing. ### 5. The leading low-code data ingestion solution **Rating:** 5.0/5.0 stars **Reviewed by:** Alan E. | Lead Data Architect, Small-Business (50 or fewer emp.) **Reviewed Date:** November 18, 2022 **What do you like best about Fivetran?** Fivetran offers a truly competitive solution for data integration, in particular when you're looking to connect to a source application and ingest that data into a Data Warehouse or Data Lake and to do that with minimal development/configuration/customization. The best features are: - The number of application connectors. There are hundreds of connectors to both SaaS/Web based applications such as Salesforce, Coupa, JIRA, etc as well as database and on-premise, of particular interest to us was SAP - The ease of configuration/setup to integrate to a source connection and the time taken to ingest and synch to a destination connection - The Data Change Capture (CDC) feature for many of the connectors (not all connectors offer CDC) is very slick and will easily manage INSERTS, UPDATES, DELETES in your data and track the date/time of those changes - The ability to connect to SAP and manage CDC through the database logs. This provides a minimal intrusion feature that is not reliant on many other SAP connectors/integrations which go through the API layer (RFC) - The SAP integration can ingest many of the complicated SAP objects such as long-text data/tables involving structures like pool and cluster - The easy UI that allows you to change basic configurations such as frequency of update, tables/fields required to ingest and usage/billing - Technical Support is excellent and responsive, although you probably have to be on the Business Critical support to realize this - Integration with dbt and an emerging "Marketplace" of pre-built models and transformations **What do you dislike about Fivetran?** - The support for dbt does not currently include Azure Synapse, which is what we are using for our Data Platform - The frequency of refresh configuration is good, but it would also be good if you could have a "Date/Time" of refresh rather than a synch period such as "Every 1 hour, every 24 hours, etc" - Would be nice if Fivetran could support the ingestion of SAP structure fields/tables - Would be great if Fivetran could ingest SAP BW data **What problems is Fivetran solving and how is that benefiting you?** - We can now ingest data from some of our enterprise applications where it has been extremely difficult or near impossible previously. Many of the previous "integrations" existed of basic text/csv exports from some of our applications or emailed reports. This process was very manual, and now the data just appears in our Data Lake and, all the changes are handled beautifully. - In SAP, some tables are very difficult sometimes, impossible to ingest without major development/integration efforts, such as ingesting pool/cluster tables. The method we have previously used in going via the SAP API (RFC) has also been much slower, and managing the data changes has had to be managed programmatically - We will be able to ingest data from some applications at a higher frequency than daily/nightly, which helps with the number of use cases we often have to deal with around manufacturing processes ### 6. Fivetran Review **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer & Network Security | Small-Business (50 or fewer emp.) **Reviewed Date:** August 11, 2023 **What do you like best about Fivetran?** Very easy to setup connections and get up and running. The connectors are stable and the documentation is comprehensive and kept up to date. **What do you dislike about Fivetran?** Managing spend takes some getting used to. You can easily end up spending more than you need to. **What problems is Fivetran solving and how is that benefiting you?** Fivetran has allowed me to centalise my data into a data warehouse for reporting. ### 7. Reverse ETL Partner **Rating:** 5.0/5.0 stars **Reviewed by:** Dom G. | Mid-Market (51-1000 emp.) **Reviewed Date:** February 21, 2023 **What do you like best about Fivetran?** The best thing that i like about Census is that most of my customers who come to me for ETL are also looking for Reverse ETL in the same tool. I like that Fivetran can partner with Census to complete the Modern Data stack and give companies the analytics they need in both destination and source. **What do you dislike about Fivetran?** Not as much cost transparency as there is with other Reverse ETL platforms. I wish there was a stronger support team with census, compared so some of the other competitors on the market. As well as a Freemium version. **What problems is Fivetran solving and how is that benefiting you?** Giving Fivetran customers the added benefit of reverse ETL. There is yet to be a tool that is one stop shop and if there is its not doing it well. Census completes the modern data stack by providing reverse ETL to fivetran customers. ### 8. Lead Solutions Architect **Rating:** 4.0/5.0 stars **Reviewed by:** Vikash M. | Mid-Market (51-1000 emp.) **Reviewed Date:** May 15, 2023 **What do you like best about Fivetran?** Super easy with directly available integrations. Great to maintain and access logs. Debugging is also made simple and ETL friendly. Would like more options as part of the integrations available. **What do you dislike about Fivetran?** Less number of options that's a straightforward integration. **What problems is Fivetran solving and how is that benefiting you?** Writing back our product's data onto the customer's tools and readily available integrations. Easy to navigate across UI and debug friendly. ### 9. Tool for Anything and Everything Data **Rating:** 4.5/5.0 stars **Reviewed by:** Rakshit S. | Junior Project Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** January 25, 2023 **What do you like best about Fivetran?** Census has helped us to use data operations easily and effectively with the help of data modelling functions. We are able to effectively use data and get insights out of it from various sources easily, which won’t be an easy task without it. The feature which I like personally is the analytics and reports which are provided and provides great understanding to the data and allowing data transfer across different clouds and sources. **What do you dislike about Fivetran?** Implementation and set-up time is something which consumes a lot of time which we dislike and required a lot of times, another thing which I dislike is the compatibility with various data sources and limitations on functionality part. **What problems is Fivetran solving and how is that benefiting you?** Census helped integration of data from various data sources, allowing an easy and efficient Sync from all the sources integrated, helping us to get consistent and accurate data irrespective of large and complex data sets allowing to use it the way we need by easy transformations and reshaping. ### 10. Lots of connectors and easy to use **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Banking | Mid-Market (51-1000 emp.) **Reviewed Date:** August 10, 2023 **What do you like best about Fivetran?** Our criteria were the availability of SaaS connectors and ease of use, because we only wanted one extraction tool for everything to keep complexity low. Fivetran had a few connectors that nobody else had and the setup was simple with UI and programmatic options. **What do you dislike about Fivetran?** Nothing of note. Back in the day, the pricing was steep with heavy use, but that has gotten better since. **What problems is Fivetran solving and how is that benefiting you?** Syncing data from SaaS tools that our teams use to the data warehouse and analyse it together for richer insights not possible in those tools alone. ### 11. Great experience using Census **Rating:** 4.0/5.0 stars **Reviewed by:** Nick P. | Mid-Market (51-1000 emp.) **Reviewed Date:** February 09, 2023 **What do you like best about Fivetran?** I love how easy Census makes it for us to transfer properties and attributes to Klaviyo. This really helps our email marketing team with customer segmentation. **What do you dislike about Fivetran?** I wish it were a little easier to troubleshoot when there were run failures. We spent a lot of time trying to figure out what was the issue instead of actually fixing it. **What problems is Fivetran solving and how is that benefiting you?** Census is helping us transfer our fields and attributes to other programs. It allows us to create segments and apply them to different tools across the super helpful organization. In my case, much of our product-based customer segmentation is easily transferred over to Klaviyo. ### 12. Definately a good option to collect data in batch mode from multiple sources, good product support **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Telecommunications | Enterprise (> 1000 emp.) **Reviewed Date:** April 05, 2023 **What do you like best about Fivetran?** I used FiveTran for POC to integrate and pull data from AWS S3 and Spool Directory of the Unix server , it helped us to extract data from various sources, transform it, and load it into a destination database. It supports multiple sources, including databases, cloud applications, and APIs, and integrates with various cloud-based data warehouses such as Snowflake, Amazon Redshift, and Google BigQuery. It provides pre-built connectors for many popular data sources and automates the data pipeline, making it easier for our business to consolidate data and gain insights. **What do you dislike about Fivetran?** Lack of real time streaming or processing data. It does not support real-time ingestion of data. It has a configurable sync schedule that can run as frequently as every five minutes for some data sources. There are some time issue faced with schedular as well during our POC. **What problems is Fivetran solving and how is that benefiting you?** We had to pull data from different sources and push it to Database, we were exploring option during POC, first we had only batch mode data processing as requirement , so we consider it . Its easy to configure the source due to pre-built connectors , supporting quick integration and different data formats solved our problem. The data can be loaded into the destination database relatively quickly after it is added or updated in the source system. However, it is not a real-time ingestion solution, and there may be a delay between the time when data is changed in the source system and when it is available in the destination database. ### 13. 14x Price Increase **Rating:** 0.0/5.0 stars **Reviewed by:** Verified User in Health, Wellness and Fitness | Small-Business (50 or fewer emp.) **Reviewed Date:** September 21, 2022 **What do you like best about Fivetran?** It worked fine, but then they increased our price by 14x YoY. **What do you dislike about Fivetran?** 14x Price increase, and it says it updates our salesforce real time, but it's really once a day. **What problems is Fivetran solving and how is that benefiting you?** SFDC visibility. ### 14. Great way to sync data from your warehouse to specific tools **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** April 06, 2023 **What do you like best about Fivetran?** Census is easy to configure (with a little SQL) and does exactly what it says as a reverse ELT. Once you've set it up, it consistently runs in the background - you can set it and forget it. **What do you dislike about Fivetran?** There's a bit of a learning curve to set up your first connections, but once you get past that there's not much to dislike. **What problems is Fivetran solving and how is that benefiting you?** Census sends data from our data warehouse to a handful of specific tools. It feeds into our analytics tool and enriches Salesforce profiles, among other things. ### 15. Pricing structure makes it nearly impossible to cost and resell **Rating:** 2.5/5.0 stars **Reviewed by:** Verified User in Cosmetics | Small-Business (50 or fewer emp.) **Reviewed Date:** November 15, 2023 **What do you like best about Fivetran?** consistent schema and data syncing if running **What do you dislike about Fivetran?** pricing model and costs based on sync efficiency vs actual data useage **What problems is Fivetran solving and how is that benefiting you?** consistently updating multiple data sources into a data warehouse. great concept and simplifies an important part of the process ### 16. Easy to Use Reverse ETL Tool **Rating:** 4.5/5.0 stars **Reviewed by:** Ryan O. | Senior Product Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** February 21, 2023 **What do you like best about Fivetran?** Census makes it extremely easy to send data from our production database, included calculated fields or summarized results, to SaaS applications that we use for operational analytics. **What do you dislike about Fivetran?** One thing I've struggled with is detailed error reporting. I haven't figured out a way to only subscribe to errors from certain syncs/workflows that are relevant to my role. **What problems is Fivetran solving and how is that benefiting you?** Census allows us to move data from our data warehouse back into SaaS systems. For example, we can send usage data about our customers to our CRM or marketing email triggers into our email delivery service. ### 17. We're using Powered by Fivetran for our customer experience **Rating:** 4.5/5.0 stars **Reviewed by:** Andrew S. | Managing Director, Investment Management, Small-Business (50 or fewer emp.) **Reviewed Date:** February 24, 2023 **What do you like best about Fivetran?** We love the range of connecters and destinations, the security (we work with investment managers) and the ability to embed Powered by Fivetran into our customer experience. **What do you dislike about Fivetran?** We've certainly needed some help getting our connectors and processes set up and we had some onboarding issues but resolved now. Very help account manager and support. **What problems is Fivetran solving and how is that benefiting you?** Fivetran provides us with the ability to connect to our clients data sources and bring that data into our benchmarking product - with our clients being comfortable that Fivetran is managing the process and the security. ### 18. Census and dbt **Rating:** 3.5/5.0 stars **Reviewed by:** Madison S. | Academic Mentor, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** May 18, 2023 **What do you like best about Fivetran?** Census enables us to implement reverse ETL on our dbt models. **What do you dislike about Fivetran?** No way to work with dbt dependencies- syncs will sometimes start before a model has finished running in dbt cloud **What problems is Fivetran solving and how is that benefiting you?** Automating syncs between dbt models and Hubspot and Intercom- less manual work on our end ### 19. Nice ! **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** September 16, 2022 **What do you like best about Fivetran?** In realtime sync others products (intercom, klavyo etc) to our data warehouse easily. But not just sync data you use sql to choose and transform data as you please. **What do you dislike about Fivetran?** I'd say the cost scale is kind of steep. Hopefully you provide a startup plan. I would have never sign up to census withtout it, so thanks for now ! Top help with the cost for small team you could base your price and some king of compute time for the request or something and not on the destination fields. **What problems is Fivetran solving and how is that benefiting you?** It helps us better target our customer with marketing (email, push notifications etc) based on our application data. We can send the right amount of meessages to the appropriate clients. ### 20. Easy For Anyone to use **Rating:** 5.0/5.0 stars **Reviewed by:** Zachary K. | Small-Business (50 or fewer emp.) **Reviewed Date:** February 21, 2023 **What do you like best about Fivetran?** I love how easy it is to setup new connectors and start bringing new data into my warehouse. I can connect new datasets and work with that data in my end state in minutes. **What do you dislike about Fivetran?** As with any tool it takes a little while to get acquainted, but I found it relatively easy to figure out how everything works. **What problems is Fivetran solving and how is that benefiting you?** Fivetran helps me move data into my data warehouse that otherwise sit in a silo. Being able to put disparate datasets side by side realizes enormous value for our company. ### 21. The best cloud based data integration tool ! **Rating:** 5.0/5.0 stars **Reviewed by:** Gayathri E. | Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** February 03, 2023 **What do you like best about Fivetran?** Hightly recommended cloud-based data integration tool Easy to use, don't need to be an expert to work with this product. Pipeline creation is made easy with various other applications. The connectors are availble for various applications. **What do you dislike about Fivetran?** Enabling the feature to write programming code. eg , python will help to connect application that does not have ready-made connectors available within the fivetran product. **What problems is Fivetran solving and how is that benefiting you?** There are cases where the business team wanted to extract data from their application. Even though there is an expect in building pipelines, they find using Fivetran a straightforward tool for the data extraction process! ### 22. Quick and Easy Configuration for a Powerful Data Platform **Rating:** 5.0/5.0 stars **Reviewed by:** Deric H. | Director of Business Technology, Mid-Market (51-1000 emp.) **Reviewed Date:** September 30, 2022 **What do you like best about Fivetran?** Census has provided a great customer experience, with plenty of guidance, but only if necessary. We found the configuration quick and easy, and were up and running with our first data load within 15 minutes. Our business has loved the insight the new data streams have provided within our CRM. Census provides the ultimate building blocks to capture that elusive Customer 360. **What do you dislike about Fivetran?** Honestly, we have not encountered any issues or dislikes with the platform. For our business cases, it has checked every box so far. No negative feedback to provide. **What problems is Fivetran solving and how is that benefiting you?** We have data in several disparate systems, but most importantly, from our product. This data is all currently centralized and processed within our data warehouse. To pull this important product information back into our CRM, Census provides the Reverse ETL technology to move this data into our CRM. Census allows us to have a full, 360-degree view of our Customer data, which has ultimately improved our Customer Service and Sales experience. ### 23. Seamless **Rating:** 4.0/5.0 stars **Reviewed by:** Steven M. | Data Scientist, Enterprise (> 1000 emp.) **Reviewed Date:** September 18, 2022 **What do you like best about Fivetran?** Great simple solution making it easy to self-service. **What do you dislike about Fivetran?** Haven't had much to dislike so far, good enough for our use cases. **What problems is Fivetran solving and how is that benefiting you?** Easy and secure way to self-serve data sync without the need to involve an engineering team with various tools and platforms. ### 24. Great Product, but Beware the Cost **Rating:** 4.5/5.0 stars **Reviewed by:** John H. | Lead Analytics Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** March 09, 2023 **What do you like best about Fivetran?** Fivetran is almost unbelievably easy to configure and use. The free initial sync is an incredible feature, and MAR is pretty transparent and easy to work with. Fivetran support is also terrific. **What do you dislike about Fivetran?** Cost can be prohibitive, and new users really need to pay attention to what they're planning to ingest. Expense can get out of hand quickly, which means you may end up supporting multiple pipeline tools anyway. **What problems is Fivetran solving and how is that benefiting you?** Extremely easy to use--basically replaces half an FTE for us. ### 25. Fivetran review **Rating:** 4.5/5.0 stars **Reviewed by:** Mateo J. | Human Resources Recruiter, Enterprise (> 1000 emp.) **Reviewed Date:** April 09, 2023 **What do you like best about Fivetran?** Its use is easy to understand with a modern structure that has provided solutions for data movement for better analysis, its attention is as desired in times and responses. **What do you dislike about Fivetran?** It can be a bit expensive due to its high price plans that not everyone can afford this amount of money. **What problems is Fivetran solving and how is that benefiting you?** Out-of-the-box data integration and data collection makes data analysis more detailed ### 26. 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! ### 27. 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. ### 28. 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. ### 29. 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. ### 30. 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 ### 31. 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 ### 32. 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. ### 33. 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. ### 34. 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. ### 35. 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. ### 36. 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. ### 37. 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. ### 38. 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. ### 39. 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. ### 40. 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. ### 41. 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. ### 42. 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. ### 43. 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. ### 44. 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. ### 45. 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 ### 46. 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 ### 47. 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. ### 48. 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. ### 49. 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. ### 50. 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 ## 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=5§ion=pricing&secure%5Bexpires_at%5D=2026-07-18+01%3A09%3A49+-0500&secure%5Bsession_id%5D=5fe94934-338f-43de-a915-3a53412cfe3a&secure%5Btoken%5D=c218b5ec6a11ece4e633644d6eca4de909de041d58d4d3b3614eb953d29793f6&format=llm_user) ## Fivetran Integrations - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - [Databricks](https://www.g2.com/products/databricks/reviews) - [Google Ads](https://www.g2.com/products/google-ads/reviews) - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) - [PostgreSQL](https://www.g2.com/products/postgresql/reviews) - [Shopify](https://www.g2.com/products/shopify/reviews) - [Snowflake](https://www.g2.com/products/snowflake/reviews) ## Fivetran Features **Functionality** - Diverse Extraction Points - Data Structuring - Consolidation - Data Cleaning - Cloud Extraction - Visualization **Management** - Reporting - Auditing **Management** - Real-Time Analytics - Solution Integration - Infrastructure Compatibility - Monitoring **Management** - Disaster Recovery - Remote Backup - Storage Formats - Scheduled Backups - On-Demand Restoration **Functionality** - Extraction - Transformation - Loading - Automation - Scalability **Solution Provision** - System Failover - Pay by Usage - Service Provision **Diverse Extraction Points** - Diverse Extraction Points **Reporting** - Activity Monitoring - Documentation - Alerts/Notifications **Security** - Data Encryption - Security and Compliance - Deduplication ## Top Fivetran Alternatives - [Skyvia](https://www.g2.com/products/skyvia/reviews) - 4.8/5.0 (331 reviews) - [Hevo Data](https://www.g2.com/products/hevo-data/reviews) - 4.4/5.0 (287 reviews) - [Boomi Data Integration](https://www.g2.com/products/boomi-data-integration/reviews) - 4.7/5.0 (120 reviews)