What users are saying about

SSIS

155 Ratings

Advanced Web Ranking

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

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

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

SSIS is well suited for any processes that can be automated to move data from a source to a destination. However, I don't think SSIS can work directly with Rest API's during it's processing. If that is required than it would be necessary to build your own custom SSIS component to enable this functionality. Extending SSIS to permit this is possible.
Eddie Brady 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.2
Connect to traditional data sources
Advanced Web Ranking
SSIS
9.1
Connecto to Big Data and NoSQL
Advanced Web Ranking
SSIS
7.3

Data Transformations

Advanced Web Ranking
SSIS
8.8
Simple transformations
Advanced Web Ranking
SSIS
9.4
Complex transformations
Advanced Web Ranking
SSIS
8.1

Data Modeling

Advanced Web Ranking
SSIS
7.4
Data model creation
Advanced Web Ranking
SSIS
7.1
Metadata management
Advanced Web Ranking
SSIS
6.6
Business rules and workflow
Advanced Web Ranking
SSIS
8.4
Collaboration
Advanced Web Ranking
SSIS
6.9
Testing and debugging
Advanced Web Ranking
SSIS
7.8

Data Governance

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

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
  • SSIS allows you to run many processes in parallel. Thus, you can run multiple data flows simultaneously to increase the throughput of the migration process.
  • SSIS provides many tools for transforming data during the migration process.
Eddie Brady 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
SSIS8.0
Based on 2 answers
Easy to use, however there are functionality limits
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
While Clover provides a number of the same data transformation techniques, it is not nearly as robust as SSIS. It also requires knowledge of the specific scripting language while SSIS allows the user to choose from a number of commonly-used scripting languages (i.e. VB, C#, etc.). If you are using SQL Server, integrating with SSIS is a no-brainer.
No photo available

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 been a huge time savings where previously manual data scrubbing and/or import tasks have been automated.
  • It has allowed us to schedule jobs that previously required human involvement. Now everything runs seamlessly through SQL jobs.
  • It provides us with a wider customer base as we are pigeon-holed into working with a small number of data source options. We can work with an infinite amount of data sources due to our utilization of SSIS.
No photo available

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