We switched to Fivetran in order to stop maintaining our own ad-hoc connectors, which was brittle and time consuming. Fivetran definitely helps with hiding the complexities of connectors, retries, mapping of fields, etc. It makes it painless to add new connectors, too. Review collected by and hosted on G2.com.

For a product aimed at reducing complexity, we still experience regular problems (once or twice a month) with connectors requiring manual intervention. Also, observability is not straightforward: there used to be a log which could be accessed from the UI, which was then moved to a destination that can be queried with SQL; while the latter is more flexible, for quick checking of problems the UI-accessible log was better. Furthermore, the destination-as-log can be impacted by outages, resulting in situations where you are blind to what the actual problem was. Review collected by and hosted on G2.com.

I like their UI and the variety of available connectors. They’re really easy to set up, even if you have limited technical knowledge. Review collected by and hosted on G2.com.

Sometimes, their notifications can be a bit brief, specifically when daily data syncs are failing. Review collected by and hosted on G2.com.

I like how it transforms data from multiple databases into a single, resolvable, SQL-like dataset, including data coming from NoSQL databases. Review collected by and hosted on G2.com.

By default, it should allow sync intervals of less than 15 minutes and offer more granularity in how data is synced. The current three options (only new columns, new data, etc.) aren’t very helpful. We should also have the ability to periodically run a full data sync. Review collected by and hosted on G2.com.

The sampling data helps me prepare Press releases, case studies, data-driven stories, study patterns etc. It gives me insight into cultural shifts happening geographically. When I was working for a sustainability site, Census helped me find information about funding, allocation, and more. It is also a very reliable benchmark source for studies and surveys. Review collected by and hosted on G2.com.

Sometimes data can be outdated. Census data is collected every 5 or 10 years so one might question if the data is even reliable or not. I cannot think of anything that I dislike about Census. Review collected by and hosted on G2.com.

It was easy to set up and get up and running quickly for integrations. Support was also great, especially when we ran into performance issues. Review collected by and hosted on G2.com.

It’s expensive, and the pricing became confusing after the merger with Census. Review collected by and hosted on G2.com.

The support is very active and help to make the POC work. They help to understand the business usecase and provide assistance. UI is easy to navigate, understand and try things out. During working with Fivetran the performance seems good, having schedule options, multiple pipelines at time. It does not have AI intelligence features but making efforts for DBT to me integrated which will help to more forward easily for transformation. Price is market competitive for similar integrations for other vendors. Review collected by and hosted on G2.com.

No AI or easy to quickly make pipelines, AI can help about to create it. Not much other integrations vendors to ingest the data which was needed. Review collected by and hosted on G2.com.

Seamless connectivity and quick support. We haven’t had many incidents or much downtime, which has been great. The alerts and monitoring are solid and help us stay on top of things. Review collected by and hosted on G2.com.

The costs have increased significantly. Also, the Shopify connector doesn’t let me select or deselect columns, which is a major limitation. Review collected by and hosted on G2.com.

The best thing about Fivetran is the wide range of connectors with almost every data ingestion service and the ease of use. Automated schema handling and incremental syncs make it particularly strong for scaling ingestion across many systems. Review collected by and hosted on G2.com.

We have occasionally seen unexpected full reloads, which can be disruptive for high volume tables. MAR (Monthly Active Rows) pricing also lacks transparency and can quickly escalate for frequently updated datasets. In some cases, the fully managed nature of the platform limits deeper customisation. Review collected by and hosted on G2.com.

I like Fivetran for its effectiveness at change data capture and the HVR agent has been very valuable in quietly harvesting the data. It gathers data while putting zero load on the source database, which is really beneficial for loading near real-time data into our enterprise data platform on Snowflake. Review collected by and hosted on G2.com.

The user interface and error messaging could be more modern and user-friendly. Error messages can be less than helpful sometimes, and the UI is a bit archaic. Review collected by and hosted on G2.com.

Fivetran just launched a new AI connector feature which i find very useful where can create a connection if that is not natively available. Apart from that it is very reliable and efficient tool for data repliaction. Review collected by and hosted on G2.com.

Nothing major as of now. I’ve just noticed that a few niche tools aren’t available. Review collected by and hosted on G2.com.