A great automated tool for data integration
What do you like best about the product?
1. Its ability to move data between different platform
2. It is easy to connect to different sources like API's,databases etc,
3. The data integration and movement is very easy.
4. It also acts as ETL tool.
What do you dislike about the product?
1. Pricing is bit high compared to other connectors.
What problems is the product solving and how is that benefiting you?
1. I used this mainly for data movement using fivetran connectors to my databases. I use the raw data further and make the analysis.
Seamless data integration with fast setup and responsive support
What do you like best about the product?
Fivetran makes data integration incredibly easy. Setting up connectors takes only minutes, and the automated pipelines handle schema changes seamlessly. The sync process is fast and reliable, and the documentation and UI make it straightforward to monitor jobs. Whenever I had questions, the support team was responsive and helpful, making adoption smooth.
What do you dislike about the product?
There’s not much to dislike given the overall value. Pricing can be higher than some alternatives, especially for smaller data volumes, but the ease of setup, speed, and excellent support make it worthwhile.
What problems is the product solving and how is that benefiting you?
Fivetran eliminates the need to build and maintain custom data pipelines. It automatically replicates data from numerous sources into our data warehouse, which allows our analysts to focus on generating insights instead of managing integrations. The platform keeps pace with schema changes and ensures data is synced quickly and accurately, saving us significant engineering time and enabling more timely reporting.
Reliable Data Sync with a Pricey Tag
What do you like best about the product?
I appreciate Fivetran's ease of setup and usage, which made integrating our systems straightforward. Its reliability and secure platform ensure smooth data synchronization across multiple databases. I value its robust networking capabilities and the helpful services it provides for SaaS applications. Additionally, it simplifies schema management with its flexible features and supports enhanced data delivery and performance.
What do you dislike about the product?
I find Fivetran's pricing to be quite expensive. If the cost could be reduced or there were more flexible pricing options available, it would be more accessible to a larger group of users.
What problems is the product solving and how is that benefiting you?
I use Fivetran to sync data across multiple databases effortlessly with a reliable and secure platform. It simplifies ETL processes, supports easy schema changes, and offers fast data delivery, enhancing my data management experience.
Basic use of the product for data analysis
What do you like best about the product?
I like the end to end automation the most.
What do you dislike about the product?
The price, the cost of the product is a bit expensive.
What problems is the product solving and how is that benefiting you?
The automation of data analysis upload/download so that there is minimal work for the user.
Real-time data replication and integration streamline processes and enhance productivity
What is our primary use case?
The usual use cases for Fivetran that I work with involve real-time replication from Oracle Fusion, Oracle DB, and some of the APIs. I also work with replication from S3.
What is most valuable?
The most valuable feature of Fivetran so far is the data replication. The real-time data replication is what I see best in the market where it reduces the overhead of customers needing to maintain the pipeline. Even when an error occurs, it automatically tries to solve the issue without manual interaction needed.
The effectiveness of Fivetran's pre-built connectors in enhancing my customer's productivity is significant because everything is easily configurable. The documentation is very clear, so there's no difficulty in finding the necessary steps. Everything is pre-documented. The pre-built connectors that are available are excellent. Most functionalities are covered, and in most cases, it works according to expectations.
What needs improvement?
If Fivetran can build in more transformations, that would be really helpful in my opinion.
For how long have I used the solution?
I have been using Fivetran collectively based on project requirements. I work with AWS, GCP, Snowflake, and Fivetran as part of my experience. My experience with Fivetran specifically extends to about two to three years, depending on project requirements.
What was my experience with deployment of the solution?
I have not experienced any challenges with deployment.
What do I think about the stability of the solution?
From my experience, Fivetran is very reliable. They have 99.9% accuracy on the data load and they maintain transparency. When the data is loaded, they clear it from their storage, keeping only metadata for MAR calculation and pricing purposes.
How are customer service and support?
I often communicate with the technical support of Fivetran whenever we encounter issues. I would rate them a seven. If they could provide support more quickly, that would be great.
How would you rate customer service and support?
How was the initial setup?
I usually participate in the initial setup and deployment of Fivetran. I handle the solutioning from start to end.
What other advice do I have?
I don't use Fivetran's automated ETL feature, but after loading, we use dbt for the transformation.
I have not used Fivetran's Schema Drift Management feature.
The integration with data warehouses such as Snowflake and BigQuery has been successful. Fivetran has clear documentation on configuration for both warehouses.
Regarding pricing, Fivetran uses MAR pricing, which I would consider moderate. The pricing consideration ultimately depends on the project budget since the client is responsible for payment while I implement the solution.
On a scale of 1-10, I rate Fivetran a 9.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Google
Great set-it-and-forget-it solution for ELT workloads
What do you like best about the product?
Huge connector library and "it just works".
What do you dislike about the product?
You have to be careful about how many rows you are loading, given the Monthly Active Rows pricing model, which can get expensive quickly for large data sources.
What problems is the product solving and how is that benefiting you?
Allowing me to load my data sources into the warehouse so I can focus on building data models from raw data, rather than on building pipelines that load raw data. Allows me to skip having to build the extract and load step of ELT myself.
Good for large datasets - limited in terms of controls
What do you like best about the product?
It does effectively pull large data sets.
Integrations with various platforms
What do you dislike about the product?
Inability to schedule pulls, has to be every 24h. (Not necessarily for weekly / monthly reports so it seems excessive).
For CM360 it is difficult to pull 'Seat' or 'Network' as a dimension.
What problems is the product solving and how is that benefiting you?
It supports me in reporting in bulk - ultimately extracting large datasets and improving efficiency by saving time
Fivetran is Awesome.
What do you like best about the product?
Fivetran is super easy to setup and use. Mostly set and forget especially for known / existing connectors.
What do you dislike about the product?
Some connector doesn't fail as elegantly such as showing existing credentials that isn't working.
What problems is the product solving and how is that benefiting you?
I do not need a dedicated data engineer to babysit the processes because we have FiveTran.
Fivetran Is An Excellent Data Syncing Software
What do you like best about the product?
1. Great extended support for google sheets , even on cell group level. It is easier to manage scd metadata with this feature.
2. Timely sync of data with less failures acroos various connections.
3. Support for almost every other software that are used by various enterprises.This gives freedom to be in one integrator and sync data from all softwares.
What do you dislike about the product?
The Schema section in connection is a bit slow but that is understandable.It would be good if the schema is pre fetched and stored runtime so it will be easier while editing setups.
What problems is the product solving and how is that benefiting you?
We have around 50 different places company wide from where we need to sync data into warehouse on an hourly basis.Fivetran does a great job by timely syncing without delay.
The setup for any connection is very quick and easy which helps whole team to seamlessly create connections and sync various data.The Incremental/historical data sync feature is great.
Good Product -- Slow to pivot
What do you like best about the product?
We have a wide variety of source systems we need to extract data from. For 90+% of these FiveTran does the trick. Setup is easy and there isn't much to manage once set up.
What do you dislike about the product?
There is a known issue with Business Central connectors. We have been working with them for months trying to get it fixed or even get a timeline and we continue to be flying blind. This is pretty critical to our business and I'm sure with others using Microsoft Business Central so I wish they would be more communicative about this.
What problems is the product solving and how is that benefiting you?
We use this to pull in data from many sources and load them into one consolidated warehouse.