Try our new research platform with insights from 80,000+ expert users

AWS Database Migration Service vs Qlik Compose comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

AWS Database Migration Service
Average Rating
8.0
Number of Reviews
30
Ranking in other categories
Cloud Data Integration (2nd)
Qlik Compose
Average Rating
7.6
Number of Reviews
12
Ranking in other categories
Data Integration (21st)
 

Featured Reviews

StevenLai - PeerSpot reviewer
Sep 20, 2024
Straightforward to set up with easy of capturing database changes and secure storage
We are setting up CDT jobs to get database changes from AWS RDS. We are not really migrating anything, but we get the changes from our source RDS instance and save it as a file in an S3 bucket For our continuity planning, we need all the history happening in the source database because AWS source…
Sahil Taneja - PeerSpot reviewer
May 5, 2023
Easy matching and reconciliation of data
The initial setup was easy for the data warehousing concept. But for a person who is new to ETL and warehousing concepts, it may take some time. If someone is familiar with these concepts, they could understand and learn the tool quickly. However, compared to other tools, the UI is complex. It would be helpful to have a better UI and documentation for new users. As of now, there is a challenge in learning the Compose tool for new users altogether. Qlik Compose was deployed on-premises. But the servers, like the SQL servers were maintained on the cloud—the managed instances.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The database migration services allow us to do real-time synchronization of on-premise and database to plan out our releases."
"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."
"What I like about AWS Database Migration Service is that it's a good product that allows you to migrate terabytes of data. My team was able to migrate almost 16TB of data using AWS Database Migration Service. The solution works fine for my use case."
"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 product is cheaper than all platforms"
"The solution is stable and reliable."
"DMS's architecture is highly beneficial, allowing for scalable migrations of large datasets."
"The product's initial setup phase was very easy."
"The technical support is very good. I rate the technical support a ten out of ten."
"It's a stable solution."
"I have found it to be a very good, stable, and strong product."
"As long as you pick the solution that best fits with your requirements, you won't find that performance is a problem. It's good."
"One of the most valuable features was the ability to integrate multiple source systems that mainly used structured IDBMS versions."
"One of the most valuable features of this tool is its automation capabilities, allowing us to design the warehouse in an automated manner. Additionally, we can generate Data Lifecycle Policies (DLP) reports and efficiently implement updates and best practices based on proven design patterns."
"The most valuable is its excellence as a graphical data representation tool and the versatility it offers, especially with drill-down capabilities."
"There were many valuable features, such as extracting any data to put in the cloud. For example, Qlik was able to gather data from SAP and extract SAP data from the platforms."
 

Cons

"There is no connectivity to the source database or the target database."
"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."
"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 product's performance could be a little bit better."
"There could be enhancements in the product intelligently covering more scenarios to prevent crashes or failures."
"Sometimes we encounter errors, and the error messages from DMS are very ambiguous and sometimes misleading."
"There are a set of complexities and challenges when a user wants to integrate AWS products with Microsoft products."
"The server has limits on how many can connect to the database."
"When processing data from certain tables with a large volume of data, we encounter significant delays. For instance, when dealing with around one million records, it typically takes three to four hours. To address this, I aim to implement performance improvements across all tables, ensuring swift processing similar to those that are currently complete within seconds. The performance issue primarily arises when we analyze the inserts and updates from the source, subsequently dropping the table. While new insertions are handled promptly, updates are processed slowly, leading to performance issues. Despite consulting our Qlik vendors, they were unable to pinpoint the exact cause of this occurrence. Consequently, I am seeking ways to optimize performance within Qlik Compose, specifically concerning updates."
"I'd like to have access to more developer training materials."
"It would be better if the first level of technical support were a bit more technically knowledgeable to solve the problem. I think they could also improve the injection of custom scripts. It is pretty difficult to add additional scripts. If the modeling doesn't give you what you want, and you want to change the script generated by the modeling, it is a bit more challenging than in most other products. It is very good with standard form type systems, but if you get a more complicated data paradigm, it tends to struggle with transforming that into a model."
"There is some scope for improvement around the documentation, and a better UI would definitely help."
"Qlik's ETL and data transformation could be better."
"For more complex work, we are not using Qlik Compose because it cannot handle very high volumes at the moment. It needs the same batching capabilities that other ETL tools have. We can't batch the data into small chunks when transforming large amounts of data. It tries to do everything in one shot and that's where it fails."
"My issues with the solution's stability are owing to the fact that it has certain bugs causing issues in some functionalities that should be working."
"There should be proper documentation available for the implementation process."
 

Pricing and Cost Advice

"The solution’s pricing is reasonable."
"The product is pretty expensive"
"Pricing can be improved."
"The pricing is per hour, though I do not have the exact figures. If you have specific questions about the service, a personal support team from Amazon is available, but this will bring in additional costs."
"For Egypt, the product's prices are high, making it a specific problem in one region and not globally."
"I would rate the pricing a seven out of ten."
"AWS Database Migration Service is the least expensive solution, but is still expensive."
"AWS Database Migration Service is very inexpensive."
"While they outperform Tableau, there's room for improvement in Qlik's pricing structures, especially for corporate clients like us."
"The price of the solution is expensive."
"On a scale of one to ten, where one is cheap, and ten is very expensive, I rate the solution a six."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
814,649 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
21%
Computer Software Company
15%
Government
8%
Manufacturing Company
7%
Financial Services Firm
14%
Computer Software Company
11%
Manufacturing Company
11%
Government
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What resources can you use to learn how to utilize AWS Database Migration Service?
As with all AWS products, you are given very useful documentation with AWS Database Migration Service. Before we started using this product, we went over it and we were able to learn the basics an...
Would you recommend AWS Database Migration Service as a cloud data integration tool?
My current company started using AWS Database Migration Service upon my recommendation, and I continue telling people how good of a product it is. However, users should keep in mind a few things. ...
Is AWS Database Migration Service an affordable solution?
Compared to similar solutions, AWS Database Migration Service falls somewhere in the middle price-wise, at least from my experience. This being said, it is not a very affordable solution, especial...
Which ETL tool would you recommend to populate data from OLTP to OLAP?
There are two products I know about * TimeXtender : Microsoft based, Transformation logic is quiet good and can easily be extended with T-SQL , Has a semantic layer that generates metat data for cu...
What do you like most about Qlik Compose?
The most valuable is its excellence as a graphical data representation tool and the versatility it offers, especially with drill-down capabilities.
What is your experience regarding pricing and costs for Qlik Compose?
While they outperform Tableau, there's room for improvement in Qlik's pricing structures, especially for corporate clients like us.
 

Also Known As

AWS Data Migration Service
Compose, Attunity Compose
 

Overview

 

Sample Customers

Veoci, Trimble, Nasdaq, shaadi.com, Hotelbeds, SysAid, Verizon, Expedia, Pega
Poly-Wood
Find out what your peers are saying about AWS Database Migration Service vs. Qlik Compose and other solutions. Updated: October 2024.
814,649 professionals have used our research since 2012.