We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"The features I find most valuable is the synchronization, verification, functionalities and all the data integration features."
"The user interface which is very easy to use if we have any problems to solve."
"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."
"Whether we need data cleansing or data mastering, we get it all in one platform."
"The solution's initial setup is quite straightforward."
"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."
"It is really easy to set up and the interface is easy to use."
"I would also like to have profiling functionalities and quality transformations in the cloud."
"A general improvement in icons and the virtual interface would be good."
"I would like to see support for more data sources."
"Connectivity could be improved, it can be a little slow."
"There may be some types of limitations with the performance."
"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."
"We've seen a couple of cases where it appears to have a memory leak or a similar problem."
"My understanding is that Informatica is quite expensive compare to other tools that are available in the market."
"We are running the community version right now, which can be used free of charge."
StreamSets Dataflow Performance Manager was created to enable enterprises to harness their data in motion. It unifies visibility and control of dataflows, which reduces management costs, improves data quality and enables IT agility.
Informatica Cloud Data Integration is ranked 2nd in Cloud Data Integration with 6 reviews while StreamSets is ranked 24th in Data Integration Tools with 1 review. Informatica Cloud Data Integration is rated 7.6, while StreamSets is rated 8.0. The top reviewer of Informatica Cloud Data Integration writes "Flexible licensing, good connectors, and timely upgrades and patches". On the other hand, the top reviewer of StreamSets writes "Easy to set up and use, and the functionality for transforming data is good". Informatica Cloud Data Integration is most compared with Informatica PowerCenter, Azure Data Factory, AWS Glue, Matillion ETL and Mule Anypoint Platform, whereas StreamSets is most compared with Informatica PowerCenter, Spring Cloud Data Flow, Azure Data Factory, SSIS and Talend Open Studio.
See our list of best Data Integration Tools vendors.
We monitor all Data Integration Tools 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.