Sep 09, 2021
We have experiences only in Pentaho Data Integrator (open source competitor of the Oracle Data Integrator).
But OLAP exporting wasn't in our scope until now.
In the ETL and data integration space, SSIS and Qlik Talend Cloud are notable competitors. SSIS offers strong integration within the Microsoft ecosystem, while Qlik Talend Cloud surpasses in flexibility and comprehensive integration capabilities, making it a preferred choice for diverse data environments.
Features: SSIS provides robust ETL functionalities with parallel processing, easy data transfer, and minimal complexity, enhancing user efficiency with its Microsoft BI stack integration. This tool simplifies tasks like email notifications and custom coding through its Script task feature. In comparison, Qlik Talend Cloud excels in scalability and integration across databases, APIs, and cloud platforms. It supports extensive customization via Java integration, offering a flexible development environment.
Room for Improvement: SSIS could enhance error logging and connectivity with non-Microsoft databases such as SAP. It also requires better version control and real-time data processing support. Conversely, Qlik Talend Cloud could improve advanced monitoring, debugging, and cost transparency, while also integrating development tools directly onto the browser for easier access.
Ease of Deployment and Customer Service: SSIS and Qlik Talend Cloud provide multiple deployment options, supporting both on-premises and cloud solutions. Users highlight Qlik Talend Cloud for its modern infrastructure and scalability. However, SSIS faces criticism for declining Microsoft support quality, whereas Qlik Talend Cloud users are generally satisfied but suggest enhancing service delivery and documentation access.
Pricing and ROI: SSIS is cost-effective, bundled with SQL Server licenses, offering a significant return on investment without additional database fees. In contrast, Qlik Talend Cloud’s features come at a higher price, partly due to its acquisition by Qlik. Its flexible subscription model presents budgetary concerns for cost-conscious organizations.
It has helped us save a lot of time by automating repetitive data processes and reducing manual interventions.
We achieved around 20% to 30% time savings in the ETL process, reduced operational errors, and improved pipeline stability.
We actually achieved the first 18 months worth of work in the first six months.
The tool has made us tremendously more efficient and saved us a significant amount of money.
Using SSIS has proven cost-effective as there are no additional fees outside the SQL Server license, and it significantly enhances data management efficiency.
The support team is responsive when we raise issues, and they usually provide clear guidance or solutions.
I would rate the technical support from Talend Data Quality as an 8 or 9.
The customer support for Talend Data Integration is very good; whenever I raise a ticket in the customer portal, I immediately receive an email, and follow-up communication is prompt.
The first line of support needs to be more knowledgeable.
By using features like job parallelization and modular design, we can expand our data flows without having to rebuild everything.
Its scalability is good, as Qlik Talend Cloud can handle large amounts of data and grow as needed, especially in cloud environments.
The scalability of Talend Data Integration is good; if it weren't scalable, it wouldn't be reliable.
I would rate the scalability of SSIS at a 7 because we are able to use various third-party items with it, allowing for functionality with a number of different things.
We have not encountered many issues with remote engines, and the interfaces are properly developed.
Once the jobs are properly designed and deployed, they run reliably without major issues.
It was not as stable when we were using TAC and on-premise systems, but currently, with Qlik Talend Cloud version 8.3 or 8.1, it is stable.
It processes large volumes of data quickly.
On the flip side, that is one of its amazing strengths, as you are not locked into a very rigid way of doing something.
Better cost and resource visibility would help teams optimize their workloads.
It would be great to have more ready-to-use connectors for modern cloud and SaaS platforms.
Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.
SSIS has a difficult learning curve when dealing with complex transformations.
The logging capabilities could be improved, particularly for error logging.
My experience with Talend Data Integration's pricing, setup cost, and licensing is that it is a bit higher compared to other tools, making it not very affordable.
The license cost has increased significantly, leading many companies to seek more profitable options in the market.
Utilizing SSIS involves no extra charges beyond the SQL Server license.
It was included in our licensing for SQL server, and our licensing for SQL server was extremely cheap, making it a very good price point for us.
However, it could be a bit cheaper.
By automating daily data loading processes, we reduced manual effort by around three or four hours per day, which saved roughly 60 to 80 hours per month.
We perform profiling prior to data quality and post-data quality, and based on that, we determine how much it has improved to measure the efficiency of Talend Data Quality cleaning tools.
The feature that has made the biggest difference for me in Qlik Talend Cloud is the scheduling and automation, which helps me run ETL jobs automatically without manual work.
I would rate it at a 10 as it is highly reliable; we have never had any problems with it.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
SSAS is included in the base installation of SQL Server.
| Product | Market Share (%) |
|---|---|
| SSIS | 3.7% |
| Qlik Talend Cloud | 2.2% |
| Other | 94.1% |
| Company Size | Count |
|---|---|
| Small Business | 20 |
| Midsize Enterprise | 11 |
| Large Enterprise | 20 |
| Company Size | Count |
|---|---|
| Small Business | 27 |
| Midsize Enterprise | 19 |
| Large Enterprise | 57 |
Qlik Talend Cloud provides robust data integration tools tailored for efficient management of large volumes, offering real-time data access, Java integration, and custom code capabilities for developers.
Qlik Talend Cloud is known for its extensive connectivity options, enabling seamless integration across different platforms, such as S3, Redshift, Oracle, and SQL Server. The central repository facilitates consistent metadata access throughout organizations, enhancing collaboration. Despite its strengths in advanced monitoring, automation, and user-friendly drag-and-drop interfaces, users face challenges with installation stability, technical support, documentation inconsistencies, and complexities in learning. Performance concerns also include multitasking limitations and excessive memory usage. The platform's licensing costs can be prohibitive for smaller companies, while demands for improved data governance and intuitive code management continue. Its applications in healthcare data parsing, ETL task automation, and diverse data platform integration demonstrate its utility, although there's a constant demand for better scalability and efficient transformations.
What are the key features?In specialized industries like healthcare, users leverage Qlik Talend Cloud for data integration and transformation, aiding in compliance and analytics. Compatibility with cloud and on-premises systems ensures adaptability to complex data tasks, facilitating business application development. Organizations focus on enhanced data ingestion and quality checks for comprehensive solutions.
SSIS is a versatile tool for data integration tasks like ETL processes, data migration, and real-time data processing. Users appreciate its ease of use, data transformation tools, scheduling capabilities, and extensive connectivity options. It enhances productivity and efficiency within organizations by streamlining data-related processes and improving data quality and consistency.
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.
