TrustRadius: an HG Insights company

Fivetran

Score8.2 out of 10

57 Reviews and Ratings

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

Videos

Fivetran Key Features

Learn about the best (and worst!) features Fivetran has to offer, as determined by TrustRadius' reviewers.
Based on 57 ratings of Fivetran's features
View all Fivetran 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.3

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

Who Buys & Uses Fivetran

Fivetran Reviews

What users are saying about Fivetran.
View all Fivetran reviews

A great way to offload engineering work so you can get back to your core business

Incentivized
Verified User
Engineer in Information Technology (1001-5000 employees)

Use Cases and Deployment Scope

We use Census to sync data to our external SAAS tools. This offloads a lot of data/analytics engineering work to Census and we can focus more on modelling business logic and maintaining our data warehouse. We love having all the integrations in one place and can be pretty confident when we use a new popular tool Census either has or can build us an integration.

Pros

  • Integrated with a lot of the popular tools out there
  • Can be set up easily
  • Great support

Cons

  • Sometimes a custom setup is very clunky, this was the case with our Intercom segment setup
  • There have been unexpected syncing failures before with vague error messaging.
  • We had issues previously with trying to rename schemas, Census still tried to use the old names.

Return on Investment

  • We are able to respond to customers account health more rapidly by syncing our data into the various customer account management tools

Usability

Automating the data extraction and loading part with ease

Incentivized
Verified User
Professional (501-1000 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

Fivetran - next generation data replication

Incentivized
Uddipan MukherjeeView profile
Big Data Specialist in Engineering at Autodesk (10,001+ 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)

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)

The premium product in the market for a reason

Incentivized
Verified User
Director in Corporate (51-200 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 Alternatives

Products similar to Fivetran that may also meet your needs.
View all Fivetran alternatives
Alooma
CompareLearn more
Stitch, a Qlik product
CompareLearn more