--- title: Fivetran Reviews meta_title: 'Fivetran Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 828 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: 828 scale: '5' date_modified: '2026-08-10' 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:** 828 ## 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. Solid ELT solution, meets our data Integration needs. **Rating:** 4.5/5.0 stars **Reviewed by:** Haji R. | Data Engineer | AWS CCP | PySpark | Data Pipelines, Information Technology and Services, Small-Business (50 or fewer emp.) **Reviewed Date:** March 18, 2023 **What do you like best about Fivetran?** The ability to transform data within the platform without requiring external tools or scripts. Fivetran has a large number of pre-built connectors, they cover a wide range of data sources, making it easy to integrate with different systems. Regardless of where our data is coming from, Fivetran has made the extraction process seamless and reliable, providing us with clean and structured data that we can use for our analytics needs. **What do you dislike about Fivetran?** We've had scenarios when the sync process failed to complete successfully, causing some delays in our data pipeline. The process of troubleshooting the sync errors can be time-consuming and requires technical expertise, which could be a challenge for some organizations without dedicated data engineering resources. **What problems is Fivetran solving and how is that benefiting you?** Fivetran streamlines the way we access and use data by providing a reliable ELT solution that reduces the need for manual intervention. Helps us focus on analyzing data and drawing insights that drive business decisions rather than spending time on manual data integration processes. ### 2. Solid Reverse ETL, Usage-based Pricing is Limiting **Rating:** 4.0/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?** It just works. We use Census to sync data from our warehouse into marketing, sales, and customer success tools. Whenever we need to add a new field to those tools, Census is our go-to. It's simple, straightforward, and just works as expected. **What do you dislike about Fivetran?** The pricing is a little limiting. We're paying for the number of destination fields so while it's easy to add new fields to Census to sync elsewhere, it's also easy to hit the cap. We find ourselves having to clean out and remove fields on a regular basis that we would otherwise keep syncing. Obviously, we could increase our plan limit to avoid this, but it's easy for costs to scale quickly once you're in the tool. **What problems is Fivetran solving and how is that benefiting you?** We use Census to sync fields between tools and from our data warehouse (fivetran/redshift) to tools like Salesforce, Hubspot, Vitally, etc. ### 3. It mostly works **Rating:** 3.5/5.0 stars **Reviewed by:** A F. | Mid-Market (51-1000 emp.) **Reviewed Date:** February 21, 2023 **What do you like best about Fivetran?** It has been easy to get less technical users such as salesforce admins who know just a bit of SQL to get going with their basic syncs **What do you dislike about Fivetran?** Our Okta/SSO configuration has been pretty problematic. It might be on our part since the IT manager who set it up left, but even the UI to sign in with Okta instead of with Google is kinda messy as it expects you to write in your email and infer that our company is using that SSO option. **What problems is Fivetran solving and how is that benefiting you?** Getting data from our warehouse into other systems like SFDC and Zendesk. Saves me and my team the implementation and maintenance cost of each of those pipelines, while allowing stakeholders to make updates on their own as well. ### 4. The go to ELT platform for mass-account based performance marketing businesses **Rating:** 5.0/5.0 stars **Reviewed by:** Rob L. | Head of Partnerships & Insights, Marketing and Advertising, Small-Business (50 or fewer emp.) **Reviewed Date:** February 21, 2023 **What do you like best about Fivetran?** The free trial allows you to test and set up connectors within platforms to implement within your BI for an entire month. Fivetrans's ease of connector and setup alongside its customizability into custom schema was the perfect solution for us. Fivetrans customer success and tech teams work alongside you to help you get the most out of the platform, ensure you have unanswered questions answered, and are great for technical advice and best practice **What do you dislike about Fivetran?** Initial sync times & connector setup times are set for life, meaning if you are specifically looking at specifically timed extracts, there is a little bit of disconnect. You can reset these however and work on improving/optimising these **What problems is Fivetran solving and how is that benefiting you?** Extracting from a specific platform (connector) in a mass, customisable way ### 5. Great tool to close the data loop **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** August 03, 2023 **What do you like best about Fivetran?** Census helps us close the loop in our data reporting by getting important product and usage data back into our CRM so that we can easily leverage it in forecasting and reporting tools. **What do you dislike about Fivetran?** Better search functionality would help, as it's hard to identify and diagnose where some updates are coming from, like which syncs are updating which fields and who is running those syncs. **What problems is Fivetran solving and how is that benefiting you?** For revenue reporting we aim to have all key revenue metrics in our CRM and Census is solving the problem of getting product and usage data back into the CRM. This gives the team easier access to it, and allows all the tools tied to the CRM to easily ingest the product data. ### 6. The Ultimate Data Transformation and Integration Platform **Rating:** 4.5/5.0 stars **Reviewed by:** Saro K. | Chief Marketing Officer(CMO), Marketing and Advertising, Small-Business (50 or fewer emp.) **Reviewed Date:** December 24, 2022 **What do you like best about Fivetran?** I recently started using Census for my business and I have to say, I am extremely impressed. There are so many advantages to using this platform, and I wanted to share my experience in more detail. First and foremost, Census is extremely easy to use. As someone who is not particularly technical, I was worried about the learning curve, but the layout is intuitive and the onboarding process was very helpful. Within just a few minutes, I was able to get started and begin transforming and leveraging my data. One of the biggest advantages for me has been the ability to integrate Census with other tooling systems. In the past, I had data siloed in my data warehouse and it was difficult to get that data into other systems, such as my CRM. With Census, it was a breeze. I was able to quickly pipe my product data into my CRM and set up reporting for my reps in just a day. It was a game-changer for my business. Another key advantage of Census is the support provided by the team. Whenever I have had a question or issue, I have been able to get quick and helpful support. The team is responsive and understanding, and they even set up a copy of my data to try and replicate any issues I was experiencing. I really appreciate the level of support I have received. In addition to the support, I have also appreciated the ease of sync scheduling with Census. It is streamlined and straightforward to set up and maintain data syncs, and the documentation available is more than enough to guide me through the process. The user interface for Census is another standout feature. It is simple yet powerful, and both technical and non-technical team members have been able to use it effectively. The API debugger within the UI has also been incredibly useful for quickly identifying and resolving any issues that arise. One of the things that has really impressed me about Census is their willingness to listen to customer feedback and take action. They have built out additional functionality for me when requested, and it has been delivered quickly and effectively. It is clear that they value their customers and are committed to making the platform as useful and effective as possible. Finally, I have to mention how fast and easy it was to set up Census and load data. Within just 15 minutes, I was up and running with my first data load. This has been a huge advantage for my business, as we have been able to move "FAST" with Census and replace several engineering-built processes with the platform. In conclusion, I highly recommend Census to anyone looking to transform and leverage their data. The platform has so many advantages, including ease of use, integration with other tooling systems, quick and helpful support, sync scheduling, an intuitive UI, an API debugger, and a commitment to customer feedback. It is also fast and easy to set up and load data, and has provided valuable insights for my business. Overall, I have had a fantastic experience with Census and would highly recommend it to others. **What do you dislike about Fivetran?** I have been using Census for several months now and overall, I am satisfied with the platform. That being said, there are a few downsides that I have experienced during my time using it. First and foremost, I have found it can be difficult to make changes to syncs once they are set up. If I make a mistake or want to adjust something, it can be challenging to do so without setting up a new sync and deleting the original. This can be frustrating and time-consuming. Another downside is the limited search and organization features within Census. It can be tough to find and organize models, particularly if there is a lot of activity on the account. It would be helpful to have folders or groups, or at least the ability to search for models by name. In terms of the user interface and user experience, I have noticed that some features can be buggy or lacking. This can make tasks more frustrating than they need to be, and I have found myself having to work around these issues at times. As a relatively new product, Census does not have as much documentation or resources available as other platforms. This can be a drawback for users who are looking for more guidance or want to troubleshoot issues on their own. Another challenge I have encountered is the dependence on SQL knowledge. As someone who is not particularly familiar with SQL, I have found it difficult to work with some of the more advanced features of Census. While I recognize that this is a gap in my own skill set rather than a fault of the platform, it is still something that I have had to work around. Setting up new syncs with Census can also be somewhat time-consuming, and I have had instances where I have been logged out while trying to save a sync, only to find that all of my work has been lost and I have to start over. It would be helpful to have a feature that allows users to copy and paste existing syncs for situations where the same sync needs to be set up for different environments. Finally, I have found it can be awkward to view the configuration of large syncs within Census. It can be tough to browse through all of the fields to find the one I am looking for, and a search feature would be very helpful in these situations. Overall, while I have been satisfied with Census as a platform, these are the downsides that I have experienced. It would be great to see the team address some of these issues in future updates to make the platform even better. **What problems is Fivetran solving and how is that benefiting you?** As a user of Census, I have been extremely impressed by the platform and the problems it has helped me solve. One of the biggest challenges my business faced was data silos. We had data scattered across different systems and sources, and it was difficult to bring it all together in a cohesive and integrated way. Census has been a game-changer in this regard, as it has enabled us to easily connect, transform, and integrate our data from a variety of sources. This has helped us gain a more comprehensive and accurate view of our data, which has been invaluable in informing our strategy and driving growth. In addition to helping us overcome the problem of data silos, Census has also made the process of data integration much simpler and more efficient. In the past, we struggled with complex data integration processes that required significant manual effort and were prone to errors. With Census, we have been able to streamline and automate these processes, which has saved us time and helped us extract more value from our data. Another area where Census has been incredibly helpful is in improving our data management processes. The platform has made it much easier for us to keep track of and use our data effectively, which has helped us make better informed decisions and drive better business outcomes. Finally, Census has helped us gain a better understanding of our data and how it can be used to drive success. The platform has given us greater visibility into our data and has helped us see patterns and trends that we might have otherwise missed. This has been invaluable in helping us make better informed decisions and drive better results. Overall, I have been extremely impressed by Census and the problems it has helped me solve. It has made it easier for me to access and use my data, streamline and automate my data management processes, and gain a better understanding of my data and how it can be used to drive business success. I would highly recommend Census to anyone looking to improve their data management and integration processes. ### 7. Excellent Tool For Data Integration **Rating:** 5.0/5.0 stars **Reviewed by:** Sheetal N. | Administrator, Enterprise (> 1000 emp.) **Reviewed Date:** December 25, 2022 **What do you like best about Fivetran?** It is pretty simple to use. The support team is highly active and will assist you if you encounter any issues using this application. The census allows me to simply manipulate data and saves me a lot of time. The most excellent element is the user-friendly user interface, which I like and frequently use because it is pretty sharp. It is one of the most valuable tools I have ever encountered in the IT sector. **What do you dislike about Fivetran?** Honestly, I haven't found anything to dislike about Census yet. This product dramatically assists me in my work and meets all my needs. Census may improve its product and make it more helpful to users by continuing to develop and introduce new features. **What problems is Fivetran solving and how is that benefiting you?** Census resolves the 'Reverse ETL' difficulty of getting simulated and filtered data outside my data warehouse and into multiple SaaS applications. This enables us to launch automation and innovative branding, administration, and sales activities more rapidly and accurately than traditional processes. ### 8. Great App for us! **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Games | Enterprise (> 1000 emp.) **Reviewed Date:** May 25, 2023 **What do you like best about Fivetran?** - Census makes it easy to integrate with other third party applications without your dev team having to spend cycles figuring out the best way to integrate - It also gives your end-users the ability to go in and create their own filters on your core datasets, instead of created customized syncs/jobs for each person - Finally, I also like that it means we can just sync relevant data to 3rd party apps, versus updating all users every day. **What do you dislike about Fivetran?** - Keeping the app up to date and fresh is great, but feels a little odd that every time I log in it looks different / things are renamed / moved around - would be nicer to package these bigger changes into one versus the constant changing (also makes it tough for people to onboard since documentation is always out of date) - With all the changes, things have been a little unstable lately, which is not ideal. **What problems is Fivetran solving and how is that benefiting you?** - Census makes it easy to integrate with other third party applications without your dev team having to spend cycles figuring out the best way to integrate - It also gives your end-users the ability to go in and create their own filters on your core datasets, instead of created customized syncs/jobs for each person - Finally, I also like that it means we can just sync relevant data to 3rd party apps, versus updating all users every day. ### 9. Great reliability and service. **Rating:** 5.0/5.0 stars **Reviewed by:** Bogdan B. | Data Lead, Small-Business (50 or fewer emp.) **Reviewed Date:** May 24, 2022 **What do you like best about Fivetran?** The easy administration and overall ease of use. **What do you dislike about Fivetran?** Lack of advanced features (for example, creating partitioned tables) **What problems is Fivetran solving and how is that benefiting you?** Creating multiple data pipelines from multiple data sources with changing schemas to the central data warehouse. ### 10. Fivetran is a useful service for optimizing your data organization and ELT processes **Rating:** 3.5/5.0 stars **Reviewed by:** Ben A. | Data Insights Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** March 07, 2023 **What do you like best about Fivetran?** Fivetran makes data engineering processes easier by replicating and automating our data warehouse complete with historical data. Using Fivetran's tables accelerates our time to publish data visualizations and help our chief-level staff perform using data-driven decisions. **What do you dislike about Fivetran?** Some services Fivetran offers - particularly with historical data and data warehouse tables - can be costly to automate and track. In some cases, there are accessible alternatives to track only a subset of this data for barely a fraction of the price. **What problems is Fivetran solving and how is that benefiting you?** When we used Fivetran, it helped our organization track events and event history across our platform in a way that is enabling us to efficiently organize and visualize data even with a limited amount of team members. With Fivetran's data replication and automated table production, data analysts can pick and choose which fields they need for stakeholder data visualizations without having to wait for the data to be prepped, cleaned, and organized by a data engineer. This massively increases our time to publish Tableau dashboards and quickly have access to data and data history that we may not have been able to utilize previously. ### 11. No-code, low fuss Extract Tool **Rating:** 3.5/5.0 stars **Reviewed by:** Mithun M. | Mid-Market (51-1000 emp.) **Reviewed Date:** March 09, 2023 **What do you like best about Fivetran?** - It is very easy to get started and ingest data. There is no infrastructure or code to manage - There is a huge catalogue of connectors available which covers the requirements of most of the enterprise customers - Fully managed service - that means you can set it and forget it without much maintainence **What do you dislike about Fivetran?** - The pricing model is not very good. Pricing based on the monthly active rows is confusing and difficult to forecast the pricing - Enterprise customers with a large amount of data might not find the pricing model very attractive. **What problems is Fivetran solving and how is that benefiting you?** - Fivetran replaces inhouse data extraction python scripts and provides enterprise grade data, managed connectors that can pull data from a variety of sources. - WIth this data engineers can focus more on delivering insights and data to business than spending hours writing customer extraction scripts and maintaining infra needed to run them ### 12. Reverse ETL is the future **Rating:** 5.0/5.0 stars **Reviewed by:** Sam R. | Enterprise (> 1000 emp.) **Reviewed Date:** February 21, 2023 **What do you like best about Fivetran?** Census in my mind, is one of the most impactful buys our company has ever made. The cost vs the engineering effort to build a similar solution is night and day. The quality of the census product is second to none, and Sean and the team have their sights on defining this category. **What do you dislike about Fivetran?** Canva started using an early version of Census with some bugs in it. However, the Census team quickly fixed any problem with the product. **What problems is Fivetran solving and how is that benefiting you?** We use Census to sync audiences across several platforms. Census provides a simple, fast and reliable method of synchronising data between out systems and external vendors. We have also started using the audience building tool that has a lot of promise. ### 13. Absolute No-Brainer **Rating:** 5.0/5.0 stars **Reviewed by:** Bobatz R. | Mid-Market (51-1000 emp.) **Reviewed Date:** February 21, 2023 **What do you like best about Fivetran?** Fivetran as a tool is incredibly intuitive and, due to its speedy implementation time, almost immediately generates value for the business. Additionally, no real coding experience is required to use the tool, making it an excellent choice for analysts without an engineering background. **What do you dislike about Fivetran?** Potentially, one could argue that Fivetran's pricing is steep - especially if you plan on syncing high-volume connectors like Google Search or Google Ads (at least those are the highest-volume connectors for us). **What problems is Fivetran solving and how is that benefiting you?** Using Fivetran allows us to centralize data across our most essential source systems. The seamless integration with dbt additionally facilitates the planning and execution of transformation jobs overarching the whole data pipeline. The only thing currently missing is some Reverse ETL feature. ### 14. Great tool for our lean startup tech stack **Rating:** 5.0/5.0 stars **Reviewed by:** Kyle C. | Small-Business (50 or fewer emp.) **Reviewed Date:** February 21, 2023 **What do you like best about Fivetran?** Census is easy to use and connects our different data sources, providing the correct information to the business units. Writing SQL quickly to give the right team data without involving our dev team has streamlined our business. **What do you dislike about Fivetran?** When you have a lot of continuous syncs going on at once, it can bog down our data warehouse, which will sometimes hinder our data team's ability to execute timely queries. **What problems is Fivetran solving and how is that benefiting you?** We were looking for a tool that allowed us to quickly connect and send data to systems for different business units to take advantage of. Census cut out the need for developers to write APIs and allows us to send data on the fly by simply adjusting a SQL query. ### 15. I work as a Data Scientist, building SQL queries for Census pipelines. **Rating:** 4.0/5.0 stars **Reviewed by:** Alex W. | Mid-Market (51-1000 emp.) **Reviewed Date:** February 21, 2023 **What do you like best about Fivetran?** The upsides of Census are as follows * Intuitive UI for scheduling jobs and creating new data sources * Satisfactory alerting for when jobs break * Relatively stable data writes to Google Sheets (which I predominantly use). **What do you dislike about Fivetran?** * Columns don't always auto-calibrate when changing the data source/query * Perception that there is not as much transparency around which G Sheets the data writes out to * Not great ability to reduce sprawl with similar or outdated queries + jobs **What problems is Fivetran solving and how is that benefiting you?** A lot of our organization relies on Google Sheets, so my team predominantly uses Census to refresh data into Google Sheets from our database so we can syndicate our data out to more users who aren't as SQL Savvy. ### 16. Incredible tool **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Research | Mid-Market (51-1000 emp.) **Reviewed Date:** May 18, 2023 **What do you like best about Fivetran?** It's so easy to use, super intuitive. The integrations are very easy to setup and there are so many integrations available. It's saved our company so much time and freed up our data team to work on more complex data problems **What do you dislike about Fivetran?** It can be difficult to gauge how many fields you need when setting up a sync, and it's quite easy to reach the maximum number of fields. It'd be really helpful to see a list of the fields that are actually in use and for which tools, in order to optimise the number of fields in use **What problems is Fivetran solving and how is that benefiting you?** We use various tools that we need to sync our user data to. Historically, everytime we needed to integrate a new dataset to a new tool, our data team would have to do all of the leg work, pulling them away from other projects. This way, anyone can add new data integrations and we can leverage our user data across all of our apps ### 17. Fine product, complex costing, terrible treatment. **Rating:** 0.0/5.0 stars **Reviewed by:** jacob N. | Senior Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** November 14, 2022 **What do you like best about Fivetran?** I used their netsuite connector to move data to databricks. Their integrations work fine and were easy to setup. You can choose how frequent you want the data to be synced and its easy to add new tables. **What do you dislike about Fivetran?** I have been using Fivetran for three months now and have been through 3 Account managers (Due to restructuring). My current manager tricked me into an annual contract by promising me discounts which were never applied. The costing is calculated based on Monthly Active Rows, which non of to account managers understood and could warn / provide feedback on expensive tables like transactionaccountingline table (non-incremental) which is necessary for Netsuite and also part of Fivetran's official dbt models. Overall its been a turbulent experience leaving me to write this review suggesting to look into other vendors. **What problems is Fivetran solving and how is that benefiting you?** ELT, Fivetran like many other companies are trying the manage the complex engineering of ELT. This idea is nice as companies can focus on what is important and not spend a lot of time doing data engineering. ### 18. Reverse ETL made easy **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Financial Services | Mid-Market (51-1000 emp.) **Reviewed Date:** May 12, 2023 **What do you like best about Fivetran?** We use Censue for our reverse ETL process. We send data from our Data Warehouse to our CRM system. Setting up Census is pretty easy and hassle-free. It comes with an intuitive UI to navigate for our users. **What do you dislike about Fivetran?** Although having a plug n play tool like Census helps operationalize processes pretty quickly, one drawback is there is no visibility of what's going on behind the scenes. That makes us nervous about handing the process over to nontechnical people. **What problems is Fivetran solving and how is that benefiting you?** Census is primarily being used for reverse ETL purposes at our company. We have stored data and logic in our Data Warehouse which is then sent to our CRM system for sales reps. ### 19. Intuitive, powerful way to manage ETL processes without relying on an engineering team. **Rating:** 5.0/5.0 stars **Reviewed by:** Matthew D. | Business Intelligence Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** February 21, 2023 **What do you like best about Fivetran?** Fivetran allows me to get the data I need from all of our most common SaaS tools in a very straightforward, easy-to-understand way. Setting up new connections is extremely simple and reliable in an engineering agnostic way which 1) allows our engineers to focus on the product and 2) puts the power in our hands as an analytics team to quickly and efficiently stand up data pipelines. **What do you dislike about Fivetran?** Fivetran in general checks all the boxes of what we need, but you need to be careful when setting up new connections to make sure to only select the data you need. In the past, I've accidently synced huge tables that I dont need the data from which caused an increase in our monthly cost. That said, the cost wasnt too much and I was easily able to turn off the sync on that table and return to normal. **What problems is Fivetran solving and how is that benefiting you?** Fivetran gives us out-of-the-box integrations into our data warehouse from our most commonly used SaaS tools, allowing us to easily pool all of our data within our warehouse. ### 20. Easy to use and very reliable ELT tool with great set of connectors offering granular data **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** February 23, 2022 **What do you like best about Fivetran?** The simple interface makes use of the tool extremely simple for the less technical analysts / non-Data Engineers. Only basic SQL code is required to perform comprehensive ELT processes. The vast number of connectors makes accessing all data from across the business incredibly simple and quick. The recent addition of dbt makes the set up and management of the transformation layer much easier and the off-the-shelf dbt models that Fivetran offer are a great starting point. **What do you dislike about Fivetran?** In order to perform ELT fully, knowledge of dbt would be required to implement the downstream dependencies. Without this, it makes changing the ELT process more manual and error-prone. **What problems is Fivetran solving and how is that benefiting you?** Collating all data from across the business into one data warehouse without the need for expensive Data Engineers. This has allowed me to maintain a small, nimble data team that provides maximum value to the business by joining up siloed data to uncover hidden insights that would otherwise have gone unnoticed if still working with disparate data sets. ### 21. Reliable connectors, responsive and helpful support **Rating:** 4.0/5.0 stars **Reviewed by:** Yuan L. | Mid-Market (51-1000 emp.) **Reviewed Date:** May 23, 2023 **What do you like best about Fivetran?** Connectors are reliable, and faults are resolved quickly by the team, who are responsive and communicative on Slack. Also love the destination field/column-based pricing, which works better for us than a row-based one. **What do you dislike about Fivetran?** Wish that we could re-run multiple syncs at once (typically after fixing problems, or changing configurations) **What problems is Fivetran solving and how is that benefiting you?** Teams need access to more information about customers and prospects within the tools they are using, e.g. CRM. ### 22. Working well for out of the box and custom connectors **Rating:** 4.5/5.0 stars **Reviewed by:** Jay H. | Mid-Market (51-1000 emp.) **Reviewed Date:** February 20, 2023 **What do you like best about Fivetran?** There is a wide variety of out of the box connectors for hundreds of sources and they all seem to work pretty well. I also like there isn't a charge on a per connector basis, it's based on rows. **What do you dislike about Fivetran?** The customer connector setup works fine, however it takes a fair of technical work to write Lambda and integrate with FiveTran, I wonder if there could be a framework that could provide which would just work. **What problems is Fivetran solving and how is that benefiting you?** FiveTran is bringing data in for 4 different sources using out of the box connectors, we also write 2 of our custom connectors, to pull data from the source into our warehouse on a daily basis. ### 23. Fast and Easy integration from various Business tool to Data Lake/Warehouse **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** August 14, 2023 **What do you like best about Fivetran?** Super easy setup-and-forget system. Row-based pricing. Lots of integrations and destinations. **What do you dislike about Fivetran?** Some bad surprises sometimes on number of rows synced. Might not be Fivetran fault, but more about the source of data. Yet the sudden spikes for e.g. Hubspot monthly is kinda a bad surprise sometimes. **What problems is Fivetran solving and how is that benefiting you?** Making all of our tools' (SFDC, Sheets, etc.) data queryable in a single place (Snowflake) ### 24. Powerful Reverse ETL **Rating:** 4.0/5.0 stars **Reviewed by:** Simone C. | Mid-Market (51-1000 emp.) **Reviewed Date:** March 03, 2023 **What do you like best about Fivetran?** As a business user, the clean UI is a big bonus. It makes it easy to see existing syncs and the associated configurations to understand whether they are setup according to business requirements. **What do you dislike about Fivetran?** Would definitely like to see additional Matching Rules for certain tools (e.g. Mirroring for Gainsight). Otherwise mainly excited for our tech team to leverage more features in Census to better leverage its capabilities. **What problems is Fivetran solving and how is that benefiting you?** Helping push redshift data into our other tools (that don't either don't have existing redshift connectors or don't offer the flexibility we need). This decreases potential tech time and overhead otherwise needed to build such connections. ### 25. Effortless Integration for Real-Time Access to Clean and Accurate Data **Rating:** 3.5/5.0 stars **Reviewed by:** Anna H. | Data Scientist, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** February 07, 2023 **What do you like best about Fivetran?** There are advantages I see everyday and interact with when it comes to Fivetran. Writing this review, I would pay attention to the details of the Fivetran in a positive tone. I like the way we interact with the connectors. This is because Fivetran provides pre-built connectors for over 100 data sources, with databases, SaaS applications, cloud storage, and more. I can't not mention the Automated Data Pipelines. It means Fivetran automatically ingests, transforms, and loads data into the data warehouse, eliminating the need for manual data integration. **What do you dislike about Fivetran?** Pricing. Its pricing model is based on the amount of data being processed, which makes it more expensive compared to others. **What problems is Fivetran solving and how is that benefiting you?** With Fivetran, we centralize data from many sources, such as databases, cloud applications, and local systems. Fivetran uses a fully managed method of data integration that does not require maintenance, which means that you do not need to spend time and resources on manual maintenance and updating of data connectors. This means that our data is automatically converted, downloaded and updated, allowing our company to access clean, accurate and complete data in real time. ### 26. Excellent tool for fast, plug-and-go ELT **Rating:** 4.5/5.0 stars **Reviewed by:** Chris L. | Data Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** November 22, 2022 **What do you like best about Fivetran?** Fivetran makes it extremely easy to set up a connector and get your data flowing to a destination right away. Out of the box, they have a huge selection of connectors to common data sources. And once connected, we've experienced minimal to no fuss with our connectors syncing the data on a consistent basis. Fivetran allows our small analytics team to focus our time in other areas instead of fussing with manual script solutions to try and access data from multiple sources. **What do you dislike about Fivetran?** We were a bit surprised with the monthly cost based on the size of our company and data needs. It ended up being significantly higher than we anticipated. However, in the end, we still went with Fivetran due to how easy they've made our entire ELT process. **What problems is Fivetran solving and how is that benefiting you?** Getting our data from multiple different sources into our data warehouse so that we can do integrated, full-story analytics on our clientele. Connecting to the data sources and piping the data over on a regular, timely basis in a reliable, scalable manner. ### 27. Game changing for operations teams **Rating:** 5.0/5.0 stars **Reviewed by:** Andrew R. | Data Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** November 22, 2022 **What do you like best about Fivetran?** Census is so easy to use. For organizations with data siloed in their data warehouse or data lake, census makes it super easy to transform and leverage that data inside your other tooling systems. I remember first being introduced to Census and within 30 minutes we had product data in our CRM. We had been talking about this project for two years prior and Salesforce quoted us an insane price for some custom tooling to achieve the same result. With Census, I piped product data into SFDC and had reporting spun up for Reps in a day. It was magic. Oh, and it gets better. If you start leveraging a transformation tool like dbt to create models, you can do a ton of sophisticated data transforms and then pump it back into your CRM or tooling. Salesforce makes it a nightmare to do lead or account scoring, so you either have to do magic math with formula fields or have a developer / flow expert who can actually create something valuable. With Census powering the data flow you can write SQL models and provide insights to your teams that you never thought were possible. **What do you dislike about Fivetran?** Improved data monitoring would be nice, but other than that it is really easy to use and they make it pretty simple to get models up and running. I am not sure if you can do this, but updating records only if the prior value is changed would be nice too, though you can control this in your data modeling. **What problems is Fivetran solving and how is that benefiting you?** Census solves the gap between the massive amount of data that exists at companies and the ability to surface that data to your employees in a digestible and clean way in the tools they directly interface with. ### 28. A great tool to avoid hard coding every new parameter request from teams **Rating:** 5.0/5.0 stars **Reviewed by:** Sanja S. | Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** November 21, 2022 **What do you like best about Fivetran?** - Key integrations available for both the data source and the destination (in our case BigQuery to Mixpanel, among others). - Good onboarding process (this involved a challenge to use the tools to select T shirt size from source data) - Intuitive and simple layout - Quick and helpful support (the few times I have reached out, I could tell they really understood my issue and had already set up a copy of data to try and replicate the issue - there was little back and forth) - Sync scheduling **What do you dislike about Fivetran?** Signing up for the app wasn't as smooth as it could have been - both myself and my colleague got stuck in loops when accepting invites, but support was able to quickly help! **What problems is Fivetran solving and how is that benefiting you?** Consolidation and access to data, as well as freeing up the dev team's time. Previously for any new metrics or parameters that the various teams needed, we would need to hard code these metrics and send them to their respective destinations (including needing to deploy!). Now the dev team can quickly set up a sync with the requested parameters, or even other members of the team can jump in and arrange what they need to sync. ### 29. Quick and easy tool with excellent support **Rating:** 5.0/5.0 stars **Reviewed by:** Tori Z. | Data Scientist, Mid-Market (51-1000 emp.) **Reviewed Date:** November 21, 2022 **What do you like best about Fivetran?** I love how easy and streamlined it is to set up and maintain syncs within Census. The amount of documentation available was enough to guide me through setup processes alone. Census makes it extremely easy to connect to my dbt project with clean integration. What pushed Census above and beyond was their eagerness and availability to work with me through issues that presented themselves through my setup process. Special thanks to Sean and Kurt for taking additional measures to ensure my issues were solved and always followed up in a timely manner with updates or fixes. Their excellent responsiveness has made it easy to overcome any problems that I encountered. **What do you dislike about Fivetran?** There were a few known issues that I ran into when creating a connection with my dbt project. These were known issues that other customers were also experiencing. However, Kurt on the implementation team took thorough action to ensure that these issues were resolved quickly. **What problems is Fivetran solving and how is that benefiting you?** Reverse ETL through Census has been extremely helpful in getting data from the data warehouse into Salesforce. The CI checks are also extremely helpful in making sure that there are no downstream breakages from dbt changes. ### 30. 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. ### 31. 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. ### 32. 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. ### 33. 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. ### 34. 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 ### 35. 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. ### 36. 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. ### 37. 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. ### 38. 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. ### 39. 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. ### 40. 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. ### 41. 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. ### 42. 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. ### 43. 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. ### 44. 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 ### 45. 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. ### 46. 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. ### 47. 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 ### 48. 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. ### 49. 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. ### 50. 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! ## 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&qs=pros-and-cons§ion=pricing&secure%5Bexpires_at%5D=2026-08-10+22%3A14%3A26+-0500&secure%5Bsession_id%5D=7be3b7ec-e4a1-464c-9fab-576f26c54ad6&secure%5Btoken%5D=6ba47a9591eb3009e9223a18c0ea0f6844261a4b56e67d1685b869bfa7cee365&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) - [dbt + Looker](https://www.g2.com/products/dbt-looker/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) - [Metabase](https://www.g2.com/products/metabase/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 - Data Extraction - Real-Time Data - Image Extraction - IP Address Extraction - Email Address Extraction - Metadata Extraction - Document Extraction - Phone Number Extraction - Auto Extraction - IP Address Extraction - Email Address Extraction - Image Extraction - Web Data Extraction **Management** - Reporting - Auditing **Management** - Real-Time Analytics - Solution Integration - Infrastructure Compatibility - Monitoring **Data Management** - Data Integration - Metadata - Self-service - Automated workflows **Data Management ** - Data Modeling - Auditing - Observability - Data mapping - Reporting **Agentic AI - DataOps Platforms** - Autonomous Task Execution - Multi-step Planning - Cross-system Integration - Adaptive Learning - Decision Making **Management** - Disaster Recovery - Remote Backup - Storage Formats - Scheduled Backups - On-Demand Restoration **Functionality** - Extraction - Transformation - Loading - Automation - Scalability - Non-Relational Transformations - Data Extraction **Solution Provision** - System Failover - Pay by Usage - Service Provision **Analytics** - Analytics capabilities - Dasboard visualizations **Functionality** - Debugging - Workflow Automations - Notifications - API Integrations - Programmed trigger of data sync - Incremental data sync - Data audit **Diverse Extraction Points** - Diverse Extraction Points **Additional Functionality** - Data Storage Management - Customizable Templates - Multiple Data Sources - Forecasting - Reminders - Multi-Language - Visual Discovery - Mobile Access - Rules-Based Workflow - API - Customizable Forms - Drag & Drop - Third-Party Integrations - Workflow Management - Data Mapping - Trend Analysis - Compliance Management - Data Connectors - Multi-Channel Distribution - Search/Filter - Data Transformation - Data Import/Export - Data Synchronization - Reporting/Analytics - Surveys & Feedback - Customizable Fields - Forms Management - Multi-Channel Data Collection - HIPAA Compliant - Metadata Management - Secure Data Storage - Generative AI - Access Controls/Permissions - Multi-Device Support - AI Copilot - Visual Analytics - Audience Targeting - Offline Response Collection - Data Capture and Transfer - Customizable Reports - Activity Dashboard - Dashboard Creation - Version Control - Query Builder - IP Rotation - AI/Machine Learning - Data Verification - Optical Character Recognition - Batch Processing - Data Aggregation and Publishing - Job Scheduling - Data Mining - Proxy Rotation - Geotargeting - Data Aggregation - JavaScript Rendering - HTML Parsing - Multiple File Format Support - Data Cleansing - Reporting & Statistics - Natural Language Processing - CAPTCHA Solving - Integration Management - Website Crawling - Scheduling - Bot Mitigation - User Management - Customization - Proactive Error Detection **Additional Functionality** - Data Mapping - Monitoring - Charting - Integration Management - Reporting/Analytics - Ad hoc Analysis - Access Controls/Permissions - API - Match & Merge - Real-Time Monitoring - Metadata Management - Pipeline Management - Job Scheduling - Dashboard Creation - Data Storage Management - Multiple Data Sources - Data Import/Export - Generative AI - Data Quality Control - Data Connectors - Customizable Reports - Single Sign On - Version Control - Visual Analytics - Accounting Integration - Real-Time Data - eCommerce Management - AI Copilot - CRM - Data Visualization - SSL Security - Search/Filter - Real-Time Analytics - Data Capture and Transfer - Collaboration Tools - Performance Management - Data Synchronization - Drag & Drop - Data Replication - Activity Dashboard - Database Support - Workflow Management - Alerts/Notifications - Predictive Analytics - Data Migration - Third-Party Integrations - Reporting & Statistics - Data Analysis Tools **Reporting** - Activity Monitoring - Documentation - Alerts/Notifications **Monitoring and Management** - Data Observability - Testing capabilities **Security** - Security Compliance - Data Encryption **Security** - Data Encryption - Security and Compliance - Deduplication **Cloud Deployment** - Hybrid cloud support - Cloud migration capabilities **Generative AI** - AI Text Generation **Generative AI** - AI Text Generation - AI Text Summarization ## Top Fivetran Alternatives - [Skyvia](https://www.g2.com/products/skyvia/reviews) - 4.8/5.0 (322 reviews) - [Workato](https://www.g2.com/products/workato/reviews) - 4.7/5.0 (748 reviews) - [Hevo Data](https://www.g2.com/products/hevo-data/reviews) - 4.4/5.0 (288 reviews)