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."As the solution is on the cloud, we don't have to worry about the maintenance of software."
"We particularly like that this solution has the facility to integrate with all ETL tools."
"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."
"The initial setup is simple. Not that much complex."
"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."
"The initial setup is very straightforward."
"The process is now simplified because there won't be maintenance. Usually we can take a snapshot of the number I need. We can automate the backup snapshots and we can restore it very quickly. We get many benefits from the application."
"The initial setup is easy."
"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 features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"The installation of the client ODI Studio is easy."
"It's scalable."
"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."
"Oracle provides great documentation."
"Whatever solution worked today can not be reused in the next migration."
"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 live duplication has a delay of two minutes, which can be an issue."
"This solution can offer more tweaks where the latency can be brought down to fifteen seconds."
"It would be helpful if the bandwidth could be independent of the network or if we could have a dedicated bandwidth for this product."
"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."
"The cost is a concern. We use DMS because of its simplicity, but the price could definitely be more competitive."
"The names of the services need improvement since AWS doesn't indicate what the function of the product is presently. You need to read a lot to find the service that you want in the product."
"The solution lacks some functions and features."
"Stability could be improved because some operators have issues."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations."
"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."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"The initial setup is complex, especially if you also have to install a console."
"The stability of the software could be improved. Sometimes, the software just crashes. "
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 68 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 Informatica Data Integration Hub, 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.