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."The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution."
"It is an excellent ETL tool."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"The number of docs has been reduced drastically, which is very good."
"It has helped us monetize."
"It has very good monitoring and process monitoring."
"The interface is very clean and clear."
"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."
"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 product is very user-friendly."
"The most valuable feature is real-time streaming."
"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 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."
"Support could be better."
"It should be more cloud-centric than on-prem-centric."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"Requires an established data center because there is no option for software as a service."
"The solution must improve the integration with new services."
"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"The configurations could be better. Some configurations are a little bit time-consuming in terms of trying to understand using the Spring Cloud documentation."
"On the tool's online discussion forums, you may get stuck with an issue, making it an area where improvements are required."
"Some of the features, like the monitoring tools, are not very mature and are still evolving."
"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."
"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."
"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."