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."The initial setup is simple. Not that much complex."
"The tools are very user-friendly."
"The installation is easy."
"Scalable and stable solution for migrating databases to AWS, with valuable features such as parallel full load and continuous data replication."
"It's pretty useful when we need to migrate something big from a different type of database that AWS Data Migration Services supports."
"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."
"Support is helpful."
"The product is cheaper than all platforms"
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"Besides loading data, we do most of our transformations in ODI."
"The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance."
"It is an ETL tool, which does the extract, transform, and load."
"It has the ability to easily load slowly changing dimensions."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value."
"This solution can offer more tweaks where the latency can be brought down to fifteen seconds."
"There are a set of complexities and challenges when a user wants to integrate AWS products with Microsoft products."
"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."
"Support could be more expedient. Right now I am waiting on support for an extension."
"Migrating from here and pushing the data from on-premise to AWS cloud is a big challenge and a few more services from AWS would be helpful. For example, we are currently using ILDB internet tools which move data from on-premise to the AWS cloud. A few more services would be really helpful for me to move the master data."
"The cost is a concern. We use DMS because of its simplicity, but the price could definitely be more competitive."
"The performance of data migration could be smoother."
"There is no connectivity to the source database or the target database."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"It needs easier security."
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"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."
"The initial setup is complex, especially if you also have to install a console."
"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 26 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, Informatica PowerCenter, SSIS, 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.