Find out what your peers are saying about Microsoft, Informatica, Talend and others in Data Integration.
SnapLogic is really helpful and processes in very little time, so it doesn't take much time compared to any legacy tool.
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.
Communication with the vendor is challenging
Some SMEs are allotted for the organization, so in case of any issue, we have their email IDs to contact them for support, including SMEs and community.
The technical support from SnapLogic is excellent, and I would give it a complete ten.
The first line of support needs to be more knowledgeable.
Pentaho Data Integration handles larger datasets better.
I rate the scalability of SnapLogic as eight out of ten.
It's pretty stable, however, it struggles when dealing with smaller amounts of data.
But recently, in a year, I haven't found many performance issues in SnapLogic.
I would rate the stability of SnapLogic as nearly ten out of ten.
It processes large volumes of data quickly.
Pentaho Data Integration is very friendly, it is not very useful when there isn't a lot of data to handle.
If the AI capabilities and integrations were more intuitive and easy to learn for new users, it would be greatly beneficial.
They can improve more visuals, with graphical representations, such as how many things can be added, how many users can be added or dropped, and how the back-end nodes can be graphically shown in a better way.
I tend to frequently communicate with SnapLogic to ask for additional features, and they have been responsive.
Within the South African context, if you are getting your enterprise agreement from First Technology, they don't provide support.
The logging capabilities could be improved, particularly for error logging.
SSIS has a difficult learning curve when dealing with complex transformations.
There would be only one point of improvement if the price could be lower.
SnapLogic is positioned at around seven or eight out of ten in terms of pricing.
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.
It's easy to use and friendly, especially for larger data sets.
I also like the whole child-parent pipeline feature; it allows me to break up a process into smaller pieces and then have one big pipeline that controls these smaller pipelines.
I find SnapLogic to be user-friendly, especially for beginners with limited experience in data engineering or ETL.
It's moving into AI, so we can create AI agents with LLM models. We can use most of the LLM such as Amazon Bedrock, OpenAI, Azure AI.
It is a very robust tool that can work with many data sources, and its main strength is that it is extremely easy to use.
We end up with people not understanding that you need to build your models correctly, and then they try to model everything inside of Power BI, or another visualization tool, without first building the data model.
One of the best aspects of SSIS is that it is built into Microsoft SQL Server, so there are no additional costs involved.
| Product | Market Share (%) |
|---|---|
| SSIS | 5.9% |
| Pentaho Data Integration and Analytics | 1.7% |
| SnapLogic | 1.2% |
| Other | 91.2% |
| Company Size | Count |
|---|---|
| Small Business | 17 |
| Midsize Enterprise | 16 |
| Large Enterprise | 25 |
| Company Size | Count |
|---|---|
| Small Business | 11 |
| Midsize Enterprise | 5 |
| Large Enterprise | 10 |
| Company Size | Count |
|---|---|
| Small Business | 26 |
| Midsize Enterprise | 19 |
| Large Enterprise | 57 |
Pentaho Data Integration stands as a versatile platform designed to cater to the data integration and analytics needs of organizations, regardless of their size. This powerful solution is the go-to choice for businesses seeking to seamlessly integrate data from diverse sources, including databases, files, and applications. Pentaho Data Integration facilitates the essential tasks of cleaning and transforming data, ensuring it's primed for meaningful analysis. With a wide array of tools for data mining, machine learning, and statistical analysis, Pentaho Data Integration empowers organizations to glean valuable insights from their data. What sets Pentaho Data Integration apart is its maturity and a vibrant community of users and developers, making it a reliable and cost-effective option. Pentaho Data Integration offers a range of features, including a comprehensive ETL toolkit, data cleaning and transformation capabilities, robust data analysis tools, and seamless deployment options for data integration and analytics solutions, making it a go-to solution for organizations seeking to harness the power of their data.
The SnapLogic Intelligent Integration Platform uses AI-powered workflows to automate all stages of IT integration projects – design, development, deployment, and maintenance – whether on-premises, in the cloud, or in hybrid environments. The platform’s easy-to-use, self-service interface enables both expert and citizen integrators to manage all application integration, data integration, API management, B2B integration, and data engineering projects on a single, scalable platform. With SnapLogic, organizations can connect all of their enterprise systems quickly and easily to automate business processes, accelerate analytics, and drive transformation.
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.
