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!
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
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.
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?
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.
Fast and Easy integration from various Business tool to Data Lake/Warehouse
What do you like best about the product?
Super easy setup-and-forget system.
Row-based pricing.
Lots of integrations and destinations.
What do you dislike about the product?
Some bad surprises sometimes on number of rows synced.
Might not be Fivetran fault, but more about the source of data.
Yet the sudden spikes for e.g. Hubspot monthly is kinda a bad surprise sometimes.
What problems is the product solving and how is that benefiting you?
Making all of our tools' (SFDC, Sheets, etc.) data queryable in a single place (Snowflake)
My team (data) uses Census for multiple syncs to and from external systems.
What do you like best about the product?
Customer support through our external Slack channel is very helpful and quick to answer questions we have.
What do you dislike about the product?
Sometimes, small issues take a while to be addressed (e.g. boolean fields in syncs). For this reason, we occasionally need to find strange workarounds.
What problems is the product solving and how is that benefiting you?
Census is keeping data in our database synced to external systems, so that these external systems used by other teams have data that is up-to-date. This is more reliable than other methods we have used for this.
Very happy despite a rocky start
What do you like best about the product?
I found the Shopify connector to be the best of all the solutions I evaluated, and has worked really efficiently and smoothly since the implementation.The product notifications are also relevant, inisghtful and timeous while the portal interface is also clean, simple and easy to use. Overall, a really solid product at a great pricepoint for what I need.
What do you dislike about the product?
We had a bumpy start where the support provided during the trial phase was really not what I would have expected from a global company, however once the issues were resolved the solution has worked flawlessly.
What problems is the product solving and how is that benefiting you?
Creating customised reporting and analysis out of a platform like Shopify is not easy, which is something that Fivetran has allowed us to do in an efficient way. Simple, easy to use connection to move the data to an environment in which we have more control and flexibility is exactly what we wanted, and got!