Fivetran Data Movement Platform
FivetranExternal reviews
458 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Best in Class at Competitive Price
What do you like best about the product?
Fivetran is a best in class product, that offers services to our smaller use company at a reduced price rate.
What do you dislike about the product?
Like any other pay per usage software, lower usage levels result in longer support times.
What problems is the product solving and how is that benefiting you?
Fivetran takes care of the extracting and loading in the modern data stack. It allows us to get the data from disparate systems in one place for analysis.
The leading low-code data ingestion solution
What do you like best about the product?
Fivetran offers a truly competitive solution for data integration, in particular when you're looking to connect to a source application and ingest that data into a Data Warehouse or Data Lake and to do that with minimal development/configuration/customization. The best features are:
- The number of application connectors. There are hundreds of connectors to both SaaS/Web based applications such as Salesforce, Coupa, JIRA, etc as well as database and on-premise, of particular interest to us was SAP
- The ease of configuration/setup to integrate to a source connection and the time taken to ingest and synch to a destination connection
- The Data Change Capture (CDC) feature for many of the connectors (not all connectors offer CDC) is very slick and will easily manage INSERTS, UPDATES, DELETES in your data and track the date/time of those changes
- The ability to connect to SAP and manage CDC through the database logs. This provides a minimal intrusion feature that is not reliant on many other SAP connectors/integrations which go through the API layer (RFC)
- The SAP integration can ingest many of the complicated SAP objects such as long-text data/tables involving structures like pool and cluster
- The easy UI that allows you to change basic configurations such as frequency of update, tables/fields required to ingest and usage/billing
- Technical Support is excellent and responsive, although you probably have to be on the Business Critical support to realize this
- Integration with dbt and an emerging "Marketplace" of pre-built models and transformations
- The number of application connectors. There are hundreds of connectors to both SaaS/Web based applications such as Salesforce, Coupa, JIRA, etc as well as database and on-premise, of particular interest to us was SAP
- The ease of configuration/setup to integrate to a source connection and the time taken to ingest and synch to a destination connection
- The Data Change Capture (CDC) feature for many of the connectors (not all connectors offer CDC) is very slick and will easily manage INSERTS, UPDATES, DELETES in your data and track the date/time of those changes
- The ability to connect to SAP and manage CDC through the database logs. This provides a minimal intrusion feature that is not reliant on many other SAP connectors/integrations which go through the API layer (RFC)
- The SAP integration can ingest many of the complicated SAP objects such as long-text data/tables involving structures like pool and cluster
- The easy UI that allows you to change basic configurations such as frequency of update, tables/fields required to ingest and usage/billing
- Technical Support is excellent and responsive, although you probably have to be on the Business Critical support to realize this
- Integration with dbt and an emerging "Marketplace" of pre-built models and transformations
What do you dislike about the product?
- The support for dbt does not currently include Azure Synapse, which is what we are using for our Data Platform
- The frequency of refresh configuration is good, but it would also be good if you could have a "Date/Time" of refresh rather than a synch period such as "Every 1 hour, every 24 hours, etc"
- Would be nice if Fivetran could support the ingestion of SAP structure fields/tables
- Would be great if Fivetran could ingest SAP BW data
- The frequency of refresh configuration is good, but it would also be good if you could have a "Date/Time" of refresh rather than a synch period such as "Every 1 hour, every 24 hours, etc"
- Would be nice if Fivetran could support the ingestion of SAP structure fields/tables
- Would be great if Fivetran could ingest SAP BW data
What problems is the product solving and how is that benefiting you?
- We can now ingest data from some of our enterprise applications where it has been extremely difficult or near impossible previously. Many of the previous "integrations" existed of basic text/csv exports from some of our applications or emailed reports. This process was very manual, and now the data just appears in our Data Lake and, all the changes are handled beautifully.
- In SAP, some tables are very difficult sometimes, impossible to ingest without major development/integration efforts, such as ingesting pool/cluster tables. The method we have previously used in going via the SAP API (RFC) has also been much slower, and managing the data changes has had to be managed programmatically
- We will be able to ingest data from some applications at a higher frequency than daily/nightly, which helps with the number of use cases we often have to deal with around manufacturing processes
- In SAP, some tables are very difficult sometimes, impossible to ingest without major development/integration efforts, such as ingesting pool/cluster tables. The method we have previously used in going via the SAP API (RFC) has also been much slower, and managing the data changes has had to be managed programmatically
- We will be able to ingest data from some applications at a higher frequency than daily/nightly, which helps with the number of use cases we often have to deal with around manufacturing processes
Fantastic tool, great support!
What do you like best about the product?
Support has been fantastic in helping get everything up and running. It's highly customizable and straightforward to use.
What do you dislike about the product?
Not everything is plug and play -- there is absolutely some coding still needed and experience with APIs.
What problems is the product solving and how is that benefiting you?
It is helping bridge the gap of needing SQL abilities to query Zendesk data.
The ONLY solution for Microsoft SQL Integrations
What do you like best about the product?
Super simple to set up and manage in comparison with other products on the market. FiveTran also gives complete control over what data is needed and how it is transformed into the new location.
What do you dislike about the product?
Better integrations with other platforms such as Pipedrive.
What problems is the product solving and how is that benefiting you?
We needed Microsoft SQL data migrated into a data warehouse. Fivetran has been the most accessible and affordable option to allow us to do this regularly without any issues.
Fast, secure and the support is incredible!
What do you like best about the product?
It just works! Easy to setup an account, setup a source and a destination (given you have all proper accesses), and data just flows into a usable data model. Takes hours off from ETL developers so that they can focus on the "T". No need for a developer to go through days of reading documentation, testing integrations, transforming the data, etc.
What do you dislike about the product?
Missing sources from our pool of applications and the turnaround time to get access to a new source is very slow. The community voting system is great but this still means that I need to have a developer take weeks to integrate raw data from these missing sources.
What problems is the product solving and how is that benefiting you?
Fast data integration allows us to work on data models and transformations more quicker.
Good
What do you like best about the product?
Very easy to use and get started on building out ETL framework.
What do you dislike about the product?
Needs more connectors, and even setting up simple REST APIs is complicated.
What problems is the product solving and how is that benefiting you?
No data engineering team required, lots of pipelines are plug/play
Great for mature tech stacks and startups alike
What do you like best about the product?
ease of use, plug and play, detail of schemas, pre-built dbt packages
What do you dislike about the product?
Pricing is excessively expensive, it is based on volume rather than value. Some datasets are high volume low value and vice versa. We are not willing to spend so much money for low value high volume sets
What problems is the product solving and how is that benefiting you?
Connectors between data sources and warehouse, e.g. Jira, Github etc
Big time saver, lots of well built integrations
What do you like best about the product?
Fivetran is a "set it and forget it" product. It has saved our team countless hours of connecting data sources to our data warehouse and allows a large degree of flexibility in the schema.
What do you dislike about the product?
I don't have many complaints about fivetran. It's a bit expensive, but worth it to our team.
What problems is the product solving and how is that benefiting you?
Getting data from various data sources into our data warehouse for our data science team to analyze.
Easy Peasy
What do you like best about the product?
Lots of connectors available out of the box
What do you dislike about the product?
Can't choose cloud provider on Standard Plan
What problems is the product solving and how is that benefiting you?
Connecting and synchronizing all of my data sources into Snowflake
Fivetran is the best ETL in the industry. No questions!
What do you like best about the product?
The ease of use and dashboard
The support team
The documentation
The support team
The documentation
What do you dislike about the product?
Pricing model can be a bit confusing and hard to understand
What problems is the product solving and how is that benefiting you?
Helping us solve our entire data ingestion stack
showing 51 - 60