We performed a comparison between Qlik Compose and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It is a scalable solution."
"It can scale."
"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."
"I have found it to be a very good, stable, and strong product."
"One of the most valuable features was the ability to integrate multiple source systems that mainly used structured IDBMS versions."
"Qlik Compose is good enough. It is user-friendly and intuitive."
"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 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."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"It has good data integration and good processes."
"It's saved time using visualization descriptions."
"Overall, it's a good product."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"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'd like to have access to more developer training materials."
"Qlik's ETL and data transformation could be better."
"I believe that visual data flow management and the transformation function should be improved."
"There should be proper documentation available for the implementation process."
"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."
"The solution has room for improvement in the ETL. They have an ETL, but when it comes to the monitoring portion, Qlik Compose doesn't provide a feature for monitoring."
"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."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"Improvement as per customer requirements."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"It hangs a lot of the time."
"We have issues with SSIS connectors while extracting data from Excel sources."
Qlik Compose is ranked 20th in Data Integration with 12 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Qlik Compose is rated 7.6, while SSIS is rated 7.6. The top reviewer of Qlik Compose writes "Easy matching and reconciliation of data". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Qlik Compose is most compared with Qlik Replicate, Talend Open Studio, Oracle Data Integrator (ODI), Azure Data Factory and Palantir Foundry, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our Qlik Compose vs. SSIS report.
See our list of best Data Integration vendors.
We monitor all 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.
