Sign in
Categories
Your Saved List Become a Channel Partner Sell in AWS Marketplace Amazon Web Services Home Help

Fivetran Data Pipeline

Fivetran | 1

Reviews from AWS Marketplace

0 AWS reviews
  • 5 star
    0
  • 4 star
    0
  • 3 star
    0
  • 2 star
    0
  • 1 star
    0

External reviews

368 reviews
from G2

External reviews are not included in the AWS star rating for the product.


    Retail

On the Train

  • June 12, 2020
  • Review verified by G2

What do you like best about the product?
It's easy to use and support is always there for you if you need it. It also integrated with other systems that we use for data.
What do you dislike about the product?
I don't have any problems so far with it. I wish it has SCIM provisioning though
What problems is the product solving and how is that benefiting you?
I don't have any problems so far with it. Can't complain.


    Vivek K.

Go to product for Data Replication and ELT

  • June 12, 2020
  • Review verified by G2

What do you like best about the product?
Variety of Connectors available and Ease of setup
Fully Managed Pipeline
DBT Package Support
14-day free trial
What do you dislike about the product?
The Load component of ELT is very well handled by Fivetran but more features need to be added on T that is transformation. Recently, DBT Transformations are supported which is a big value add.
What problems is the product solving and how is that benefiting you?
Fivetran makes it easy to load data quickly in data warehouse with little to no maintenance required.

Benefits:

Ease of replication
Availability of a variety of connectors
Good customer support
Fully managed Pipeline
Recommendations to others considering the product:
Fivetran makes it easy to load data without requiring an army of technical resources.

Ease of use and setup makes it a go-to product for data replication for any company.


    Management Consulting

Best Replication Tool

  • June 12, 2020
  • Review provided by G2

What do you like best about the product?
1. Wide range of connectors
2. Dynamic column creation in Target if source add some column
3. SQL DB CDC option
What do you dislike about the product?
1. Errors are not user friendly.
2. Transformation option only available for SQL DB
What problems is the product solving and how is that benefiting you?
Migrated our Tradition ETL system to ELT. Fivetran helped us in migrationg from ETL to ELT.

Raw data into datalake (Snowfalke) by just few just few clicks


    Bruno M.

Easy to use and reliable ETL

  • April 24, 2020
  • Review verified by G2

What do you like best about the product?
Ease of use, and consistency. The UX allows for clear understanding of the sync processes, and troubleshooting with clear error descriptions.
What do you dislike about the product?
There is really nothing I dislike about Fivetran.
What problems is the product solving and how is that benefiting you?
ETL pipelines from across multiple vendors.
Recommendations to others considering the product:
Ensure the integrations will work for you, test it out. Netsuite is the tricky one but has been working very well for us. Fivetran provides what we need and takes away the headache of having to deal with ETL'ing data across vendors. We definitely did not want to build that in-house.

Our business is not in ETL instrumentation, so a tool like Fivetran has enabled us to connect say Salesforce to Snowflake easily, and give the entire team access to the data they need quickly and consistently.

We tested other vendors in the past who did not meet our expectations. The one caveat I would say is that we don't leverage MySQL or other binlog level replication functionality via Fivetran as we dealing with schema changes under the binlog replication model is simply too painful and potentially dangerous.

You can consider StichData as an alternative as we did, ultimately Fivetran did the job for us and we're happy with it.


    Information Technology and Services

Works well, simple to use

  • April 23, 2020
  • Review verified by G2

What do you like best about the product?
How quickly you can upload spreadsheets to tables.
What do you dislike about the product?
It was a little unintuitive to use the very first time. I believe it was between the selecting data to upload and then turning the uploaded data into tables screens.... the experience just became a little disjointed.
What problems is the product solving and how is that benefiting you?
We're turning spreadsheets into tables, simple enough. Saves time
Recommendations to others considering the product:
Not sure this applies.


    Electrical/Electronic Manufacturing

Using FiveTran for source ingestion

  • April 21, 2020
  • Review verified by G2

What do you like best about the product?
We are using FiveTran to ingest data from a number of our source systems including structured and unstructured data.

Fivetran is capable of ingesting data from these sources in the following manner:

1. Historical Sync: Whenever a new data source is added, Fivetran first takes all the data from the source and dumps it into our data platform. This is intended to be an one time activity and cannot be scheduled from the dashboard. However, this can be programmatically triggered on a schedule from a Python script if for some reason we need to refresh the data from the source.

2. Delta Sync: Once historical sync is complete Fivetran figures out what has changed in the data and it brings in those changes through these syncs. These can be scheduled to run at a frequency range of 5 minutes to 24 hours.
What do you dislike about the product?
1. MariaDB: Fivetran is supposed to perform a historical sync and then delta syncs on this data source. Fivetran can currently perform historical sync with without any issues, but delta syncs require reading binary logs from mariaDB. And Fivetran cannot keep up with the binary logs being generated at the source because they are their size. Currently, Fivetran takes about 2 hours to read binary logs that capture changes in our source system for the last 1 hour. This has been raised as a ticket to the FiveTran customer support team and they are working on a fix.

2. Transformations: Fivetran offers SQL based transformations in the tool which has some intrinsic limitations, such as processing large XML files. We’re not currently using FiveTran for transformation of data.
What problems is the product solving and how is that benefiting you?
We are able to ingest source data very easily into our data platform without having to hand code the ingestion scripts. This allow us to focus on the more value added work of transforming the data into data assets that can be leveraged by the business for reporting and analytics.


    Computer Hardware

Good variety of connectors - Lacks on scalability and Customer Support

  • April 21, 2020
  • Review verified by G2

What do you like best about the product?
- Easy to set up and configure
- Great support when it comes to setting up connectors
- Good choice of connectors
- For the connectors where it works, Fivetran performs very well
What do you dislike about the product?
- Fivetran is not scalable for large datasets, when it comes to binary log syncs. We have run into problems from day 1, as we have 100s of GB worth data to be synced from a single connector everyday. It has been over a month since the issue was first identified on Fivetran's end but there is no resolution in sight or even a timeline to resolve the issue.
- Fivetran's customer support is not very helpful as you have to constantly reach out to them for updates. On occasions, it takes them days to reply on threads or provide plausible updates.
- Fivetran sales team provided great support for 15 days before purchasing the product. But once the contract was signed that level of support was no where to be found.

Customer support is an essential service when buying into ingestion tools, especially at the premium price of Fivetran. But Fivetran fails to follow-through on scalability and customer support, from our experience.
What problems is the product solving and how is that benefiting you?
- We are trying to bring in data from multiple sources and build a central data repository. Fivetran has helped with easy setup on data ingestion and that has saved time for us in terms of building different data connectors in house.
Recommendations to others considering the product:
Fivetran provides a 15 day pilot period, where you can use the tool for free and evaluate the tool for your needs.
I would say evaluate your data source connectors thoroughly before purchasing Fivetran. We did not connect our live database due to security reasons, before purchasing Fivetran. But it turned out to be a mistake as Fivetran has failed to perform well on one of our production source.


    Michael E.

Fivetran is a blackbox - when it works, great, but when it doesn't, good luck

  • April 21, 2020
  • Review verified by G2

What do you like best about the product?
Fivetran is mostly automated, does not require much attention beyond initial setup, unless you have problems. Graphical interface makes synching easy.
What do you dislike about the product?
You aren't completely in control. Fivetran is a black box, and when there is a problem, it's really difficult to diagnose. Their support line is no prize, either.
What problems is the product solving and how is that benefiting you?
Syncing external databases which we cannot control.
Recommendations to others considering the product:
Develop a good relationship with the company or else fixing problems will be very difficult.


    Natarajan C.

fivetran takes the pain away for managing etls

  • April 21, 2020
  • Review verified by G2

What do you like best about the product?
- fivetran takes the pain away for managing etls for standard vendors
- fivetran allows non-technical users to interact with our warehouse with csv uploads functionality
- fivetran transformations works well for us with webhook connectors to dynamically load data into our warehouse
- for anonymizing data using column hashing feature while doing replication from our master to dev rds instance - this helps with gdpr concerns and keeps our dev database from having any personally identifiable information
What do you dislike about the product?
- the postgres replication (using the Logical replication method ) has major issues - we tried to replicate data from our master RDS to another instance, but found the replication slot on master consuming more space than expected - we have had support cases that never got resolved
- Not all connectors have entity level delete capturing , wish fivetran could do that.
- wish there was more visibility into when the schema for various connectors is updated (when it happens)
What problems is the product solving and how is that benefiting you?
managing data from standard vendors like salesforce, jira
understanding the vendor apis to arrive at a schema is now done by fivetran instead of an engineer


    Andrew W.

Great tool with easy integration

  • April 17, 2020
  • Review provided by G2

What do you like best about the product?
The ease of getting data into your warehouse, you can most a lot faster than more traditional custom coded solutions
What do you dislike about the product?
Some pre-built reports could be improved and also a better UI for custom built reports, lots of clicking
What problems is the product solving and how is that benefiting you?
Low code solution that provides data in almost real-time. Since the nature of our business is related to pricing, we want the ability to see feedback fast.
Recommendations to others considering the product:
Keep on building more connectors