TrustRadius: an HG Insights company

Fivetran

Score8.4 out of 10

55 Reviews and Ratings

Get a Demo

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.

Categories & Use Cases

Key Features

Learn about the best (and worst!) features Fivetran has to offer, as determined by TrustRadius' reviewers.
Based on 55 ratings of Fivetran's features
View all features

Top Performing Features

  • Connect to traditional data sources

    Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications

    Category average: 8.9

  • Connecto to Big Data and NoSQL

    Ability to connect to non-traditional data sources like Hadoop and other big data technologies, and NoSQL databases

    Category average: 7.6

  • Testing and debugging

    Tool to debug and tune for optimal performance

    Category average: 7.2

Areas for Improvement

  • Complex transformations

    Complex data transformations are data normalization, advanced data parsing, etc.

    Category average: 7.4

  • Metadata management

    Automated discovery of metadata with ability to synchronize and share metadata with other tools like Master Data Management

    Category average: 7.5

  • Data model creation

    Ability to create and maintain data models using a graphical tool to define relationships between data

    Category average: 8.4

Reviews

What users are saying about Fivetran.
View all reviews

Automating the data extraction and loading part with ease

Incentivized
Verified User
Professional (501-1000 employees employees)

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

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

Alternatives Considered

Matillion and Stitch from Talend

Other Software Used

Snowflake, dbt, Tableau Cloud, Tableau Desktop

The premium product in the market for a reason

Incentivized
Verified User
Director in Corporate (51-200 employees employees)

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

Return on Investment

  • Business and product data now co-located in the warehouse
  • Dashboards can be built using data from all corners of the business
  • Better visibility into customer health, product usage, business financials, and more
  • Enabled high-traffic operational dashboards that increase efficiency of our sales and ops teams

Alternatives Considered

Airbyte

Other Software Used

Snowflake, dbt, Sigma Computing

Fivetran - next generation data replication

Incentivized
Uddipan MukherjeeView profile
Big Data Specialist in Engineering at Autodesk (10,001+ employees employees)

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

Most Important Features

  • Near realtime, available and reliable data replication
  • High quality ingestion with no data loss
  • Cost monitoring features

Return on Investment

  • Historical refresh cost
  • Absence of view to detailed progress logs

Other Software Used

Matillion, dbt (data build tool), from Fishtown Analytics

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

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

Pros

  • Seamless connector for data requirements
  • Custom reports
  • Database Connection
  • Change Lod

Cons

  • User-based control

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

Stitch, from Talend and Matillion

Other Software Used

Matillion, Snowflake, Google Analytics 360 (formerly Google Analytics Premium)

Gets data from Point A to Point B

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

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.

Return on Investment

  • I don't think about ETL (Extract, Transform and Load).
  • I don't process any ETL, it's set it and forget it.

Alternatives Considered

Snowflake and Alooma

Other Software Used

Tableau Online, Amazon Redshift

Usability

Related Products

Products similar to Fivetran that may also meet your needs.
All comparisons
Alooma
CompareLearn more
Stitch, a Qlik product
CompareLearn more
Xplenty now integrate.io
CompareLearn more