Fivetran

Fivetran

Zero-maintenance data pipeline

4.7/5 (9 reviews)

Fivetran Overview

Fivetran is a zero-maintenance data pipeline which enables businesses of all sizes to collect and analyze business data by connecting their applications and databases to a central data warehouse. Fivetran supports a wide range of data connectors, allowing users to collect data seamlessly from apps such as a Facebook Ad Insights, Shopify, Salesforce, Google AdWords, Google Analytics, Snowplow, and more.

Once data has been collected in the central warehouse, analysts can ask questions and explore company data effectively using a SQL editor, or any other modern business intelligence tools. With access to up-to-date, row-level data, Fivetran enables users to ask just about any question using SQL tools. Users can set up SQL queries or a Business Intelligence (BI) dashboard, to give teams quick and central access to accurate metrics.

Fivetran enables users to own their data, as well as maintain a historical archive. Fivetran supports a full historical sync, archiving changes so that users can even query deleted data. As a zero-maintenance/zero-configuration pipeline, Fivetran gets users up and running in 5 minutes, and enables analysts to query and combine data sources without writing a single line of code. Permission, company policy and compliance management tools, plus SSL encryption help users manage data safely and securely.

Pricing

Starting from
N/A
Pricing options
Free Trial
Subscription
Value for money

Devices

Business size

S
M
L

Markets

United States

Supported Languages

English

Fivetran Reviews

Overall rating
4.7/5
89% positive reviews
7
Excellent
1
Very good
1
Average
0
Poor
0
Terrible
Andrew G.

Easy to set up and even easier to manage multiple integrations across multiple systems.

Used Daily for 2+ years
Reviewed on 2017/11/01
Review Source: Capterra

This software has allowed me to manage a vast majority of my major ETL integrations without actually having to write or maintain any code. This has been greatly beneficial for my time as I'm not able to devote more focus on other, more value-added tasks for the company. I'm currently only a team of 1 and the time that Fivetran saves is immeasurable. It just is a high quality product that does exactly what it says it does and does it reliably.

Pros

Very easy set up. Troubleshooting is made simple when there are problems. The downtime has been minimal and appears to be getting better as they improve the product. Fivetran is also great value in terms of the service provided and overall cost. When I've had issues, their tech support has been quick to respond and helpful.

Cons

Occasional delays do occur and there's sometimes no real good explanation for it. Most of the time I just assume that there is something wrong with the service Fivetran is trying to pull from but there isn't much detail on it/ estimates on when a delayed connection might catch up. Other than that, there's no way to make connections to services that aren't pre-built which is understandable but that should get better over time as Fivetran adds new connectors.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend

10.0/10

Plug n Play integration with any app

Used Daily for 2+ years
Reviewed on 2017/12/14
Review Source: Capterra

Pros

Fast setup - setting up connector for any app takes minutes
Seamless data sync - Fivetran incremental data sync makes it seemless
Convenience - You can pick records or objects from your app that should be synced.
Plethora of ready made app connector available
Option to import excel data.
Great customer support

Cons

Currently, Fivetran offers only one direction data sync. Having both directional sync would be awesome.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Wilson C.

Fivetran's service is efficient and extremely satisfactory

Used Weekly for 1-5 months
Reviewed on 2017/11/01
Review Source: Capterra

Efficiency on creating data streams from all our 3rd party programs, this helps us retrieve our data much quicker and be able to spend less engineering time.

Pros

1. The ease of the interface and how it can be easily used by any user without any technical background.

2. The amazing customer service is one of the major things that I always point to when I think about fivetran's service. Any troubleshooting emails or questions that we may have are always answered at an extremely attentive team, whether it is a question to our AM or a technical issue that might even be picked up by one of the founders. In addition, any need for a new integration that we request is often considered and then eventually built in.

3. The time it saves by having a common integration ready to go is extremely helpful. Instead of having to require an engineer to build the connection, we are able to leverage fivetran for our data streaming needs.

Cons

There isn't anything in general I don't like about Fivetran in all honesty. I think generally the only con I would mention is that there are some features that could be improved such as improving visibility into what is happening after we do an integration such as logs of files uploaded, exact upload to column name references and allowing a little more flexibility on some of the newer integrations.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend

10.0/10

Forget about ETLs!

Used Daily for 1-5 months
Reviewed on 2018/05/23
Review Source: Capterra

High-frequency ETL's to our data warehouse with an extremely simple setup and great support team.
It helped us build our data warehouse with a complex setup in no time.

Pros

Ease of use and high quality of the data source connectors.
Every connector supports a very high replication granularity (down to 5min and planned to go down to 1min), plus some connectors have specialized features, such as logical replication with the Postgres connector (which is a killer feature for real-time, low overhead, consistent replication).

Cons

It would be great to have more detailed logging, when there is an issue it is some times hard to diagnose the cause without contacting support.
Likewise, it would be great to be able to configure the query batch size (which by default is 10M rows), or to automatically adjust that based on the table size (GiB and row count), because right now if you have a table with ~10M rows but very large size, it can stall the historical sync process or require extremely large statement timeout settings.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend

9.0/10
Eddy H.

Helpful and Easy tool to use!

Used Daily for 1+ year
Reviewed on 2019/02/07
Review Source: Capterra

Pros

Fantastic software easy to use and best of all not expensive. Helps you simplify what usually becomes complicated. Now I manage ETLs without having to write or keep the code.

Cons

For the meantime, Five Trans only offers one direction data sync. It would be phenomenal if it would offer a two way directional sync. However for the price, it is a great acquisition.

Rating breakdown

Value for Money
Ease of Use
Customer Support

Likelihood to recommend

10.0/10

Fivetran Pricing

Starting from
N/A
Pricing options
Free Trial
Subscription
Value for money

Contact Fivetran for detailed pricing information.

Fivetran Features

  • API
  • Business Intelligence
  • Real Time Analytics
  • Real Time Data

  • Activity Dashboard
  • Ad hoc Reporting
  • Charting
  • Collaboration Tools
  • Customizable Reporting
  • Dashboard Creation
  • Data Filtering
  • Data Import/Export
  • Data Visualization
  • Drag & Drop Interface
  • Graphical Data Presentation
  • Monitoring
  • Real Time Reporting
  • Reporting & Statistics
  • Third Party Integration
  • Visual Analytics

Additional information for Fivetran

Key features of Fivetran

  • API
  • Ad hoc analysis
  • Ad hoc query
  • Application integration
  • Automatic adjustments
  • BI dashboards
  • Business intelligence
  • Compliance management
  • Data connectors
  • Data import
  • Data mapping
  • Data migration
  • Data pipelines
  • Data querying
  • Data replication
  • Data storage management
  • Data synchronization
  • Data warehouse support
  • Data warehousing
  • Database integration
  • Database replication
  • ELT
  • ETL
  • Error handling
  • Event collection
  • File replication
  • File replication configuration options
  • Historical archive
  • Incremental backup
  • Log events management
  • Permission management
  • Policy management
  • Real-time data
  • SSL encryption
  • Schema & table management
  • Security auditing
  • Single sign-on through Google Apps
  • Two-factor authentication
  • Up-to-date analytics

Benefits

  • Fivetran allows users to query across various applications and databases to gain a comprehensive view of company performance.

  • Users can set up SQL queries or Business Intelligence (BI) dashboards, to provide teams with quick and central access to accurate metrics.

  • Fivetran supports full historical synchronization and archives changes, even deletes, allowing users to analyze company data from any point in time.

  • Fivetran enables users to store everything so that they never lose access to information, even if they stop using a source application.

  • Provides access to up-to-date, row-level data, allowing analysts to ask just about any question using SQL or business intelligence tools.

  • Fivetran FAQs

    Below are some frequently asked questions for Fivetran.

    Q. What type of pricing plans does Fivetran offer?

    Fivetran offers the following pricing plans:

    Pricing model: Subscription

    Free Trial: Available

    Contact Fivetran for detailed pricing information.

    Q. What are the main features of Fivetran?

    Fivetran offers the following features:

    • API
    • Ad hoc analysis
    • Ad hoc query
    • Application integration
    • Automatic adjustments
    • BI dashboards
    • Business intelligence
    • Compliance management
    • Data connectors
    • Data import
    • Data mapping
    • Data migration
    • Data pipelines
    • Data querying
    • Data replication
    • Data storage management
    • Data synchronization
    • Data warehouse support
    • Data warehousing
    • Database integration
    • Database replication
    • ELT
    • ETL
    • Error handling
    • Event collection
    • File replication
    • File replication configuration options
    • Historical archive
    • Incremental backup
    • Log events management
    • Permission management
    • Policy management
    • Real-time data
    • SSL encryption
    • Schema & table management
    • Security auditing
    • Single sign-on through Google Apps
    • Two-factor authentication
    • Up-to-date analytics

    Q. Who are the typical users of Fivetran?

    Fivetran has the following typical customers:

    Large Enterprises, Mid Size Business, Small Business

    Q. What languages does Fivetran support?

    Fivetran supports the following languages:

    English

    Q. What type of pricing plans does Fivetran offer?

    Fivetran has the following pricing plans:

    Subscription

    Q. Does Fivetran support mobile devices?

    We do not have any information about what devices Fivetran supports

    Q. What other apps does Fivetran integrate with?

    Fivetran integrates with the following applications:

    Mailchimp, Marketo, Mavenlink, NetSuite, Pardot, Shopify, UserVoice, Wordpress, Xero, Zendesk

    Q. What level of support does Fivetran offer?

    Fivetran offers the following support options:

    Online Support