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.1

Data Modeling

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

6.1
Avg 7.9

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 5)

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.
Fivetran Feature Ratings
Data Source Connection (2)
85%
8.5
Connect to traditional data sources
90%
9.0
Connecto to Big Data and NoSQL
80%
8.0
Data Transformations
N/A
N/A
Data Modeling (4)
72.5%
7.3
Data model creation
70%
7.0
Metadata management
90%
9.0
Business rules and workflow
70%
7.0
Collaboration
60%
6.0
Data Governance (1)
70%
7.0
Integration with MDM tools
70%
7.0
Return on Investment
  • Development cost have reduced for each connector
  • The pay-per-use model is still not out their which requires lot of overhead cost
Alternatives Considered
Fivetran came well with the connectors' availability and updates with the source changes.
We had an idea on data requirements in our case which helped us to work out on cost implication and take a decision for Fivetran as a data provider for our organization.
These were 2 places where Fivetran out-performed, other vendors.
Other Software Used

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.
Most Important Features
  • Near realtime, available and reliable data replication
  • High quality ingestion with no data loss
  • Cost monitoring features
Fivetran Feature Ratings
Data Source Connection (2)
50%
5.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
N/A
N/A
Data Transformations (2)
40%
4.0
Simple transformations
80%
8.0
Complex transformations
N/A
N/A
Data Modeling (5)
52%
5.2
Data model creation
90%
9.0
Metadata management
90%
9.0
Business rules and workflow
N/A
N/A
Collaboration
N/A
N/A
Testing and debugging
80%
8.0
Data Governance (2)
50%
5.0
Integration with data quality tools
100%
10.0
Integration with MDM tools
N/A
N/A
Return on Investment
  • Historical refresh cost
  • Absence of view to detailed progress logs
Alternatives Considered
Fivetran is a powerful data replication tool that supported use cases for organization-wide data platforms.
Other Software Used
Matillion, dbt (data build tool), from Fishtown Analytics

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.
Fivetran Feature Ratings
Data Source Connection (2)
100%
10.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
100%
10.0
Data Transformations (2)
80%
8.0
Simple transformations
80%
8.0
Complex transformations
80%
8.0
Data Modeling (3)
83.33333333333334%
8.3
Business rules and workflow
80%
8.0
Collaboration
80%
8.0
Testing and debugging
90%
9.0
Data Governance (2)
80%
8.0
Integration with data quality tools
80%
8.0
Integration with MDM tools
80%
8.0
Return on Investment
  • Saved a lot of manual development days (unable to quantify)
  • Accelerated the time to add a new source to the data warehouse a lot
Usability
9
Very easy and intuitive to setup and maintain as there usually are not that many options. Very well documented (e.g. how to setup each connector, how the schema looks like, any specific features of this connector etc.). Also the operation is intuitive, e.g. you have status pages, log pages, configuration pages etc. for each connector.
Alternatives Considered
Matillion requires a lot more initial setup effort and the resulting schemas are also much more "raw" data than the nicely cleaned schemas which Fivetran provides. Therefore it would also require more (manual) post-processing efforts compared to Fivetran. So the savings on time and internal resources are not as big. Stitch did not have as many supported source systems based on our specific requirements and also was more expensive for our case.
Other Software Used

Fivetran makes ELT quick and easy

Rating: 9 out of 10
Incentivized
April 12, 2021
Verified User
Engineer in Information Technology
Health, Wellness and Fitness Company, 51-200 employees
Vetted Review
Verified User
Fivetran
1 year of experience
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.
Fivetran Feature Ratings
Data Source Connection (2)
80%
8.0
Connect to traditional data sources
90%
9.0
Connecto to Big Data and NoSQL
70%
7.0
Data Transformations (2)
80%
8.0
Simple transformations
80%
8.0
Complex transformations
80%
8.0
Data Modeling (5)
30%
3.0
Data model creation
80%
8.0
Metadata management
N/A
N/A
Business rules and workflow
70%
7.0
Collaboration
N/A
N/A
Testing and debugging
N/A
N/A
Data Governance
N/A
N/A
Return on Investment
  • Fivetran has allowed us to dramatically improve our time to insight
  • It allows us to focus on business value as opposed to engineering
  • Reduced the amount of engineering resources we need to make data available
Alternatives Considered
Fivetran is more intuitive and easier to use than code-based ETL/ELT tools. The data modelling Fivetran performs makes the data more usable more quickly. Fivetran's dbt support and integration is unique.
Other Software Used

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.
Most Important Features
  • Secure connection
  • Intuitive, easy-to-use interface
  • Speed
Fivetran Feature Ratings
Data Source Connection (2)
50%
5.0
Connect to traditional data sources
100%
10.0
Connecto to Big Data and NoSQL
N/A
N/A
Data Transformations (2)
80%
8.0
Simple transformations
90%
9.0
Complex transformations
70%
7.0
Data Modeling (5)
18%
1.8
Data model creation
N/A
N/A
Metadata management
N/A
N/A
Business rules and workflow
N/A
N/A
Collaboration
90%
9.0
Testing and debugging
N/A
N/A
Data Governance (2)
45%
4.5
Integration with data quality tools
90%
9.0
Integration with MDM tools
N/A
N/A
Return on Investment
  • Time savings due to the ease of setup and maintenance
Other Software Used
Return to navigation