We performed a comparison between AWS Database Migration Service and Oracle Data Integrator (ODI) 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."It's pretty useful when we need to migrate something big from a different type of database that AWS Data Migration Services supports."
"Even if it does break down, it will automatically recover itself and resumes from where it stopped."
"The most valuable feature of the solution is the one I use for report generation. The security risk is very low."
"I like that I can focus on the logic and I don't have to worry about the administration stuff. AWS handles that for me."
"AWS Database Migration Service is good for smaller workloads and provides compatibility."
"I am very impressed by the scalability of AWS Database Migration Service."
"Scalable and stable solution for migrating databases to AWS, with valuable features such as parallel full load and continuous data replication."
"This solution is very good at mini-batch processing."
"The most valuable feature is Data movement."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"It is an ETL tool, which does the extract, transform, and load."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"Oracle provides great documentation."
"It's scalable."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The initial setup is easy."
"What needs improvement in AWS Database Migration Service is that it lacks a log file validation feature. If the solution could provide more details about a particular transaction, that would be helpful. The stability of AWS Database Migration Service for online CDC records also needs to be improved."
"There are a set of complexities and challenges when a user wants to integrate AWS products with Microsoft products."
"The performance of data migration could be smoother."
"The initial setup can be difficult for beginners in AWS Database Migration Service. You will need the training to complete it."
"If they had some sort of functionality where, at a specific point in time, if I want to start a new job, it should automatically pick up from where it has been left rather than having people worry about the exact job number and the timing."
"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."
"I think that Amazon needs to improve the migration scenarios after analytics"
"There is no connectivity to the source database or the target database."
"The performance of the user interface is in need of improvement."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"The solution lacks some functions and features."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"It needs easier security."
"The resource management aspect of the solution could be improved."
More AWS Database Migration Service Pricing and Cost Advice →
AWS Database Migration Service is ranked 2nd in Cloud Data Integration with 27 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews. AWS Database Migration Service is rated 7.8, while Oracle Data Integrator (ODI) is rated 8.2. 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 Oracle Data Integrator (ODI) writes "Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved". AWS Database Migration Service is most compared with AWS Glue, Oracle GoldenGate, Qlik Replicate, Fivetran and SAP Data Services, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Informatica PowerCenter, Azure Data Factory and Oracle GoldenGate. See our AWS Database Migration Service vs. Oracle Data Integrator (ODI) 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.