

SSIS and Alteryx are leading competitors in the data integration tools category. Alteryx appears to have the upper hand due to its strong emphasis on automation and ease of use, appealing to non-technical users.
Features: SSIS is well-known for its compatibility with the Microsoft BI stack, parallel processing capabilities, and robust scripting options that enable high customization with C# and SQL. It effectively integrates with existing Microsoft environments, offering stability and scalability. Alteryx provides a user-friendly drag-and-drop interface with robust analytics and workflow automation features, ideal for non-coders. Its ability to handle a wide variety of data sources efficiently makes it attractive to users prioritizing fast data processing.
Room for Improvement: SSIS could improve its UI responsiveness and scalability under high data volumes, while enhancing debugging and API integration. Creating custom components remains complex, and support for non-Microsoft databases is limited. Alteryx is often critiqued for its high cost and complexity in handling large datasets. It also requires enhancement in advanced data science tools and cloud deployment options, alongside needing better documentation.
Ease of Deployment and Customer Service: SSIS is deeply integrated with on-premises Microsoft ecosystems but faces challenges due to Microsoft's focus shift to cloud solutions. Alteryx offers flexibility in deployment models, including cloud and hybrid options, and provides robust customer support, though scalability challenges exist as their user base grows.
Pricing and ROI: SSIS is cost-effective for organizations already using Microsoft products, as it often comes bundled with SQL Server, eliminating additional costs. Alteryx is perceived as costly, especially in terms of scalability and collaboration, yet offers significant ROI through automation, making it valuable for larger enterprises while being restrictive for smaller entities due to high licensing fees.
Tasks that earlier took hours in Excel or SQL are now completed in minutes.
From a time-saving perspective, we saved 60 to 75 percent of the human workforce needed and eliminated other disparate ETL tools, ultimately saving us over 600,000 dollars.
Alteryx helps familiarize managers with artificial intelligence-driven possibilities.
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.
Customer support from Alteryx has been amazing.
they do have a website for resolving doubts and accessing helpful resources, including various tools and filters.
I contacted customer support once or twice, and they were quick to respond.
The first line of support needs to be more knowledgeable.
Alteryx is scalable for most enterprise analytics and data preparation workloads.
Suggestions for improvements in Alteryx include areas for increasing efficiency, particularly in processing telemetry data, which involves dealing with large volumes of unstructured data.
Alteryx is scalable, and I would give it eight out of ten.
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.
I didn't need to reach out to Alteryx for support because available documents usually provide enough information to resolve issues.
I have not encountered any lagging, crashing, or instability in the system during these three months of usage.
Alteryx is a reliable tool, but it is also very heavy, requiring good laptop configurations, a minimum of 8GB RAM, and a recent processor such as i10.
It processes large volumes of data quickly.
The tool could include more native connectors, such as for global ERPs, instead of requiring additional fees for these connections.
The support structure changed; initially, we received great support, however, it later became less reliable due to licensing issues and a tiered support system.
The additional features that Alteryx needs to work on to make it more competitive include better collaboration and easier integration through API.
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.
The price is very high, with licensing typically starting around five thousand dollars plus user per year.
We found excellent use cases for automation through Alteryx, which provided the means to reduce operational costs and streamline the build of ETL pipelines without extensive coding.
Alteryx is more cost-effective compared to Informatica licenses, offering savings.
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.
Alteryx not only represents data but also supports decision-making by suggesting the next steps.
Analysts who do not have any coding experience can still work on the transformation and preparation of data, which is quite useful.
Alteryx includes built-in tools such as drive time analysis and linear regression, which are much harder to achieve in standard BI tools such as Power BI or Tableau.
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 | Mindshare (%) |
|---|---|
| SSIS | 4.0% |
| Alteryx | 1.2% |
| Other | 94.8% |

| Company Size | Count |
|---|---|
| Small Business | 46 |
| Midsize Enterprise | 20 |
| Large Enterprise | 73 |
| Company Size | Count |
|---|---|
| Small Business | 27 |
| Midsize Enterprise | 19 |
| Large Enterprise | 58 |
Alteryx enhances efficiency by automating data preparation and transformation through a user-friendly drag-and-drop interface, catering to non-technical users and business professionals. It supports data blending, predictive analytics, and diverse data integration capabilities.
Alteryx streamlines data manipulation and complex transformations, benefiting industries such as finance and marketing with its ability to connect to multiple data sources and automate workflows. The platform supports analytics and machine learning model building, reducing manual efforts in ETL processes. Despite its capabilities, improvements are needed in database connectivity, pricing flexibility, and cloud service integration. Users desire enhancements in reporting features, visualization, and technical support to optimize its full potential. Machine learning and predictive analytics features require advancements to improve user experience and broaden accessibility through better connectors and reduced licensing costs.
What are Alteryx's key features?
What benefits and ROI should be looked for in reviews?
In finance and marketing, organizations leverage Alteryx to automate data tasks, connect diverse sources, and generate analytics models and dashboards efficiently. Its no-code approach aids in rapid data preparation, cleansing, and analysis, empowering business users to engage in predictive and prescriptive analytics effectively.
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.