We performed a comparison between AWS Database Migration Service, Jitterbit Harmony , and Quest SharePlex 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."The most valuable feature of the solution is the one I use for report generation. The security risk is very low."
"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."
"We particularly like that this solution has the facility to integrate with all ETL tools."
"Support is helpful."
"I am very impressed by the scalability of AWS Database Migration Service."
"The product is cheaper than all platforms"
"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."
"It's scalable."
"The Cloud Console for monitoring and troubleshooting data operations."
"It runs like an appliance and has tremendous throughput."
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"We only use small parts of the solution, however, the parts that we use are quite adequate."
"It is a scalable solution."
"Jitterbit provides the ability to quickly map data between files and databases."
"The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"It is very easy to build integrations and processes to pull and push data."
"The core features of the solution we like are the reliability of the data transfer and the accuracy of data read and write. The stability of the solution is also excellent."
"I like SharePlex's Compare and Repair tool."
"There are some capabilities within SharePlex where you can see how the data is migrating and if it still maintains good data integrity. For example, if there are some tables that get out of sync, there are ways to find them and fix the problem on the spot. Since these are very common issues, we can easily fix these types of problems using utilities, like compare and repair. So, if you find something is out of sync, then you can just repair that table. It basically syncs that table from source to target to see if there are any differences. It will then replicate those differences to the target."
"Because of the volume of the transactions, we heavily use a feature that allows SharePlex to replicate thousands of transactions. It's called PEP, Post Enhancement Performance, and that has helped us scale tremendously."
"The core replication and its performance. Performance is crucial, and SharePlex is by far the fastest. The way it handles replication to multiple targets along with basic filtering, as well as from multiple sources to a single target, is very efficient."
"The product's performance could be a little bit better."
"The cost is a concern. We use DMS because of its simplicity, but the price could definitely be more competitive."
"The solution’s scalability and performance could be improved."
"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."
"This solution is compatible with only AWS."
"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."
"More endpoints need to be supported by AWS Database Migration Service. There's also a need for more control and transparency on the product, including better technical support."
"Its API management capabilities need improvement."
"I would like the ability to offer a dedicated cloud version for security."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"Looping through complex data structures can be difficult."
"There were some bugs in the product. For example if you run a delete query and test, it deletes the actual data."
"The initial setup can be a little bit difficult."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"Sometimes additional connectors are needed."
"I would like the solution to have some kind of machine learning and AI capabilities. Often, if we want to improve the performance of posting, we have to bump up a parameter. That means we need to stop the process, come up with a figure that we want to bump the parameter up to, and then start SharePlex. Machine learning and AI capabilities for these kinds of improvement would tremendously help boost productivity for us."
"I would like more ability to automate installation and configuration in line with some of the DevOps processes that are more mature in the market. That would be a considerable improvement."
"For its function in relation to replication (i.e. filtering), I'd give it a six or seven out of 10. GoldenGate has much more functionality by comparison."
"The reporting features need improvement. It would be very good for users to have a clear understanding of the status of replication."
"I don't know how easy it would be to change the architecture in an already implemented replication. For example, if we have a certain way of architecting for a particular database migration and want to change that during a period of time, is that an easy or difficult change? There was a need for us to change the architecture in-between the migration, but we didn't do it. We thought, "This is possibly complicated. Let's not change it in the middle because we were approaching our cutover date." That was one thing that we should have checked with support about for training."
More AWS Database Migration Service Pricing and Cost Advice →