We have multiple data available from multiple sources. We use the tool to collect the data in one data warehouse.
Fivetran Data Movement Platform
FivetranExternal reviews
456 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Absolutely seamless data pipeline automation solution with an interesting pricing model
What do you like best about the product?
The solution is absolutely intuitive and works seamlessly. It has scheduled maintenances from time-to-time, but nothing that obstructs daily business. The connectors have a very easy set-up and sync process. The pricing model also seems to be pretty reasonable if you are using the solution to connect multiple data sources, but with low-mid volume of data.
What do you dislike about the product?
The number of connectors are a bit limited and their custom connector creation is completely on you and is not really user-friendly. Also, a lot of connectors only have a full sync of all possible data you have on a source system and not selective sync that enables you take only the required data to your destination. This leads to unnecessary data being dumped on to your destination and incurs more costs to the client.
What problems is the product solving and how is that benefiting you?
Fivetran enables us connect multiple data sources and siloed systems with very less effort and that helps us focus on driving business outcomes rather than focussing on ETL and creating data pipelines. Fivetran also helps us connect to systems that have no direct connection to our visualization tools like Power BI or Tableau.
Pricing structure makes it nearly impossible to cost and resell
What do you like best about the product?
consistent schema and data syncing if running
What do you dislike about the product?
pricing model and costs based on sync efficiency vs actual data useage
What problems is the product solving and how is that benefiting you?
consistently updating multiple data sources into a data warehouse. great concept and simplifies an important part of the process
Product is good, sale team and price is terrible
What do you like best about the product?
Reduce remarkably time to insight / market of data products.
Reduce engineering part of data projects.
Reduce engineering part of data projects.
What do you dislike about the product?
Slow response on incidents, we used to got more than 2 weeks downtime of Facebook pages connectors and Fivetran refused all responsibilities.
They mostly stop supportive response after signing anual contract.
They mostly stop supportive response after signing anual contract.
What problems is the product solving and how is that benefiting you?
Pre-built connectors help us to push up the data extraction process
The product is affordable and easy to deploy, but the technical support must be improved
What is our primary use case?
What is most valuable?
The product has some seamless connectors, which are readily available.
What needs improvement?
The connectors from some websites are not available. It is hard to get the data and work on it. The product should expose the APIs in a better way. The cloud functions are very code-centric. A low-code tool or a no-code tool would give us more flexibility. The environment must be more development-friendly.
For how long have I used the solution?
I have been using the solution for two to three months.
What do I think about the stability of the solution?
The tool’s stability is good.
What do I think about the scalability of the solution?
Five people use the solution in our organization. We need two people to maintain the tool.
How are customer service and support?
The technical support must be improved. There are a lot of communication barriers. We raise a ticket and wait for days. The team has integrations with communication channels, like Slack, but we have to wait for the support team to look up the issue and answer. The team was proactive during the proof of concept, but the support got slower as soon as we got the license.
How would you rate customer service and support?
Neutral
How was the initial setup?
The product is cloud-based. The deployment process is very straightforward. We get the data from different websites and integrate it into our database. We just sync the data on a daily or weekly basis. We needed two people for the deployment. It took two to three days to deploy the tool.
What's my experience with pricing, setup cost, and licensing?
The solution is affordable. The pricing model is good.
Which other solutions did I evaluate?
We evaluated Domo, Snowflake, and Airbyte. We chose Fivetran because it was a prominent product in the market.
What other advice do I have?
I did the proof of concept, and my organization is in the process of deploying the solution. We have a lot of issues. People who want to work with the product must list the requirements of the extraction website and the web sources from which the data needs to be extracted. They should choose Fivetran only if the connector is readily available. They must not search for custom connectors. Overall, I rate the tool a seven out of ten.
Fivetran has been a valuable addition to our data tools arsenal
What do you like best about the product?
Fivetren makes data processes simple/quick. Our team likes how easy it is to start without any coding. There are many turn-key connectors available, which is great for businesses that we provide IT services for. Also, their netsuite connector helps us move data smoothly. The interface is quite user-friendly, so we can delegate tasks to junior data specialists within our tema and cut maintenance costs for our clients.
What do you dislike about the product?
A recurring concern is the pricing model, particularly the cost associated with automating and tracking historical data and data warehouse tables. The model based on monthly active rows can be confusing, making it challenging to forecast expenses, especially for our enterprise customers with vast amounts of data.
What problems is the product solving and how is that benefiting you?
We use Fivetran as one of the key elements of our client's data systems. It assists with ELT, offers out-of-the-box integrations for most of the common SaaS tools our clients use, and then the data goes straight to the warehouse. We also created three custom connectors ourselves. Everything works pretty smoothly and requires little attention for maintenance.
Easy to learn, so you can quickly manage ETL pipelines, but it could have more customization options
What is our primary use case?
We mainly use Fivetran for ETL.
What is most valuable?
There's a very good layer that allows you to connect different data sources and establish a very good ETL workflow. You can manage all of your connectors individually, which gives you a very good ability to trace which one of your ETL processes is running and when. The solution also allows you to schedule each of those runs with different cadences, depending on which plan you are on. At the same time, for those runs, you have the ability to hash, unhash, or map any data that might be sensitive or personally identifiable, and that's pretty robust. It's a feature in the standard plan, so you don't need the enterprise plan for that. One very powerful and cool feature is how you can integrate the solution with other transformation tools, such as dbt, or run the transformations within Fivetran itself to create a transformation layer on top of your ETL layer. That allows you to manage the entire ETL workflow end to end from within the platform without the need for any additional tool.
When it comes to managing ETL pipelines, these features are valuable.
What needs improvement?
Given that Fivetran is a fully managed third-party solution, the customization could improve because Fivetran gives more thought to people who don't want to manage analytics workflows rather than engineers who want to be able to customize pipelines more thoroughly.
For how long have I used the solution?
I've had experience with Fivetran for about two-and-a-half to three years.
What do I think about the scalability of the solution?
The scalability will directly relate to the plan you're on. It will be very important to see that the provisioning in compute and the provisioning you have to run workflows and jobs will also be directly related to your use case. Managing scalability in that way is a bit complex, but you get a lot of support from Fivetran.
How are customer service and support?
From a customer support standpoint, Fivetran does an amazing job in establishing and helping you customize while ensuring you have the right plan for your data needs. I have full contact with our account executive, and she's super nice and walks us through many of these use cases that will be important in the future and many of the estimations we might need for the workflow we plan on integrating.
How would you rate customer service and support?
Positive
Which solution did I use previously and why did I switch?
I have used Splunk before, and it's more technical. Splunk allows you to version things and have a good engineering process around your ETL pipeline. It also has very good logging and documentation tools. But now that Fivetran has a better exposed API, it is much more flexible. But Splunk beats Fivetran regarding things like customization, for example. We switched to Fivetran because we reduced the engineering team. We had fewer people to manage all the different ETL processes, so we had to leverage more automated third-party tools, and Fivetran made onboarding new engineers a lot easier.
How was the initial setup?
Fivetran is very easy to set up. It's a matter of having the connection information of each one of the endpoints you want the ETL through. The solution is very comprehensive and easy to set up. It even gives you assistance on where to find the information that you might need, depending on the data source. It has pre-built connectors for the most common data sources, so it also helps you expedite that process if you are not super tech-savvy.
What's my experience with pricing, setup cost, and licensing?
Fivetran has a pricing model that scales the more data sources you add. When you have a lot of workflows and complex use cases, pricing goes down as you use it more. That's a very good feature of its pricing. Fivetran might be a bit pricey for a very limited or small number of data sources that might be easily collected in other forms. The pricing gets better the bigger you are.
Which other solutions did I evaluate?
Comparing Fivetran to other tools such as dbt, AWS Glue, or Azure Data Factory, the other tools are more robust and allow us to run custom transformations.
What other advice do I have?
To anyone who uses the product, I say monitor. You have a dashboard to monitor your MAR, which is a row-level metric Fivetran uses to gauge how much you are consuming. If you can monitor your MAR closely, you can get a very good understanding of how much data you're moving, and it will allow you to adjust the cadences you might need to get a better bang for your buck. Watch your numbers and try to plug in as many data sources as you need because that will help you with pricing.
I rate Fivetran a seven or a seven-point five out of ten. It's solid and offers a very simple UI and way to get set up. It might fall short for people who want more advanced use cases or people who have knowledge and tools that they can integrate, and that's where things get a bit more technical. But I feel the leap from just getting started with it to getting very technical with it is very large. There's no middle ground.
Seamless Data Integration Made Possible With Fivetran
What do you like best about the product?
The set up of the tool is very easy. The tool also has wide range of connectors; customer support is excellent.
What do you dislike about the product?
The cost is little on the higher end so I wouldn't recommend for early stage orgs. There is slight learning curve involved.
What problems is the product solving and how is that benefiting you?
The tool helps us pull data from multiples systesm i.e. Salesforce, HubSpot, Google AdWords. It also saves us a lot of time to integrate these systems and centralize the data at data warehouse level (Snowflake). The tools is literal plug and play.
Streamlined Data Integration for Enhanced Marketing Dashboards
What do you like best about the product?
Fivetran seamlessly automates the data flow from our CDP (Segment) to our staging warehouse (Google Big Query), ensuring timely and efficient data integration for our marketing dashboards. The extensive range of connectors allows us to integrate various data sources, enhancing the efficiency and accuracy of our TOFU, MOFU, and BOFU marketing strategies.
What do you dislike about the product?
While Fivetran is efficient, it offers limited customization options, which can be a challenge when dealing with diverse data sources and complex transformations. In our case it was Intercom. The cost of using Fivetran may be a concern for smaller projects with a limited budget.
What problems is the product solving and how is that benefiting you?
We utilize Fivetran for transforming and validating data for our marketing dashboards. It plays a crucial role in providing insights into our conversion funnels and helping us optimize our marketing and customer success strategies.
The data flows from Segment to Google Big Query and then undergoes transformation in Fivetran, validation in dbtCloud, and finally moves to the production warehouse (Google BQ with dbt_metrics dataset). This streamlined process has enhanced our ability to monitor and analyze our Acquisition & Activation, Activation & Retention, and Referral & Revenue efforts, corresponding to TOFU, MOFU, and BOFU stages respectively.
The data flows from Segment to Google Big Query and then undergoes transformation in Fivetran, validation in dbtCloud, and finally moves to the production warehouse (Google BQ with dbt_metrics dataset). This streamlined process has enhanced our ability to monitor and analyze our Acquisition & Activation, Activation & Retention, and Referral & Revenue efforts, corresponding to TOFU, MOFU, and BOFU stages respectively.
A scalable solution that is very easy to use and very easy to configure
What is our primary use case?
We use the solution to replicate data from our ERP.
What is most valuable?
The product is very easy to use and very easy to configure. We can do an end-to-end configuration in a few minutes.
What needs improvement?
The connections with SAP must be improved. The environment has some limitations.
For how long have I used the solution?
I have been using the solution since January 2023.
What do I think about the stability of the solution?
The product’s stability is very good.
What do I think about the scalability of the solution?
The tool’s scalability is very good.
How was the initial setup?
The initial setup is very easy. It is not that complex. I was part of the deployment process. It is still ongoing. We are not running production for now.
What about the implementation team?
We need two or three IT employees to maintain the solution.
What's my experience with pricing, setup cost, and licensing?
The solution has good pricing. I rate the pricing a six out of ten.
What other advice do I have?
It's a good integration tool. It is easy to use. Overall, I rate the solution a nine out of ten.
Providing the best all-around Headless solution but at a high price
What do you like best about the product?
We used Fivetran with their Headless Powered by Fivetran solution and it's incredibly helpful, quick and easy to setup and it handles pretty much everything, user authentication included (which others don't).
What do you dislike about the product?
The pricing based on number of rows makes it nearly impossible to be able to predict before-hand how much each connector is going to use and in addition to that ends up being quite expensive (compared to price per number of connectors as many other providers do)
What problems is the product solving and how is that benefiting you?
Centralize marketing and business data from our Agency's clients in order to provide them with better insights and additional analysis in a quick and semi-automated way.
showing 91 - 100