We performed a comparison between AWS Database Migration Service, Jitterbit Harmony , and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration."This solution is very good at mini-batch processing."
"The tools are very user-friendly."
"The solution is instantaneous. We can launch the service and reduce the end number of manpower."
"As the solution is on the cloud, we don't have to worry about the maintenance of software."
"The installation is easy."
"Support is helpful."
"If your infrastructure is already on Amazon, it simply makes the most sense to use a tool officially provided by them as an additional service, rather than having to rely on a third-party solution."
"The fact that it's well-integrated into multiple targets that are good for different use cases is pretty good."
"Easy integration with Salesforce"
"The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"It runs like an appliance and has tremendous throughput."
"It is very easy to build integrations and processes to pull and push data."
"We only use small parts of the solution, however, the parts that we use are quite adequate."
"Jitterbit provides the ability to quickly map data between files and databases."
"Jitterbit handles the most lines of data in a .csv and loads the quickest of any data loader I have tried."
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"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."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"The most valuable feature that we use is the Knowledge Modules."
"Besides loading data, we do most of our transformations in ODI."
"The product has an ELT approach."
"The most valuable feature is Data movement."
"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."
"The server has limits on how many can connect to the database."
"The way that the task settings work, specifically for logging, is really poor."
"This solution can offer more tweaks where the latency can be brought down to fifteen seconds."
"I think that Amazon needs to improve the migration scenarios after analytics"
"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."
"This solution is compatible with only AWS."
"There were some bugs in the product. For example if you run a delete query and test, it deletes the actual data."
"I would like the ability to offer a dedicated cloud version for security."
"Looping through complex data structures can be difficult."
"Its API management capabilities need improvement."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"Sometimes additional connectors are needed."
"The initial setup can be a little bit difficult."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"The resource management aspect of the solution could be improved."
"We used a third party to do the implementation of ODI."
"The initial setup is a bit complex compared to other tools."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"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."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"The performance of the user interface is in need of improvement."
"If you have something like Cisco on top of it, you will have endless problems."
More AWS Database Migration Service Pricing and Cost Advice →