We performed a comparison between AWS Data Pipeline [EOL] and Informatica PowerCenter 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."The most valuable feature of the solution is that orchestration and development capabilities are easier with the tool."
"It is a stable solution...It is a scalable solution."
"It works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use."
"The support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible."
"The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources."
"The most valuable features are the metadata repository and the data warehouse application console."
"Among all the solutions I have used, I found Informatica PowerCenter to be much more stable in terms of application."
"It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle."
"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 ability to scale through partitions helped us to improve the performance."
"It's almost semi-automatic because you must review and approve code push, which works well. Still, we had many problems getting there during the deployment process, but we got there."
"The user-defined functions have shortcomings in AWS Data Pipeline."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"What I didn't like about it is that the platform itself is not great at distributed processing. When you need high parallel processing, it has some inherent issues. We had to use Java transformation, and it did not go very well. I have heard that it is going to the cloud, but we haven't tried that."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"The licensing is difficult."
"The initial setup is not straightforward. You need expertise to do it."
AWS Data Pipeline [EOL] doesn't meet the minimum requirements to be ranked in Cloud Data Integration with 2 reviews while Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews. AWS Data Pipeline [EOL] is rated 8.0, while Informatica PowerCenter is rated 8.0. The top reviewer of AWS Data Pipeline [EOL] writes "A tool with great orchestration and development capabilities but needs to improve its user-defined functions". On the other hand, the top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". AWS Data Pipeline [EOL] is most compared with AWS Database Migration Service, AWS Glue, Oracle Data Integrator (ODI), FME and Perspectium DataSync, whereas Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue. See our AWS Data Pipeline [EOL] vs. Informatica PowerCenter 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.