What users are saying about
159 Ratings
8 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 6.7 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

Advanced Web Ranking

My business works with clients from a variety of outlets, with budgets ranging from six figures down to triple digits (not kidding). There's a TON of analytical software out there, so speaking as a guy who has worked with them all (or at least quite a few) if your client is on a budget – particularly a startup – AWR is a great program to use. They've been around for a while, the desktop version is pretty bug-free and updates in real-time, and it's budget conscious.
No photo available

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

SEO

Advanced Web Ranking
6.5
SSIS
Keyword analysis
Advanced Web Ranking
5.0
SSIS
Backlink management
Advanced Web Ranking
7.0
SSIS
SERP ranking tracking
Advanced Web Ranking
7.5
SSIS
Page grader
Advanced Web Ranking
7.0
SSIS
Competitive analysis
Advanced Web Ranking
6.5
SSIS
Site audit / diagnostics
Advanced Web Ranking
7.0
SSIS
Site recommendations
Advanced Web Ranking
6.0
SSIS
Task management
Advanced Web Ranking
6.0
SSIS

SEO Channels

Advanced Web Ranking
7.0
SSIS
Local SEO
Advanced Web Ranking
7.0
SSIS
Social SEO
Advanced Web Ranking
6.5
SSIS
Mobile SEO
Advanced Web Ranking
8.0
SSIS
Global SEO
Advanced Web Ranking
6.5
SSIS

SEO Platform & Account Management

Advanced Web Ranking
7.7
SSIS
Multi-domain support
Advanced Web Ranking
8.0
SSIS
Integration with web analytics tools
Advanced Web Ranking
7.5
SSIS

Data Source Connection

Advanced Web Ranking
SSIS
8.0
Connect to traditional data sources
Advanced Web Ranking
SSIS
9.1
Connecto to Big Data and NoSQL
Advanced Web Ranking
SSIS
6.8

Data Transformations

Advanced Web Ranking
SSIS
8.7
Simple transformations
Advanced Web Ranking
SSIS
9.6
Complex transformations
Advanced Web Ranking
SSIS
7.9

Data Modeling

Advanced Web Ranking
SSIS
7.2
Data model creation
Advanced Web Ranking
SSIS
7.5
Metadata management
Advanced Web Ranking
SSIS
6.8
Business rules and workflow
Advanced Web Ranking
SSIS
8.4
Collaboration
Advanced Web Ranking
SSIS
6.0
Testing and debugging
Advanced Web Ranking
SSIS
7.3

Data Governance

Advanced Web Ranking
SSIS
7.6
Integration with data quality tools
Advanced Web Ranking
SSIS
7.7
Integration with MDM tools
Advanced Web Ranking
SSIS
7.4

Pros

  • It only costs $49/month, which is great for clients that are working with limited budgets (they're cost-conscious!)
  • Its ease of use – I've worked with plenty of cloud-based rank tracking programs before, and AWR was by far one of the cleanest and easiest to navigate. I could use it on my iPad and the user-touch interface was pretty seamless.
  • The info is updated in real-time. We were able to show our clients their live data while in meetings. It made us look good, and it made our clients feel better about the service they were paying for.
No photo available
  • Native data connections to SQL Server and Azure SQL DB and DW
  • Flat file processing
  • .NET C#/VB scripting
  • Ease of use in designing and implementing control flows within conditional processing and looping
David Milillo profile photo

Cons

  • The ability of the program to produce dashboards in web page format. While it can do this, it saves them out as HTML files on your hard drive or cloud server, which makes it super hard to share with others.
  • The cloud version is a bit more expensive, which offers the same tools as the desktop, which I found a little troublesome and it didn't make sense to me.
  • Their customer service was a little lacking. I had a couple of general questions and I was on hold for about 15 minutes...which isn't good when you're in the middle of a busy workday.
No photo available
  • Excel data type handling - makes assumptions on a single data type where there might be multiple data types in a specific column.
  • Better handling of data schema changes - If you have column changes or additions in your data source, it does not always implicitly make those changes across all data transformation tasks within the package.
  • No reliable built-in functionality for SFTP connections.
No photo available

Likelihood to Renew

No score
No answers yet
No answers on this topic
SSIS6.0
Based on 2 answers
A bit outdated compared to competitors, esp in the open source community
No photo available

Usability

No score
No answers yet
No answers on this topic
SSIS7.0
Based on 3 answers
Easy to use, however there are functionality limits
No photo available

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

No score
No answers yet
No answers on this topic
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

No score
No answers yet
No answers on this topic
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

There's a ton of competition for AWR but in all honesty, if you're on a budget, I'd advise going with this one. It gets you pretty accurate results, updates their info in real time, and all for about $49/month base price. It's pretty good software for the money that you're paying
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 stayed within our client's allotted budget (which drives more business our way down the road!)
  • Updated information in real-time assures our clients that they get the most accurate information possible, as quickly as possible.
  • It's been only slightly detrimental to my workflow (which is one little drawback of the program) sometimes I have to enlist the help of a keyword generator (because i find the one with the program a bit lacking)
No photo available
  • SSIS has allowed us to meet a complex variety of ETL needs without having to acquire a profound knowledge of application programming and the learning curve is really not bad considering the power available. We heavily depend on SSIS every day.
  • SSIS or SQL Server doesn't play nice with Sybase databases, and it takes some work to make ETL go smoothly between Sybase and SQL server databases, particularly since SQL Server Management Studio can't query certain Sybase formats.
  • It is included with SQL Server, so it is a very powerful tool included at no additional cost. It has saved us a lot of money over possible alternatives.
Chris Morgan profile photo

Pricing Details

Advanced Web Ranking

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

SSIS

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