What users are saying about
16 Ratings
12 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100
16 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9 out of 100

Likelihood to Recommend

Azure Data Factory

If you are just getting started and all your data is resident in the Azure cloud, then Azure Data Factory is likely to work fine without having to jump through too many hoops. However, in a hybrid environment (which is most of them these days), ADF will likely need a leg up. It works well for scheduling and basic scheduling/orchestration tasks, but the feature set is not at a level with SSIS (which has been around for 15 years so...). As ADF now supports deploying SSIS, it is also a good candidate if large amounts of your data are resident in the Azure cloud and you have an existing SSIS investment in code and licensing. We are using it in a hybrid fashion for the data warehouse and will slowly transition over to ADF as the feature set improves. We are also using it for cloud-native applications that only require supplemental data from on-prem resources
Anonymous | TrustRadius Reviewer

SAS/Access

SAS/Access is well suited for companies who need to manipulate and analyze large databases and data-sets. It does the same thing as SQL, and if you already know basic SAS coding it is easier to pick up. SAS/Access works well with analyzing data from multiple data-sources at once, including large databases stored in external and virtual environments like Hadoop. Data can be easily reassembled from relational databases for use by the user. SAS/Access is not necessary if you are only pulling data from one database that you have the physical file for.
Nikardi Jallah | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Azure Data Factory
8.4
SAS/Access
9.7
Connect to traditional data sources
Azure Data Factory
8.2
SAS/Access
10.0
Connecto to Big Data and NoSQL
Azure Data Factory
8.6
SAS/Access
9.5

Data Transformations

Azure Data Factory
8.4
SAS/Access
8.5
Simple transformations
Azure Data Factory
9.1
SAS/Access
9.0
Complex transformations
Azure Data Factory
7.8
SAS/Access
8.0

Data Modeling

Azure Data Factory
8.2
SAS/Access
8.8
Data model creation
Azure Data Factory
9.0
SAS/Access
9.0
Metadata management
Azure Data Factory
9.0
SAS/Access
9.0
Business rules and workflow
Azure Data Factory
7.7
SAS/Access
9.0
Collaboration
Azure Data Factory
9.0
SAS/Access
9.0
Testing and debugging
Azure Data Factory
6.6
SAS/Access
8.0

Data Governance

Azure Data Factory
7.7
SAS/Access
9.7
Integration with data quality tools
Azure Data Factory
8.1
SAS/Access
9.5
Integration with MDM tools
Azure Data Factory
7.2
SAS/Access
10.0

Pros

Azure Data Factory

  • Cloud-based
  • Fast
  • Reliable
Marco Urrea | TrustRadius Reviewer

SAS/Access

  • Secure connections to databases
  • Managed access to databases and data
  • Customized access to databases
Larry Burns | TrustRadius Reviewer

Cons

Azure Data Factory

  • Limited source/sink (target) connectors depending on which area of Azure Data Factory you are using.
  • Does not yet have parity with SSIS as far as the transforms available.
Anonymous | TrustRadius Reviewer

SAS/Access

  • Syntax for the connection string can be tricky
  • Specification of the data source driver can be tricky
Jim Metcalf | TrustRadius Reviewer

Support Rating

Azure Data Factory

Azure Data Factory 7.0
Based on 2 answers
We have not had need to engage with Microsoft much on Azure Data Factory, but they have been responsive and helpful when needed. This being said, we have not had a major emergency or outage requiring their intervention. The score of seven is a representation that they have done well for now, but have not proved out their support for a significant issue
Anonymous | TrustRadius Reviewer

SAS/Access

SAS/Access 10.0
Based on 4 answers
I have always received excelled service working with SAS technical support. Additionally, the tool is used so widely that there are many online resources and use cases that allow you to see many other uses or support routes.
Larry Burns | TrustRadius Reviewer

Alternatives Considered

Azure Data Factory

I'd chose data factory because its very easy to use, its UI is beautiful, it's library for .net is very useful and it lives within the microsoft ecosystem.
Marco Urrea | TrustRadius Reviewer

SAS/Access

Datastage might be the closest one. Being a full ETL tool, it's weird to compare both. Datastage might be more robust for extraction but it lacks the simplicity that the end users need for everyday data extract and analysis.
Anonymous | TrustRadius Reviewer

Return on Investment

Azure Data Factory

  • It is very useful and make things easier
  • Debugging can improve
  • Its better suited than other products with the same objective
Marco Urrea | TrustRadius Reviewer

SAS/Access

  • Bring usable data together quickly for downstream consumption e.g. modelling and reporting.
Horst Wolter | TrustRadius Reviewer

Pricing Details

Azure Data Factory

General

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

SAS/Access

General

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

Rating Summary

Likelihood to Recommend

Azure Data Factory
8.5
SAS/Access
10.0

Support Rating

Azure Data Factory
7.0
SAS/Access
10.0

Add comparison