Fivetran Reviews & Insights

Score8.4 out of 10

52 Reviews and Ratings

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.

Fivetran Reviews

5 Reviews

Engineering

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 (Computer Software, 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 (Legal Services company, 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 (Information Technology & Services company, 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 (Computer Software company, 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. (Information Technology and Services, 201-500 employees)

Vetted Review

2 years of experience

View profile

Loading Reviews List....