We performed a comparison between Informatica PowerCenter, Spring Cloud Data Flow, and Toad Data Point based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."We can scale the product."
"Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured."
"It provides monitoring and we can therefore be aware of what is happening when we are handling jobs."
"The technical support for Informatica PowerCenter is good."
"The solution is stable."
"It is an excellent ETL tool."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"What I like the most is that we have to deal with less while writing the queries."
"The most valuable feature is real-time streaming."
"There are a lot of options in Spring Cloud. It's flexible in terms of how we can use it. It's a full infrastructure."
"The most valuable features of Spring Cloud Data Flow are the simple programming model, integration, dependency Injection, and ability to do any injection. Additionally, auto-configuration is another important feature because we don't have to configure the database and or set up the boilerplate in the database in every project. The composability is good, we can create small workloads and compose them in any way we like."
"The product is very user-friendly."
"The Connectivity and Connection Manager supports a broad number of connection types, and it is trivial for end-users to set up their own connections to sources."
"The most valuable features of Toad Data are you could write a parameterized query and it wouldn't error out, it would give you the parameters that you could input. The auto-formatting feature is useful because it was great for keeping your queries neat and understandable. The auto comment, and uncomment toggles that you could do were convenient."
"The initial setup is not straightforward. You need expertise to do it."
"I would like to see it be able to import data from NoSQL."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"While on-premises is a better product, we really need to move to the cloud and need the cloud to be as robust as this product."
"The reputation of Informatica is that it is expensive."
"Requires an established data center because there is no option for software as a service."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"The configurations could be better. Some configurations are a little bit time-consuming in terms of trying to understand using the Spring Cloud documentation."
"Some of the features, like the monitoring tools, are not very mature and are still evolving."
"On the tool's online discussion forums, you may get stuck with an issue, making it an area where improvements are required."
"Spring Cloud Data Flow could improve the user interface. We can drag and drop in the application for the configuration and settings, and deploy it right from the UI, without having to run a CI/CD pipeline. However, that does not work with Kubernetes, it only works when we are working with jars as the Spring Cloud Data Flow applications."
"Toad Data could improve by having additional features, such as query prediction. This could help someone who's not the strongest programmer. If the software could help them write queries correctly it would be very helpful, especially for small development teams or teams that lack the input skills necessary to write and program efficiently."
"On the scheduling server, some scheduled reports just sit there and never execute for the first time. After manually executing the first time, they run with no issues."