Fivetran Reviews and Ratings

Rating: 8.4 out of 10

Score

8.4 out of 10

Community insights

TrustRadius Insights for Fivetran are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Intuitive Accessibility Permissions: Users have found the accessibility permissions within Fivetran to be intuitive, allowing them to easily secure and identify the allowed managers for data administration. This feature has been praised by multiple reviewers.

High Scalability of Data Replication Operations: The high scalability of data replication operations in Fivetran has received praise from users. It is ideal for creating backups of information in both cloud and non-cloud environments, ensuring source systems are well-protected. Several reviewers have highlighted this advantage.

Quick and Effective Customer Support: The customer support representative provided quick solutions to fix issues with the platform, as acknowledged by a user. Despite the issues being configuration errors on their part, the positive experience with Fivetran's support team was appreciated.

Reviews

9 Reviews

Automating the data extraction and loading part with ease

Rating: 8 out of 10

Incentivized

October 31, 2024

Use Cases and Deployment Scope

We want to load data from various operational systems into our central data warehouse. Fivetran supports this task with minimal setup and maintenance effort on our side. This allows us to focus on the value adding tasks instead of on moving data between systems. We use Fivetran to sync data from CRM, Marketing Automation, ERP, HR, Subscription Management and Billing, and Support systems.

Pros

Small initial setup effort
Fivetran automatically takes care to fix loading issues
Has connectors to many different systems

Cons

Very difficult to get connectors enhanced if a specific needed object is not supported by them
Depending on the edition needed and the data volumes, can get quite expensive

Likelihood to Recommend

If your source systems have a supported connector and the provided schemas from Fivetran work for you, then I consider it well suited. Also make sure based on your volume estimations if the costs work out for you. If you want to focus your data engineers on more value adding tasks and outsource the "moving data from A to B" part, then Fivetran is a great match. If you want to custom-develop all the data integrations and have a sufficiently large workforce to do so, then you might not need it.

Verified User

Professional (501-1000 employees)

Vetted Review

4 years of experience

The premium product in the market for a reason

Rating: 9 out of 10

Incentivized

May 7, 2024

Use Cases and Deployment Scope

Streamlined, fully managed ETL tool to bring data from our SaaS applications into a centralized Snowflake warehouse. It enables us to run analytics across the business.

Pros

Fully managed ETL pipelines
Minimal implementation and pipeline configuration in minutes
Responsive and helpful customer support
Broad coverage of connectors and ability to quickly build a new connector

Cons

Better UI in the product for performance
Don't make us use the logs to understand performance
Pricing can get very expensive

Likelihood to Recommend

Fivetran is perfect for companies that want to quickly establish an ETL process to get more data for analytics. Particularly if you don't have in-house technical data engineering expertise. Fivetran abstracts away the complexity of writing code for ETL pipelines and the maintenance burden of keeping those pipelines running well.

Verified User

Director in Corporate (51-200 employees)

Vetted Review

2 years of experience

Fivetran - next generation data replication

Rating: 9 out of 10

Incentivized

December 22, 2021

Use Cases and Deployment Scope

Fivetran is used as a near real-time data replication solution between several source systems and organization-wide databases. Sources include traditional RDBMS, APIs, SAP Hana, etc. Fivetran is a reliable, and available service that did not result in any performance or data issues during its tenure with the data platform. It also supports some data transformations which are helpful to some use cases.

Pros

Near real time Data replication
Basic standardization
Availability of a wide variety of ingestion plugins

Cons

View based ingestion from RDBMS
Detailed Logging
API support

Likelihood to Recommend

Fivetran is very well suited for any near real-time ingestion requirements for available plugins. Do not use it for complex data standardization as it only supports some features with that respect. Fivetran provides the required information on data volume, cost applicable, which is helpful to plan future ingestions. Sometimes historical refresh cost goes very high, but users also can be trained to save cost with appropriate measures.

Uddipan Mukherjee

Big Data Specialist in Engineering at Autodesk (10,001+ employees)

Vetted Review

2 years of experience

View profile

Effortless ETL setup in minutes

Rating: 9 out of 10

Incentivized

December 3, 2021

Use Cases and Deployment Scope

We use it for the majority of our ETL to our data warehouse

Pros

Simplified ETL from a wide range of data sources
Stable and painless data pipeline
Granular control over what parts of the data source are loaded

Cons

More detailed logging
More flexible choices for time range over which records are synced
More options for masking and excluding sensitive data

Likelihood to Recommend

When you need a super quick and easy way to load data from a third-party source to a warehouse when a delay of up to an hour is an option, Fivetran is the way to go. It is shockingly easy and yet does support a fair amount of sophistication at a reasonable cost. It lacks automation and infrastructure as code abilities and internal transformations are limited, but it shines at batch extraction and handles schema changes for you very smoothly.

Verified User

Engineer in Engineering (201-500 employees)

Vetted Review

1 year of experience

Fivetran for fast data replication

Rating: 8 out of 10

Incentivized

December 3, 2021

Use Cases and Deployment Scope

We use Fivetran at my organization to securely replicate data from our production databases to our data warehouses in Snowflake, syncing production data at regular intervals on a daily schedule. This allows us to efficiently move data without impacting our production systems and allows us to keep more historically complete records of the life of data that exists in our production databases.

Pros

Allows triggering of transformations using basic SQL transformations performed when new data is loaded or synced over
Supporting data sync without affecting production databases availability or increasing load on production databases
Providing out-of-the-box connectors for quick and easy connection to a variety of commonly used databases
Supporting a variety of data sources (not only databases but also files like JSON or CSV files with exported data

Cons

Doesn't include support for a Kinesis stream as a data source so couldn't be used for some use cases under consideration
Doesn't support the use of "BEFORE DELETE" triggers
No support for serverless Aurora

Likelihood to Recommend

Fivetran is a good choice if you want to get started quickly with replicating production transactional database tables to Snowflake with minimal impact on production. Setup is fast and Fivetran provides a user-friendly interface that can be used to resync individual tables if necessary. It's a good solution for a mature database schema where certain tables hold a very large amount of data, which when replicated into a system like Snowflake allows users to execute queries against the dataset that would otherwise be very slow and not perform well directly against the production database.

Verified User

Engineer in Engineering (201-500 employees)

Vetted Review

2 years of experience

Highly recommend Fivetran

Rating: 8 out of 10

Incentivized

December 2, 2021

Use Cases and Deployment Scope

We use Fivetran as our Extract Transform Load provider bringing data from all our various third-party services into our Data Warehouse in Microsoft Azure. Personally, I've used it extensively with Twilio's SendGrid connector in bringing and formatting all of our email and notification data into the warehouse for data analysts internally to run more extensive analysis on it.

Pros

UI is very clean.
Documentation is easy to use.
Plenty of connectors for different third party services.

Cons

Honestly, not much they're already crushing it!
If I had to say one thing, I guess I would say make it more accessible to non-data engineers.

Likelihood to Recommend

I think it's suited best for what it was built for, ETL pipelines expedited. If you are a startup that has a software product with various different data sources that you need to quickly and reliably bring all together to some kind of centralized data store, Givetrain is well suited for this use case. If that isn't part of your business needs to do this data consolidation before any analysis it probably isn't well suited for your use case.

Verified User

Team Lead in Engineering (51-200 employees)

Vetted Review

1 year of experience

Digital Seamless data provider only when you know your data requirement in advance.

Rating: 8 out of 10

Incentivized

May 4, 2021

Use Cases and Deployment Scope

Fivetran has lots of digital connectors available with them required in our organization to make business decisions. Our Data management is the main consumer of the product, which then widely gets consumed in the organization's analytical format to make strategies. We are data-driven digital marketers that rely on data to make decision. The sources are expanding and handling them individually makes them very challenging and that's where Fivetran helps us solve the problem.

Pros

Seamless connector for data requirements
Custom reports
Database Connection
Change Lod

Cons

User-based control

Likelihood to Recommend

Fivetran's business model justifies the use-case where we require data from a single source basically a lot of data but if the requirement is not on the heavier side, Fivetran comes to costly operation when compared to its peers. Otherwise, I'll recommend Fivetran for stability and update and seamless service provider.

Sudarshan Kothari

Senior Data Scientist in Engineering at iQuanti, Inc. (201-500 employees)

Vetted Review

2 years of experience

View profile

Fivetran makes ELT quick and easy

Rating: 9 out of 10

Incentivized

April 12, 2021

Use Cases and Deployment Scope

Fivetran is used by our reporting and analytics team to ingest data from multiple SaaS, Ad platform, and internal data sources. Fivetran supports our ELT approach using delivered connectors for most of our data sources.

Pros

Easily connects to source data using delivered connectors
Transforms data into standard models and schemas
Has very good documentation to help quickly setup connectors

Cons

Alerting and notification could be enhanced and be more timely in some cases
The error messages when there are connector setup issues could be more clear

Likelihood to Recommend

[Fivetran is] very well suited when you are using popular and common data sources, such as the major ad platforms, and SaaS platforms such as Salesforce.

If the majority of your data sources are custom internal applications or databases, may be less value as you aren't leveraging the delivered connectors.

Verified User

Engineer in Information Technology (51-200 employees)

Vetted Review

1 year of experience

Gets data from Point A to Point B

Rating: 7 out of 10

Incentivized

January 28, 2019

Use Cases and Deployment Scope

We use it to sync a MySQL instance to a redshift cluster so we can run analytics against a non-prod environment.

Pros

Quick replication of data with minimal lag.
Automated reporting if data is out of date.
The customer support team is relatively good.

Cons

A full schema refresh takes us two-three days and knocks us offline from monitoring up-to-date business KPIs, running updated analyses, etc. This is likely due to us having massive amounts of data (from a count(1) perspective, not size of tables perspective).
There's little to no progress estimate on the front end UI to see how long this refresh might take and you need to enable back end logging in Amazon to see where it's at in the sync process and derive rough estimates of completion time.

Likelihood to Recommend

Fivetran works well when you have a lot of data in different places and want to get it all in one spot. I don't think it's as necessary if you have one cluster that needs to be replicated against and the data could wait a day. In this instance, there are other tools.

Scott Laronge

Head of Data Science in Information Technology at Couchsurfing International (11-50 employees)

Vetted Review

2 years of experience

View profile

Loading Reviews List....

Home
,
Data Integration
,
Fivetran
,
Reviews and Ratings

Fivetran for fast data replication

Rating: 8 out of 10

Incentivized

December 3, 2021

Use Cases and Deployment Scope

Pros

Allows triggering of transformations using basic SQL transformations performed when new data is loaded or synced over
Supporting data sync without affecting production databases availability or increasing load on production databases
Providing out-of-the-box connectors for quick and easy connection to a variety of commonly used databases
Supporting a variety of data sources (not only databases but also files like JSON or CSV files with exported data

Cons

Doesn't include support for a Kinesis stream as a data source so couldn't be used for some use cases under consideration
Doesn't support the use of "BEFORE DELETE" triggers
No support for serverless Aurora

Likelihood to Recommend

Verified User

Engineer in Engineering (201-500 employees)

Vetted Review

2 years of experience