We performed a comparison between Informatica Cloud Data Integration and StreamSets based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."I do a quite a lot of data transformations, and the fact that I can do them without changing any of my SQL queries from the code, using the inbuilt tools, is very helpful."
"REST API: Excellent for scripting control and reporting mechanisms"
"The Mapping Designer allows for declarative ETL development (visual scripting) that leverages a wide array of different transformations."
"The most valuable feature of Informatica Cloud Data Integration is Pushback. You are able to push the data to the solution itself, and it can handle the queries. It helps us a lot. With other tools, the burden is kept on the server."
"The serverless capability and the packaging application of the solution are valuable."
"The support is very good."
"The data mapping capability is a valuable feature."
"The most valuable features of Informatica Cloud Data Integration for our clients are the AI capabilities within Informatica Intelligent Cloud Services."
"StreamSets Transformer is a good feature because it helps you when you are developing applications and when you don't want to write a lot of code. That is the best feature overall."
"The most valuable features are the option of integration with a variety of protocols, languages, and origins."
"What I love the most is that StreamSets is very light. It's a containerized application. It's easy to use with Docker. If you are a large organization, it's very easy to use Kubernetes."
"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 best thing about StreamSets is its plugins, which are very useful and work well with almost every data source. It's also easy to use, especially if you're comfortable with SQL. You can customize it to do what you need. Many other tools have started to use features similar to those introduced by StreamSets, like automated workflows that are easy to set up."
"I really appreciate the numerous ready connectors available on both the source and target sides, the support for various media file formats, and the ease of configuring and managing pipelines centrally."
"The entire user interface is very simple and the simplicity of creating pipelines is something that I like very much about it. The design experience is very smooth."
"The best feature that I really like is the integration."
"I have received feedback from certain teams and there is a steep learning curve to use this solution."
"It needs to be a little more intuitive but it’s really not bad."
"The error information provided is not informative, as compared to Power Center."
"Certain applications are not being synced with the ION."
"There are a small number of UI bugs that occur on occasion."
"The regions in which the data resides are still limited. This could be an issue in terms of the data residency laws of some of the countries. They should get more regions."
"Certain shortcomings in the product's UI make it an area where improvements are required."
"I would like to see more functionality added so that it is a bit closer to how much you can do with Informatica PowerCenter."
"The design experience is the bane of our existence because their documentation is not the best. Even when they update their software, they don't publish the best information on how to update and change your pipeline configuration to make it conform to current best practices. We don't pay for the added support. We use the "freeware version." The user community, as well as the documentation they provide for the standard user, are difficult, at best."
"The software is very good overall. Areas for improvement are the error logging and the version history. I would like to see better, more detailed error logging information."
"There aren't enough hands-on labs, and debugging is also an issue because it takes a lot of time. Logs are not that clear when you are debugging, and you can only select a single source for a pipeline."
"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."
"In terms of the product, I don't think there is any room for improvement because it is very good. One small area of improvement that is very much needed is on the knowledge base side. Sometimes, it is not very clear how to set up a certain process or a certain node for a person who's using the platform for the first time."
"If you use JDBC Lookup, for example, it generally takes a long time to process data."
"StreamSets should provide a mechanism to be able to perform data quality assessment when the data is being moved from one source to the target."
"One area for improvement could be the cloud storage server speed, as we have faced some latency issues here and there."
More Informatica Cloud Data Integration Pricing and Cost Advice →
Informatica Cloud Data Integration is ranked 5th in Cloud Data Integration with 40 reviews while StreamSets is ranked 8th in Data Integration with 24 reviews. Informatica Cloud Data Integration is rated 7.8, while StreamSets is rated 8.4. The top reviewer of Informatica Cloud Data Integration writes "A stable, scalable, and user-friendly solution". 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". Informatica Cloud Data Integration is most compared with Informatica PowerCenter, Azure Data Factory, AWS Glue, Fivetran and IBM Cloud Pak for Data, whereas StreamSets is most compared with Fivetran, Informatica PowerCenter, Azure Data Factory, SSIS and IBM InfoSphere DataStage. See our Informatica Cloud Data Integration vs. StreamSets report.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud 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.