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."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."
"It is a scalable solution."
"Qlik Compose is good enough. It is user-friendly and intuitive."
"One of the most valuable features was the ability to integrate multiple source systems that mainly used structured IDBMS versions."
"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."
"It's a stable solution."
"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 can scale."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"SSIS' best feature is SFTP connectivity."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"The UI is very user-friendly."
"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."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"I'd like to have access to more developer training materials."
"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."
"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."
"I believe that visual data flow management and the transformation function should be improved."
"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."
"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."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"The high prices attached to the product can be an area of concern where improvements are required."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"The solution could improve by having quicker release updates."
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, Azure Data Factory, Palantir Foundry and Oracle Data Integrator (ODI), 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.