We performed a comparison between AWS Database Migration Service and Informatica PowerExchange 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."This solution is very good at mini-batch processing."
"For our simple requirement of migration, DMS is just a typical AWS RDS with an IPSec tunnel to Oracle. The most valuable features for us are the networking capabilities like VPCs and VPNs."
"The most valuable feature of AWS Database Migration Service is it catches all the history changes, such as inset, observe, and delete. It tracks everything."
"Support is helpful."
"It's pretty useful when we need to migrate something big from a different type of database that AWS Data Migration Services supports."
"I am very impressed by the scalability of AWS Database Migration Service."
"The product's initial setup phase was very easy."
"The product is cheaper than all platforms"
"It is easy to integrate the solution with other tools."
"Overall, it's a good tool. It's currently number one on the market. It pretty much has all the necessary capabilities to pull the incremental data from the source system, technically speaking."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"The agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"It is a scalable and versatile solution."
"The main benefit of PowerExchange is its native real-time capabilities. Competing tools are counting on third-party packages or Oracle to offer real-time capabilities. However, Informatica has a native ability to scan the data on the file system level and capture the changes almost instantly when I push it to the consumers. The solution has a powerful built-in replication engine."
"Mainstream integration and real-time integration are the best features."
"The most valuable feature is connectivity to data sources."
"The way that the task settings work, specifically for logging, is really poor."
"The initial setup can be difficult for beginners in AWS Database Migration Service. You will need the training to complete it."
"One area that AWS DMS can improve on is its conversion of data types. For example, in Oracle, you have a data type called RAW, but in PostgreSQL there is no such thing. Thus, AWS DMS doesn't know what type I want to use when migrating from Oracle to PostgreSQL, and when performing the migration, AWS DMS changed the RAW data type to the byte data type, which isn't what I wanted."
"Support could be more expedient. Right now I am waiting on support for an extension."
"The performance of data migration could be smoother."
"This solution is compatible with only AWS."
"Whatever solution worked today can not be reused in the next migration."
"We would like to see some improvement in the performance of large scale procedures, such as when we migrate from Oracle to csSQL."
"V10.2 is very stable, but we are still struggling to make V10.5 stable. We found services that were down, and PowerExchange stopped working."
"I would like to have easier integration with cloud platforms."
"Pushdown optimization could be improved."
"Real-time has not been enhanced that much over the past few years. There has not been as many features added like they did before."
"The major shortcoming of PowerExchange is high availability and failover. None of the versions we've used to date have had the out-of-the-box ability to enable failover and high-availability requirements. This is a significant challenge and risk."
"Technical support can be improved with respect to delays in ticket response time."
"Apache Spark has a machine learning algorithm, an area where Informatica PowerExchange lacks."
"I would like the stability to improve."
More AWS Database Migration Service Pricing and Cost Advice →
AWS Database Migration Service is ranked 2nd in Cloud Data Integration with 27 reviews while Informatica PowerExchange is ranked 21st in Data Integration with 19 reviews. AWS Database Migration Service is rated 7.8, while Informatica PowerExchange is rated 7.8. The top reviewer of AWS Database Migration Service writes "A cloud solution for live replication but has stability issues". On the other hand, the top reviewer of Informatica PowerExchange writes "Handles big data better than competitors". AWS Database Migration Service is most compared with AWS Glue, Oracle GoldenGate, Qlik Replicate, Fivetran and Confluent, whereas Informatica PowerExchange is most compared with Informatica PowerCenter, Oracle GoldenGate, Azure Data Factory, SSIS and Qlik Replicate. See our AWS Database Migration Service vs. Informatica PowerExchange 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.