We performed a comparison between Fivetran and StreamSets based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It is not like a traditional ETL, but it gives quite a lot of flexibility."
"Fivetran can perform data migration incredibly fast, depending on the source and target."
"Fivetran is remarkably easy to use; I haven't encountered any other data integration tool that is as user-friendly."
"Its arrays are powerful enough to handle migrations even when the replication is happening in the background, without causing any trouble with the ongoing traffic."
"The product has some seamless connectors, which are readily available."
"The solution is stable. We've never faced any stability issues."
"The compare feature is the most valuable piece of it."
"For us, Fivetran has been able to scale both in terms of the data we bring into our warehouse and the amount of data that we use as well."
"The most valuable features are the option of integration with a variety of protocols, languages, and origins."
"The best feature that I really like is the integration."
"I have used Data Collector, Transformer, and Control Hub products from StreamSets. What I really like about these products is that they're very user-friendly. People who are not from a technological or core development background find it easy to get started and build data pipelines and connect to the databases. They would be comfortable like any technical person within a couple of weeks."
"The UI is user-friendly, it doesn't require any technical know-how and we can navigate to social media or use it more easily."
"The ability to have a good bifurcation rate and fewer mistakes is valuable."
"For me, the most valuable features in StreamSets have to be the Data Collector and Control Hub, but especially the Data Collector. That feature is very elegant and seamlessly works with numerous source systems."
"It's very easy to integrate. It integrates with Snowflake, AWS, Google Cloud, and Azure. It's very helpful for DevOps, DataOps, and data engineering because it provides a comprehensive solution, and it's not complicated."
"Important features include that it comprises lots of functionality to connect data from various sources through connector availability, scheduling pipelines at any time, and integration with third-party and security solutions for encryption."
"HVR Software's technical support could be improved. Whenever we log a case, the response that we get from the support is a bit delayed."
"Fivetran should add more connectors because its competitors, like Airbyte, have more connectors."
"We experience cost issues because Fivetran is charged on a usage basis. When you reach a certain level, the tool should focus on reducing the costs. The solution is expensive when you are moving gigabytes and petabytes of data. It should also focus more on REST APIs and webhooks."
"The documentation is decent, but it's hard to find information online about Fivetran. For example, if you try to search for an error code, you won't find much information about it in forums."
"Fivetran would be improved by adding the ability to integrate the data from third-party APIs."
"The connections with SAP must be improved."
"I would like for them to incorporate additional transformations. A valuable aspect of the product is that it does inflight transformations and that could be expanded."
"Some of the pain points we're looking at are trying to integrate some of the items in the Microsoft stack, so SharePoint and Excel, and then some of the newer Azure services."
"StreamSet works great for batch processing but we are looking for something that is more real-time. We need latency in numbers below milliseconds."
"Sometimes, it is not clear at first how to set up nodes. A site with an explanation of how each node works would be very helpful."
"Visualization and monitoring need to be improved and refined."
"We create pipelines or jobs in StreamSets Control Hub. It is a great feature, but if there is a way to have a folder structure or organize the pipelines and jobs in Control Hub, it would be great. I submitted a ticket for this some time back."
"If you use JDBC Lookup, for example, it generally takes a long time to process data."
"We often faced problems, especially with SAP ERP. We struggled because many columns weren't integers or primary keys, which StreamSets couldn't handle. We had to restructure our data tables, which was painful. Also, pipeline failures were common, and data drifting wasn't addressed, which made things worse. Licensing was another issue we encountered."
"One area for improvement could be the cloud storage server speed, as we have faced some latency issues here and there."
"Sometimes, when we have large amounts of data that is very efficiently stored in Hadoop or Kafka, it is not very efficient to run it through StreamSets, due to the lack of efficiency or the resources that StreamSets is using."
Fivetran is ranked 13th in Data Integration with 19 reviews while StreamSets is ranked 8th in Data Integration with 24 reviews. Fivetran is rated 8.0, while StreamSets is rated 8.4. The top reviewer of Fivetran writes "Solution reduces time-to-value; high ROI". On the other hand, the top reviewer of StreamSets writes "We no longer need to hire highly skilled data engineers to create and monitor data pipelines". Fivetran is most compared with AWS Database Migration Service, Qlik Replicate, Azure Data Factory, Oracle GoldenGate and Confluent, whereas StreamSets is most compared with Azure Data Factory, Informatica PowerCenter, SSIS, Oracle GoldenGate and IBM InfoSphere DataStage. See our Fivetran vs. StreamSets report.
See our list of best Data Integration vendors and best Cloud Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.