We use Fivetran for bidirectional data synchronizations between systems.
Fivetran Data Movement Platform
FivetranExternal reviews
790 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Census has been our go-to Reverse ETL solution for enriching data in our critical business systems
What do you like best about the product?
We've greatly appreciated the ease of use of Census as well as the large collection of connectors they provide. Also the Census team has always been very responsive to our needs and great to work with!
What do you dislike about the product?
Census has some features that I'd consider table stakes for all users, but they are gated by higher level plans and so we can't access them. Like SSO, and the ability to manage all our sync configurations in Git.
What problems is the product solving and how is that benefiting you?
Rather than forcing all of our business users to use our BI system, we'd much rather bring the data to them where they work - Salesforce, Gainsight, Intercom, etc. It also allows us to enrich the data records in those systems for better outbound messaging capabilities.
Great tool to close the data loop
What do you like best about the product?
Census helps us close the loop in our data reporting by getting important product and usage data back into our CRM so that we can easily leverage it in forecasting and reporting tools.
What do you dislike about the product?
Better search functionality would help, as it's hard to identify and diagnose where some updates are coming from, like which syncs are updating which fields and who is running those syncs.
What problems is the product solving and how is that benefiting you?
For revenue reporting we aim to have all key revenue metrics in our CRM and Census is solving the problem of getting product and usage data back into the CRM. This gives the team easier access to it, and allows all the tools tied to the CRM to easily ingest the product data.
Reverse ETL is too easy with Census!
What do you like best about the product?
Census is incredibly easy to use and set up. The reverse ETL capabilities have allowed us to create "live" reporting and move beyond gconnectors. Thank you!
What do you dislike about the product?
So far, my experience with census has been only positive.
What problems is the product solving and how is that benefiting you?
Easily enabled getting data from redshift to gsheets
It's an easy to use solution for creating segments of customers
What do you like best about the product?
easy to use
connected to most ad platforms
automatic audience updates
connected to most ad platforms
automatic audience updates
What do you dislike about the product?
there were a few issues at first when trying to connect our audiences to DV360 directly
Sometimes its hard to locate the segment because there are so many, having a grouping or labels could help
Sometimes its hard to locate the segment because there are so many, having a grouping or labels could help
What problems is the product solving and how is that benefiting you?
We can constantly push new and refreshed audiences to our ad platforms directly with the tool. This is very useful, since cookies will soon disappear, we will be able to scale our ads with our 1st party data, and create lookalikes of it.
Easy access to Data with Census
What do you like best about the product?
Census is clear, concise, and gives me great insight to the various data sources and flows. I also appreciate the weekly email updates on sync success and other alerts that help me intervene when necessary.
What do you dislike about the product?
The formatting of some of the notification emails can feel cluttered and old-fashioned.
What problems is the product solving and how is that benefiting you?
Census helps us connect our data to various outputs so that other users at my organization (including me) can access data more easily and succinctly. It makes data available for all!
Easy to use
What do you like best about the product?
easy to use for data syncs from snowflake to google sheets. intuitive UI that's friendly for non-engineering configurations. overall pretty reliable and accurate.
What do you dislike about the product?
Downsides so far is that it does get hard to manage all the variety of syncs easily. When there's a large number of them, you have to remember the titles or spend a while digging around.
What problems is the product solving and how is that benefiting you?
We need to get data from snowflake into google sheets and this is the easiest way to set up that data connection without having to engineer an entire infrastructure system.
Pretty good rETL
What do you like best about the product?
Let's you connect up to your data warehouse with relatively low effort.
What do you dislike about the product?
Not the best connection scoping in the sense of how the connections are organized (i.e., per schema vs per data warehouse)
What problems is the product solving and how is that benefiting you?
Bringing data warehouse data into Salesforce
Data management made easy
What do you like best about the product?
Census has a clean UI that makes managing data between systems easy and effective. I'm able to set up a sync between sources to push data into Salesforce within minutes.
What do you dislike about the product?
For me, Census has been a phenomenal tool. It was easy for me to get started right out the gate with very little confusion. I'm excited to see what improvements are made in the future!
What problems is the product solving and how is that benefiting you?
Census has helped with connecting data sources and ensuring that our data is up-to-date across systems. It makes performing complex data ops easy and straightforward.
Very easy to use and the team is super nice!
What do you like best about the product?
The UI is extremely easy to understand and the team behind it is very quick to help and just nice overall.
What do you dislike about the product?
It is a new tool and therefore sometimes there may be bugs, but the team is super quick to address and solve them.
What problems is the product solving and how is that benefiting you?
Census makes it really easy to take information from our own data warehouse and use it to create/modify attributes and generate user audiences for our marketing team.
An easy-to-set-up solution that can be used for bidirectional data synchronizations between systems
What is our primary use case?
How has it helped my organization?
I didn't set up any transformation in Fivetran. I wanted Fivetran to take care of the log sequence number comparison between source and destination systems so that it would pick up only the data that needed to be synchronized, and it did it beautifully.
What is most valuable?
The most valuable feature of Fivetran is that it only synchronizes what needs to be synchronized. You need to capture the in-source updates and digits from the source; this is the only information you want. You don't want to download the whole thing each time. Fivetran does this just beautifully.
What needs improvement?
Fivetran should add more connectors because its competitors, like Airbyte, have more connectors. All of these systems have a problem, namely that they are pure cloud player solutions. I often work in hybrid solutions where customers have on-prem things mixed with cloud things.
Pure cloud player solutions never provide a good solution for what is on-prem, which leads to a gap. When you look at systems such as ActiveBatch, they have a very, very strong on-prem platform. They are also looking at the web and cloud things, but they are not that good at the cloud things. So there is nothing that is equally good for both on-prem and cloud.
Fivetran should add a feature to connect to the SQL server on-prem.
For how long have I used the solution?
I have been using Fivetran for a month.
What do I think about the stability of the solution?
Fivetran is a very stable solution. After you set it up, you can forget about it. I rate Fivetran a nine out of ten for stability.
What was our ROI?
Fivetran saved me a lot of work. I could have hired a bunch of engineers to write Python's code for me, but Fivetran was already built. So, it was easier for me to focus on my line of business and purchase a commercial product without trying to replicate this myself in Python. That's not a return on investment; that is savings.
What other advice do I have?
I am using the latest version of Fivetran.
Fivetran is easy to set up. It took me one or two hours to set up my flow, and then I forgot about it. So for me, it's perfect because it doesn't take a lot of time. It's not like some other solutions where you need two weeks of engineering to get them to work.
I would advise users to try Fivetran before they commit to it.
When I compare Fivetran with Airbyte, I like Airbyte better than Fivetran.
Overall, I rate Fivetran an eight out of ten.
showing 141 - 150