Informatica Cloud Data Integration vs StreamSets comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Informatica Cloud Data Inte...
Average Rating
7.8
Number of Reviews
40
Ranking in other categories
Cloud Data Integration (5th)
StreamSets
Average Rating
8.4
Number of Reviews
24
Ranking in other categories
Data Integration (8th)
 

Mindshare comparison

As of July 2024, in the Cloud Data Integration category, the mindshare of Informatica Cloud Data Integration is 3.5%, down from 7.0% compared to the previous year. The mindshare of StreamSets is 4.0%, up from 3.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Integration
Unique Categories:
No other categories found
Data Integration
1.9%
 

Featured Reviews

Amit Rajora - PeerSpot reviewer
Aug 8, 2023
A tool for easy data migration from one environment to another that needs to fix its performance issues
In the cloud, Informatica has migrated to a different environment in a single platform named IDMC, on which one can have cloud data migration, cloud application integration, data quality, and data governance, making everything combined with a single platform. Earlier in our company, we had to rely on different software or platforms for each functionality, but now we can use a single URL and work on a single platform. I would like to speak about Informatica Cloud Data Integration's performance, which is too slow but works overall as a tool. To those planning to use Informatica Cloud, I would say that it is the second-best product in the marketplace, and soon it will become the leading product. On a daily basis, the product has been increasing their overall availability and performance .On a weekly basis, the product gives out some new updates while fixing its old defects. It will be a good product in the coming years. Improvements in the current product will continue for some time. I rate the overall product a seven out of ten.
Avinash Mukesh - PeerSpot reviewer
May 17, 2023
User-friendly interface and easy integration, but needs easier transformation logic and faster support
When using Transformer for Snowflake, it's a bit complex to understand the transformation logic. You need someone who has some technical skills to handle it. You need to have some skills to transform the data. However, it's important that Transformer for Snowflake is a serverless engine embedded within the platform, so there is no need for maintenance. Having a serverless engine makes it easy for any enterprise to not think about or worry about the cost of maintaining the software. The data collector in StreamSets has to be designed properly. For example, a simple database configuration with MySQL DB requires the MySQL Connector to be installed.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Their new licensing is very flexible. With Informatica Cloud, you have plenty of items under the same umbrella, such as services, offerings, data quality, and data masking. You have also got master data management and API management. What I really like about them is that you don't need to go to Informatica and say that you need a data integration module. You would say that you need iPaaS or Informatica Cloud. They'll then try to understand your needs and give you IPUs, which are the processing units. If I purchased a hundred IPUs from Informatica as a customer, I can use 70 IPUs for data integration. I would also need data quality, so I can use 10 IPUs for data quality. I can use the remaining 20 IPUs for API management. Down the line, if I see that my initial data integration needs for the development phase are met, then out of the 70 IPUs assigned for data integration, I can use 30 IPUs for data masking. I can shuffle these numbers in any way within the Informatica Cloud umbrella for the tenure for which I have subscribed to these IPUs. I can use all services the way I want. This flexibility is what I really love about Informatica. It also has got good connectors."
"Informatica Cloud Data Integration is stable."
"It is quite easy to use and flexible."
"The solution is straightforward."
"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 solution's initial setup is quite straightforward."
"Data synchronization tasks."
"I like the fact that you can find almost any product connection that you need and the list is always expanding."
"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."
"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."
"One of the things I like is the data pipelines. They have a very good design. Implementing pipelines is very straightforward. It doesn't require any technical skill."
"It is a very powerful, modern data analytics solution, in which you can integrate a large volume of data from different sources. It integrates all of the data and you can design, create, and monitor pipelines according to your requirements. It is an all-in-one day data ops solution."
"The ability to have a good bifurcation rate and fewer mistakes is valuable."
"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 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."
"In StreamSets, everything is in one place."
 

Cons

"I would also like to have profiling functionalities and quality transformations in the cloud."
"The error information provided is not informative, as compared to Power Center."
"Its features for partitioning and optimization could be better."
"One area where Informatica Cloud Data Integration could improve is in providing more accelerators for certain functionalities."
"The price modeling could be more flexible."
"I would like to see support for more data sources."
"Informatica Cloud Data Integration could improve the price by making it less expensive."
"While my company operates on the cloud, we have seen that Informatica Cloud Data Integration has some performance issues causing it to lag."
"The monitoring visualization is not that user-friendly. It should include other features to visualize things, like how many records were streamed from a source to a destination on a particular date."
"The logging mechanism could be improved. If I am working on a pipeline, then create a job out of it and it is running, it will generate constant logs. So, the logging mechanism could be simplified. Now, it is a bit difficult to understand and filter the logs. It takes some time."
"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."
"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."
"The documentation is inadequate and has room for improvement because the technical support does not regularly update their documentation or the knowledge base."
"Using ETL pipelines is a bit complicated and requires some technical aid."
"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."
"Currently, we can only use the query to read data from SAP HANA. What we would like to see, as soon as possible, is the ability to read from multiple tables from SAP HANA. That would be a really good thing that we could use immediately. For example, if you have 100 tables in SQL Server or Oracle, then you could just point it to the schema or the 100 tables and ingestion information. However, you can't do that in SAP HANA since StreamSets currently is lacking in this. They do not have a multi-table feature for SAP HANA. Therefore, a multi-table origin for SAP HANA would be helpful."
 

Pricing and Cost Advice

"Our customers sometimes are able to negotiate a much better price for Informatica Cloud Data Integration based on their relationship with the vendor."
"The pricing is high compared to other tools on the market."
"Its pricing model can be improved."
"The price of Informatica Cloud Data Integration could be reduced."
"It's an expensive solution."
"The product is highly-priced."
"My understanding is that Informatica is quite expensive compare to other tools that are available in the market."
"I rate the product's price a seven on a scale of one to ten, where one is the cheapest and ten is the most expensive. The product is a bit expensive."
"We are running the community version right now, which can be used free of charge."
"The licensing is expensive, and there are other costs involved too. I know from using the software that you have to buy new features whenever there are new updates, which I don't really like. But initially, it was very good."
"It's not expensive because you pay per month, and the tasks you can perform with it are huge. It's reliable and cost-effective."
"The pricing is good, but not the best. They have some customized plans you can opt for."
"It has a CPU core-based licensing, which works for us and is quite good."
"StreamSets is expensive, especially for small businesses."
"The overall cost is very flexible so it is not a burden for our organization... However, the cost should be improved. For small and mid-size organizations it might be a challenge."
"It's not so favorable for small companies."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
791,948 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
15%
Computer Software Company
14%
Manufacturing Company
9%
Insurance Company
8%
Financial Services Firm
17%
Computer Software Company
13%
Manufacturing Company
8%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How does Azure Data Factory compare with Informatica Cloud Data Integration?
Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Q...
Which Informatica product would you choose - PowerCenter or Cloud Data Integration?
Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge...
What are the biggest benefits of using Informatica Cloud Data Integration?
When it comes to cloud data integration, this solution can provide you with multiple benefits, including: Overhead reduction by integrating data on any cloud in various ways Effective integration ...
What do you like most about StreamSets?
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 customiz...
What needs improvement with StreamSets?
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 ...
What is your primary use case for StreamSets?
StreamSets is used for data transformation rather than ETL processes. It focuses on transforming data directly from sources without handling the extraction part of the process. The transformed data...
 

Learn More

Video not available
 

Overview

 

Sample Customers

Chicago Cubs, Telegraph Media Group
Availity, BT Group, Humana, Deluxe, GSK, RingCentral, IBM, Shell, SamTrans, State of Ohio, TalentFulfilled, TechBridge
Find out what your peers are saying about Informatica Cloud Data Integration vs. StreamSets and other solutions. Updated: May 2024.
791,948 professionals have used our research since 2012.