We use the solution to replicate data from our ERP.
Fivetran Data Movement Platform
FivetranExternal reviews
790 reviews
from
and
External reviews are not included in the AWS star rating for the product.
One stop shop for ETL
What do you like best about the product?
Its easy to get data from various sources easily and standardize them.
What do you dislike about the product?
Some API endpoints are not fully built out. so we need to request that the endpoint be added.
What problems is the product solving and how is that benefiting you?
efficient in pulling the data we need from sources.
Plug and play solution that is budget friendly
What do you like best about the product?
Creating custom ETLs with staging and error handling for multiple sources of data requires a team of engineers (or one engineer and several months). Fivetran allowed me to spin up pipelines immediately for both simple and complex sources (e.g. Facebook). It is significantly cheaper to maintain these pipelines than hiring more full time engineers! Implementing Fivetran was fast, easy and exceptionally cost effective.
What do you dislike about the product?
Fivetran worked well for all of our data sources except Google Analytics. This is likely not an issue for most users but because we have a tremendous amount of data from this source, Fivetran's plug and play delta loads just weren't the right solution. Aside from that one source, Fivetran has met all of our needs.
What problems is the product solving and how is that benefiting you?
Fivetran allows us to ingest data from multiple external sources without having to build custom code, monitor loads and manage errors. In fact, it is a completely no-code solution that requires minimal set up, even for complex data sources.
A great mid-point tool for the less technical
What do you like best about the product?
We use Census to enable data to pass through from our main data warehouse (from the frontend) to our internal systems - most notably Salesforce. Once a query is in place, setting up the model and a sync is very very easy - I particularly love the ease with which Census enables mapping of certain data fields to Salesforce fields. Syncs are reliable and we are always kept up to date if there are any issues via email notifications.
I will also say that I hugely appreciate Census's decision to enable product support via a bespoke Slack channel - it makes dealing with any issues that do arise, or questions that we do have, much more productive and pleasant as everything is centralised and can be seen by everyone. It also means that we don't need to depart our usual company comms procedure - something which is very welcome in this age of live chat, email support, callbacks, on demand Zoom calls etc.
I will also say that I hugely appreciate Census's decision to enable product support via a bespoke Slack channel - it makes dealing with any issues that do arise, or questions that we do have, much more productive and pleasant as everything is centralised and can be seen by everyone. It also means that we don't need to depart our usual company comms procedure - something which is very welcome in this age of live chat, email support, callbacks, on demand Zoom calls etc.
What do you dislike about the product?
The only issue I've come across with Census is that the default setting for all models in an instance is for it not to record the sync logs anywhere. This has to be requested and set up separately (Warehouse Writeback) - which can be an issue if not known in advance and the sync logs are suddenly required. Otherwise, everything is great!
What problems is the product solving and how is that benefiting you?
Making syncing data from an enormous BigQuery warehouse into our internal CRM systems a breeze via intelligent mapping and customisable syncs.
Easy UI, Effective Solution
What do you like best about the product?
It's variety of compatibilities and it's commitment to keep adding to the list
What do you dislike about the product?
Support is responsive, but a little slow.
What problems is the product solving and how is that benefiting you?
Fivetran is quickly and efficiently pulling data from almost all of our source systems and making it easy for us to transform it in our data warehouse.
A solid rETL platform that I have relied on for data piping into 3rd party platforms
What do you like best about the product?
- UI and ease of use is topnotch
- Support, at least in our case, has been fantastic, lovely bunch of people to work with
- Rapid product iteration in response to issues and emerging use cases. Thank you!
- Support, at least in our case, has been fantastic, lovely bunch of people to work with
- Rapid product iteration in response to issues and emerging use cases. Thank you!
What do you dislike about the product?
- I guess due to the balancing act of 80/20 (20 percent of features cover 80 of customer use cases), when it works it works however if you fall outside of the beaten path it can get flaky.
- Some new areas such as segment builder is still in its infancy
- Some new areas such as segment builder is still in its infancy
What problems is the product solving and how is that benefiting you?
Getting data out of dwh and into 3rd party platforms
Excellent reverse ETL and data pipelines tool
What do you like best about the product?
Census interface makes it easy to connect two platforms, since the implementation and day to day usage were quite simple. Also, it has error detection capabilities that I haven't seen in other solutions. It also seems to have a very robust connection engines, since I seldomly experienced downtimes. That way, you don't have to necessarily keep an eye on it at all times and can be logged out of the admin platform for days.
What do you dislike about the product?
Census' principal downside is its price, since it can be quite steep for medium-to-small companies. It also lacks some on-the-fly transformations functionality, at least on the tier I was registered to.
What problems is the product solving and how is that benefiting you?
Used Census to ingest Hubspot data to different cloud platforms, and then feed it back to Hubspot in some capacity.
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.
Census Review: Excelling in Data Integration and Ease-of-Use
What do you like best about the product?
What I appreciate most about Census is its remarkable capability to eliminate the need for extensive coding when pushing data into various system APIs. As someone managing both data engineering and data analytics teams, I recognize the immense value this brings. It not only saves a significant amount of time but also reduces the ongoing maintenance burden associated with custom code. This feature allows our teams to focus more on strategic data analysis and less on the technical intricacies of data integration. Census effectively bridges the gap between complex data operations and user-friendly functionality, making it an indispensable tool in our data management toolkit.
What do you dislike about the product?
While Census excels in many aspects, one area that could be enhanced is the control and customization of alerts. In our operation, where timely and accurate data flow is crucial, having the ability to direct specific pipeline alerts to designated Slack channels would significantly improve our response efficiency. Currently, the alerting system in Census, though effective, lacks this level of granularity. This means that alerts from various pipelines may not be as targeted as we would like. Being able to customize alert destinations based on the pipeline or data event would allow for more streamlined and focused communication within our teams. This feature would not only aid in quicker issue resolution but also help in maintaining an organized and efficient workflow, especially in a fast-paced data management environment.
What problems is the product solving and how is that benefiting you?
Streamlining Reverse ETL Processes: The primary benefit of Census for us has been its ability to streamline the reverse ETL process, particularly in eliminating the need for custom coding for different data payloads. This has significantly reduced the time and resources typically spent on developing and maintaining bespoke integration scripts.
Enhancing Salesforce Integration: By using Census to push data from our data warehouse into Salesforce (SFDC), we have improved the accuracy and timeliness of our customer data. This seamless integration ensures that our sales and customer service teams have the most relevant and up-to-date information at their fingertips, enhancing customer relationship management.
Identifying Customer Expansion Opportunities: Census plays a crucial role in our customer expansion strategy. It helps us track and highlight when customers are utilizing beyond their provisioned quota. This insight enables us to proactively approach these customers with targeted expansion or upsell opportunities, thus driving revenue growth.
Enriching Data in Intercom and Amplitude: We also leverage Census to enrich our Intercom and Amplitude datasets with key business metrics. This enrichment allows us to have a more comprehensive view of our customer interactions and product usage, facilitating better-informed decisions and more personalized customer experiences.
In summary, Census is not just a tool for data integration; it's a catalyst for operational efficiency, strategic customer engagement, and data-driven decision-making in our organization. Its impact goes beyond mere technical functionality, playing a pivotal role in enhancing our overall business processes.
Enhancing Salesforce Integration: By using Census to push data from our data warehouse into Salesforce (SFDC), we have improved the accuracy and timeliness of our customer data. This seamless integration ensures that our sales and customer service teams have the most relevant and up-to-date information at their fingertips, enhancing customer relationship management.
Identifying Customer Expansion Opportunities: Census plays a crucial role in our customer expansion strategy. It helps us track and highlight when customers are utilizing beyond their provisioned quota. This insight enables us to proactively approach these customers with targeted expansion or upsell opportunities, thus driving revenue growth.
Enriching Data in Intercom and Amplitude: We also leverage Census to enrich our Intercom and Amplitude datasets with key business metrics. This enrichment allows us to have a more comprehensive view of our customer interactions and product usage, facilitating better-informed decisions and more personalized customer experiences.
In summary, Census is not just a tool for data integration; it's a catalyst for operational efficiency, strategic customer engagement, and data-driven decision-making in our organization. Its impact goes beyond mere technical functionality, playing a pivotal role in enhancing our overall business processes.
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.
A scalable solution that is very easy to use and very easy to configure
What is our primary use case?
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.
showing 51 - 60