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
Reviews Sentiment
6.4
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
Straightforward to set up with easy of capturing database changes and secure storage
Sometimes we encounter errors, and the error messages from DMS are very ambiguous and sometimes misleading. For example, if we connect to an incorrect instance with incorrect setups, it will not say the connection failed. Instead, it says the DMS task failed with an unclear error message like 'subtask AWS failed', which does not help. The connection should fail if we are connecting to the wrong instance, but the endpoint connection still succeeds.
Sahil Taneja - PeerSpot reviewer
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

"Scalable and stable solution for migrating databases to AWS, with valuable features such as parallel full load and continuous data replication."
"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."
"We particularly like that this solution has the facility to integrate with all ETL tools."
"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."
"The most valuable features of the AWS Database Migration Service are the ease of migration, beneficial storage system, security, and simple instance creation. Additionally, the cloud that is provided is more complete than other solutions."
"The initial setup is very straightforward."
"The solution is instantaneous. We can launch the service and reduce the end number of manpower."
"DMS's architecture is highly beneficial, allowing for scalable migrations of large datasets."
"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."
"It's a stable solution."
"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 technical support is very good. I rate the technical support a ten out of ten."
"I like modeling and code generation. It has become a pretty handy tool because of its short ideation to delivery time. From the time you decide you are modeling a data warehouse, and once you finish the modeling, it generates all the code, generates all the tables. All you have to do is tick a few things, and you can produce a fully functional warehouse. I also like that they have added all the features I have asked for over four years."
"One of the most valuable features was the ability to integrate multiple source systems that mainly used structured IDBMS versions."
"It is a scalable solution."
"Qlik Compose is good enough. It is user-friendly and intuitive."
 

Cons

"The cost is a concern. We use DMS because of its simplicity, but the price could definitely be more competitive."
"The initial setup can be difficult for beginners in AWS Database Migration Service. You will need the training to complete it."
"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."
"The performance of data migration could be smoother."
"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."
"There are a set of complexities and challenges when a user wants to integrate AWS products with Microsoft products."
"Database Migration Service could be more integrated. I think that it makes sense to add integration to these functions. For example, AWS Glue has a feature called Orchestrator to create data flows, and that's more straightforward."
"The solution’s scalability and performance could be improved."
"Qlik's ETL and data transformation could be better."
"There should be proper documentation available for the implementation process."
"There is some scope for improvement around the documentation, and a better UI would definitely help."
"I'd like to have access to more developer training materials."
"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."
"I believe that visual data flow management and the transformation function should be improved."
"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."
"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."
 

Pricing and Cost Advice

"I rate the product price a seven on a scale of one to ten, where one is a high price, and ten is a low price."
"AWS Database Migration Service is very inexpensive."
"The pricing is on the higher side."
"For Egypt, the product's prices are high, making it a specific problem in one region and not globally."
"The solution’s pricing is reasonable."
"Pricing can be improved."
"Pricing for the solution is reasonable, but could still be reduced."
"Cost is the only factor that is challenging."
"On a scale of one to ten, where one is cheap, and ten is very expensive, I rate the solution a six."
"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."
report
Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

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

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.
816,406 professionals have used our research since 2012.