Skip to main content
TrustRadius
Fivetran

Fivetran

Overview

What is Fivetran?

Fivetran replicates applications, databases, events and files into a high-performance data warehouse, after a five minute setup. The vendor says their standardized cloud pipelines are fully managed and zero-maintenance.The vendor says Fivetran began with a realization: For modern companies using…

Read more

Learn from top reviewers

Automating the data extraction and loading part with ease

Rating: 8 out of 10
October 31, 2024
IncentivizedVetted ReviewVerified User
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 ...
Continue reading
Verified user
Professional
Fivetran4 years of experience

The premium product in the market for a reason

Rating: 9 out of 10
May 7, 2024
IncentivizedVetted ReviewVerified User
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.
Continue reading
Verified user
Director
Fivetran2 years of experience

Fivetran - next generation data replication

Rating: 9 out of 10
December 22, 2021
IncentivizedVetted ReviewVerified User
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 Han...
Continue reading
Uddipan Mukherjee
Team Lead - Engineering
Big Data Specialist
Autodesk
Fivetran2 years of experience

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

Rating: 8 out of 10
May 4, 2021
IncentivizedVetted ReviewVerified User
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, w...
Continue reading
Sudarshan Kothari
Team Lead - Engineering
Senior Data Scientist
iQuanti, Inc.
Fivetran2 years of experience

Gets data from Point A to Point B

Rating: 7 out of 10
January 28, 2019
IncentivizedVetted ReviewVerified User
We use it to sync a MySQL instance to a redshift cluster so we can run analytics against a non-prod environment.
Continue reading
Scott Laronge
Team Lead - Information Technology
Head of Data Science
Couchsurfing International
Fivetran2 years of experience
Log in with LinkedIn to see content from your network
Return to navigation

Pricing

View all pricing

Starter

$0.01

Cloud
per credit

Standard

$0.01

Cloud
per credit

Enterprise

$0.01

Cloud
per credit

Entry-level set up fee?

  • Setup fee optional
For the latest information on pricing, visithttps://www.fivetran.com/pricing

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Starting price (does not include set up fee)

  • $0.01
Return to navigation

Product Demos

Fivetran - Interactive Demo

Navattic
Return to navigation

Features

Data Source Connection

Ability to connect to multiple data sources

10
Avg 8.3

Data Transformations

Data transformations include calculations, search and replace, data normalization and data parsing

6.3
Avg 8.2

Data Modeling

A data model is a diagram or flowchart that illustrates the relationships between data

6.1
Avg 8.1

Data Governance

Data governance is the practise of implementing policies defining effective use of an organization's data assets

9
Avg 8.2
Return to navigation

Product Details

What is Fivetran?

Fivetran replicates applications, databases, events and files into a high-performance data warehouse, after a five minute setup. The vendor says their standardized cloud pipelines are fully managed and zero-maintenance.

The vendor says Fivetran began with a realization: For modern companies using cloud-based software and storage, traditional ETL tools badly underperformed, and the complicated configurations they required often led to project failures. To streamline and accelerate analytics projects, Fivetran developed zero-configuration, zero-maintenance pipelines to deliver data into modern cloud warehouses.

Shaped by the real-world needs of data analysts and business intelligence users, Fivetran technology promises to enable organizations to control their data without complex engineering and ultimately supports data-backed decisions and company culture.

Fivetran Features

  • Supported: Five-minute setup
  • Supported: Complete replication from any source
  • Supported: Fully managed 24x7
  • Supported: Normalized schemas from denormalized APIs
  • Supported: Automatic schema migrations

Fivetran Videos

Fivetran Customer Video: Optimizely
Fivetran Customer Story: Kiva

Fivetran Competitors

Fivetran Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo
Supported CountriesWorldwide
Supported LanguagesEnglish

Fivetran Downloadables

Frequently Asked Questions

Fivetran starts at $0.01.

Alooma and Stitch from Talend are common alternatives for Fivetran.

Reviewers rate Connect to traditional data sources and Connecto to Big Data and NoSQL highest, with a score of 10.

The most common users of Fivetran are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews From Top Reviewers

View all reviews
(1-5 of 9)

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.

Fivetran for fast data replication

Rating: 8 out of 10
Incentivized
December 03, 2021
Verified User
Engineer in Engineering
Information Technology & Services Company, 201-500 employees
Vetted Review
Verified User
Fivetran
2 years of experience
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.

Gets data from Point A to Point B

Rating: 7 out of 10
Incentivized
January 28, 2019
SL
Scott Laronge
Head of Data Science
Couchsurfing International (Internet, 11-50 employees)
Vetted Review
Verified User
Fivetran
2 years of experience
View profile
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.

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

Rating: 8 out of 10
Incentivized
May 04, 2021
SK
Sudarshan Kothari
Senior Data Scientist
iQuanti, Inc. (Information Technology and Services, 201-500 employees)
Vetted Review
Verified User
Fivetran
2 years of experience
View profile
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.

Automating the data extraction and loading part with ease

Rating: 8 out of 10
Incentivized
October 31, 2024
Verified User
Professional in Other
Computer Software Company, 501-1000 employees
Vetted Review
Verified User
Fivetran
4 years of experience
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.
Return to navigation