What users are saying about
Top Rated
121 Ratings
159 Ratings
Top Rated
121 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.6 out of 101
159 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.8 out of 101

Add comparison

Likelihood to Recommend

Alteryx Analytics

Well suited: if an organization already has a lot of running ETLs or pipelines but need to systemize them, Alteryx is a good choice. It would be good to figure out how well Alteryx would be harmonized with the existing components, but in a general sense, it may be well harmonized. Less appropriate: Alteryx is good for "automation", but some data developers and analysts may prefer to remain and keep using SQL tools. One should be careful of not just adding "one more layer or tool" into the existing pipeline and make it more complicated to manage.
No photo available

SSIS

Microsoft SQL Server Integration Services is suited for development by those who are NOT very experienced developers. End-users with some database experience may find the development environment easy to use allowing development of basic ETL. Experienced developers will likely feel restricted by the "Microsoft-only" interface. Additionally, many larger organizations that have made a significant investment in databases other than SQL Servers will be unable to use SSIS against those database servers.
No photo available

Feature Rating Comparison

BI Standard Reporting

Alteryx Analytics
7.9
SSIS
Pixel Perfect reports
Alteryx Analytics
8.0
SSIS
Customizable dashboards
Alteryx Analytics
6.8
SSIS
Report Formatting Templates
Alteryx Analytics
9.0
SSIS

Ad-hoc Reporting

Alteryx Analytics
8.5
SSIS
Drill-down analysis
Alteryx Analytics
8.3
SSIS
Formatting capabilities
Alteryx Analytics
8.2
SSIS
Integration with R or other statistical packages
Alteryx Analytics
9.5
SSIS
Report sharing and collaboration
Alteryx Analytics
8.0
SSIS

Report Output and Scheduling

Alteryx Analytics
8.7
SSIS
Publish to Web
Alteryx Analytics
8.2
SSIS
Publish to PDF
Alteryx Analytics
8.5
SSIS
Report Versioning
Alteryx Analytics
9.0
SSIS
Report Delivery Scheduling
Alteryx Analytics
8.9
SSIS

Data Discovery and Visualization

Alteryx Analytics
7.9
SSIS
Pre-built visualization formats (heatmaps, scatter plots etc.)
Alteryx Analytics
8.0
SSIS
Location Analytics / Geographic Visualization
Alteryx Analytics
7.4
SSIS
Predictive Analytics
Alteryx Analytics
8.2
SSIS

Access Control and Security

Alteryx Analytics
8.3
SSIS
Multi-User Support (named login)
Alteryx Analytics
8.0
SSIS
Role-Based Security Model
Alteryx Analytics
8.0
SSIS
Multiple Access Permission Levels (Create, Read, Delete)
Alteryx Analytics
9.0
SSIS

Mobile Capabilities

Alteryx Analytics
4.0
SSIS
Responsive Design for Web Access
Alteryx Analytics
4.0
SSIS

Data Source Connection

Alteryx Analytics
SSIS
8.0
Connect to traditional data sources
Alteryx Analytics
SSIS
9.1
Connecto to Big Data and NoSQL
Alteryx Analytics
SSIS
6.8

Data Transformations

Alteryx Analytics
SSIS
8.7
Simple transformations
Alteryx Analytics
SSIS
9.6
Complex transformations
Alteryx Analytics
SSIS
7.9

Data Modeling

Alteryx Analytics
SSIS
7.2
Data model creation
Alteryx Analytics
SSIS
7.5
Metadata management
Alteryx Analytics
SSIS
6.8
Business rules and workflow
Alteryx Analytics
SSIS
8.4
Collaboration
Alteryx Analytics
SSIS
6.0
Testing and debugging
Alteryx Analytics
SSIS
7.3

Data Governance

Alteryx Analytics
SSIS
7.6
Integration with data quality tools
Alteryx Analytics
SSIS
7.7
Integration with MDM tools
Alteryx Analytics
SSIS
7.4

Pros

  • Alteryx handles metadata really well. The tools are intuitive in their use.
  • For analytics Alteryx it is a great platform.
  • There are barely any software bugs in the product.
  • The error messages are actually helpful to debug modules.
  • If a load-balancing application is internally developed on top of Alteryx processing nationwide universes can be really fast.
Nick Lensing profile photo
  • There are many good workflow tools and ways to control the order in which things happen. In a short amount of time, you can quickly create a package that will move data from point A to point B and have it scheduled to run 4 times a day. Or if you need error handling or other business logic, you can spend more time and completely automate repetitive tasks. Robust? Check!
  • SSIS can consume multiple sources of data. From flat files, to Excel, to Oracle, or DB2...I've been able to access multiple data types and move them in and out of SQL databases with SSIS. We had one linux system that ran a Basis database system and there was a need to have something done, but no one could figure out how to make it work. I was able to use SSIS to import files and execute code on a server that had nothing to do with SQL server. So flexible? Check!
  • We already use SQL server almost exclusively for our enterprise database needs. The fact that we already have access to this tool at no additional cost to the business is a bonus. The fact that it is powerful, even better. Value? Check!
Greg Goss profile photo

Cons

  • Faster speed of query
  • More complex join capability. Some more experienced users would like to make more complex joins after the data is in process map rather than a complete preparation before including in process map
  • Connection with Power BI, Tableu, or other graphical data tools would make more seamless intelligence
Spencer Lewis profile photo
  • The one issue that I have with SSIS is that sometimes the business logic gets baked into the SSIS package. This can make it harder to debug. In some cases this makes sense if the source and destination is not a database. However, when using a database as a source I prefer to manipulate and transform the data via sql and then simply expose the dataset to SSIS after the data has been prepared. I find it easier to write and debug sql directly rather than working in SSIS. However, in cases when a database is not involved then putting the business logic in SSIS makes sense.
Eddie Brady profile photo

Likelihood to Renew

Alteryx Analytics6.5
Based on 14 answers
I would love to renew, but Alteryx is not available for Mac computers.
No photo available
SSIS6.0
Based on 2 answers
A bit outdated compared to competitors, esp in the open source community
No photo available

Usability

Alteryx Analytics10.0
Based on 2 answers
Through a graphical UI one can perform engineering and development, other vendors do not have such a code-less interface.
Nick Lensing profile photo
SSIS7.0
Based on 3 answers
Easy to use, however there are functionality limits
No photo available

Reliability and Availability

Alteryx Analytics10.0
Based on 1 answer
I use many programs and compared to others, Alteryx virtually never goes down, freezes up or gives an application error. Over a 4 year time period that I have used this program, any of these may have happened 3 times. It is an incredibly stable program that I feel completely confident in.
Dan Chapman profile photo
No score
No answers yet
No answers on this topic

Performance

No score
No answers yet
No answers on this topic
SSIS6.0
Based on 1 answer
SQL Server Integration Services performance is dependent directly upon the resources provided to the system. In our environment, we allocated 6 nodes of 4 CPUs, 64GB each, running in parallel. Unfortunately, we had to ramp-up to such a robust environment to get the performance to where we needed it. Most of the reports are completed in a reasonable timeframe. However, in the case of slow running reports, it is often difficult if not impossible to cancel the report without killing the report instance or stopping the service.
No photo available

Support

Alteryx Analytics9.9
Based on 2 answers
Overall pretty good. Depending on the quality of the question posed the CS team will get back as they are available
Nick Lensing profile photo
SSIS9.0
Based on 3 answers
The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.
Chris Morgan profile photo

Implementation

Alteryx Analytics10.0
Based on 1 answer
There is really not much to it (the installation, that is). Once you get it installed, along with any of the add-ons (demographics, R, etc.), you are up and running almost immediately. There is really no additional setup. You can immediately begin blending data, running demographics, performing spatial queries, running predictive analysis, etc. And for many of these functions, the learning curve is quite easy.
Dan Chapman profile photo
SSIS10.0
Based on 1 answer
The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools
Luca Campanelli profile photo

Alternatives Considered

  • Alteryx is your own pocket BI tool, that means it's easy to implement and easy to learn
  • You can avoid several trips to your IT department if you start using Alteryx
  • Alteryx is a time-tested application and has a big community of users to support your queries
  • Alteryx connects to most big data platforms
No photo available
If you are in a SQL Server environment, I really don't know why you wouldn't use SSIS since it is free with SQL Server and I don't know of any standalone tool that can match it. Redgate makes some great addon tools for SQL server that integrate with it to make it more powerful, versatile and easy to use.
Chris Morgan profile photo

Return on Investment

  • It gets the job done fast.
  • It lends itself well for people with a less-technical aptitude to understand the data process.
  • It empower the user to come up with any possible solution to a problem.
Nick Lensing profile photo
  • Saves us a considerable amount of time required to import our data.
  • Streamlines the order import/processing process for our business and makes it easier for us to meet our target ship dates as we have no bottlenecks during the import flow.
No photo available

Pricing Details

Alteryx Analytics

General
Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
No
Alteryx Analytics Editions & Modules
Alteryx Analytics
On-premise Edition
Alteryx Designer
$3,9951
Alteryx Designer with Spatial
$12,9951
Alteryx Designer with Data
$29,9951
Alteryx Server
$45,0002
1. per user, per year
2. per server, per year
SaaS Edition
Alteryx Analytics Gallery
$1,5001
1. per user, per year
Additional Pricing Details
The above prices are in USD for Alteryx products and are per-year subscription prices based on a 3-year contract, with annual payment.

SSIS

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
SSIS Editions & Modules
SSIS
Additional Pricing Details