What users are saying about

Alteryx Analytics

Top Rated
111 Ratings

SSIS

155 Ratings

Alteryx Analytics

Top Rated
111 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101

SSIS

155 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.9 out of 101

Add comparison

Likelihood to Recommend

Alteryx Analytics

More often than not, Alteryx can handle any situation or scenario thrown at it. Some may take a little more "trickery" along the way, but for the most part it is fairly easy to get from point A (data) to point B (results/report). And the nice thing is is that there is more than one way to produce the same result - two people with two different mindsets can ultimately create the same thing, but do so in a way that is better suited for their skill level.
Cameron Tubbs profile photo

SSIS

Well suited:
  1. Full refresh loading files (Excel and Flat File) into SQL Server.
  2. Integrating .Net (VB/C#) scripting
Less suited:
  1. Incremental loading
  2. OLAP database loading
Not suited:
  1. Streaming, real-time/near real-time loading
  2. Big data loading
David Milillo profile photo

Feature Rating Comparison

BI Standard Reporting

Alteryx Analytics
7.6
SSIS
Pixel Perfect reports
Alteryx Analytics
8.0
SSIS
Customizable dashboards
Alteryx Analytics
5.8
SSIS
Report Formatting Templates
Alteryx Analytics
9.0
SSIS

Ad-hoc Reporting

Alteryx Analytics
8.5
SSIS
Drill-down analysis
Alteryx Analytics
8.1
SSIS
Formatting capabilities
Alteryx Analytics
8.2
SSIS
Integration with R or other statistical packages
Alteryx Analytics
9.6
SSIS
Report sharing and collaboration
Alteryx Analytics
7.9
SSIS

Report Output and Scheduling

Alteryx Analytics
8.6
SSIS
Publish to Web
Alteryx Analytics
8.0
SSIS
Publish to PDF
Alteryx Analytics
8.6
SSIS
Report Versioning
Alteryx Analytics
9.0
SSIS
Report Delivery Scheduling
Alteryx Analytics
8.9
SSIS

Data Discovery and Visualization

Alteryx Analytics
8.1
SSIS
Pre-built visualization formats (heatmaps, scatter plots etc.)
Alteryx Analytics
8.0
SSIS
Location Analytics / Geographic Visualization
Alteryx Analytics
7.7
SSIS
Predictive Analytics
Alteryx Analytics
8.7
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.2
Connect to traditional data sources
Alteryx Analytics
SSIS
9.1
Connecto to Big Data and NoSQL
Alteryx Analytics
SSIS
7.3

Data Transformations

Alteryx Analytics
SSIS
8.8
Simple transformations
Alteryx Analytics
SSIS
9.4
Complex transformations
Alteryx Analytics
SSIS
8.1

Data Modeling

Alteryx Analytics
SSIS
7.4
Data model creation
Alteryx Analytics
SSIS
7.1
Metadata management
Alteryx Analytics
SSIS
6.6
Business rules and workflow
Alteryx Analytics
SSIS
8.4
Collaboration
Alteryx Analytics
SSIS
6.9
Testing and debugging
Alteryx Analytics
SSIS
7.8

Data Governance

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

Pros

  • Cleaning datasets
  • Preparing data for analyzing
  • Customer data analytics
  • Transforming data from one format to other
Sanket Bharaswadkar profile photo
  • Handling upsert functionality (i.e. performing lookups against existing data to determine new versus existing records).
  • Automation of scheduled file imports. Essentially any consistent data source can be automated after a one-time SSIS package is set up.
  • Ability to handle a wide variety of data sources.
No photo available

Cons

  • Poor documentation
  • Costly
  • Overkill for simple tasks
  • Not many options for data visualization
Sanket Bharaswadkar profile photo
  • version control/configuration management
  • Programmatic issues like NULL handling (it's RDBMS counterpart SQL Server database uses NULL differently)
  • The source connectivity options should be enhanced
No photo available

Likelihood to Renew

Alteryx Analytics6.5
Based on 14 answers
The product fulfills business needs and it is a pleasure to work with the provider.
Nick Lensing profile photo
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
SSIS8.0
Based on 2 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

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
They are generally responsive and knowledgeable too
No photo available

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

Breadth of Deployment

Our company kept it contained in the marketing department. Other departments may not understand it.
No photo available
No answers on this topic

Alternatives Considered

Talend is primarily for data integration and has quite advanced capabilities. But the user has to be more technical. Alteryx makes the process simple and any user can make use of its features.Tableau was a good choice for data visualization. We needed beautiful charts and ways to represent data. Alteryx falls short in this aspect.
Sanket Bharaswadkar profile photo
SSIS is compatible with windows and easy to use.Installation cost and maintenance cost is less.
Shrikanth Mahale profile photo

Collaboration and Sharing

Alteryx Analytics7.2
Based on 16 answers
Doesn't really allow for much collaboration in real time other than sharing flat files with coworkers. Have to utilize a 3rd party cloud hosting platform in order to try to collaborate on a workflow.
No photo available
No score
No answers yet
No answers on this topic

Data Integration

Alteryx Analytics8.9
Based on 16 answers
Good integration with a wide variety of data sources, its ease of use in connecting to databases is much to be desired though.
No photo available
No score
No answers yet
No answers on this topic

Return on Investment

  • Faster data processes (appending various data)
  • Non-gis people have been able to to geocode/build trade areas (this is positive and negative)
  • Quickly generate a standardized way of research processes
No photo available
  • Faster implementations
  • Integrated reporting environments
  • Cost savings via automation
Samir Patel, PMP profile photo

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