What users are saying about

Azure Data Factory vs SAS/Access

Azure Data Factory
46 Ratings
SAS/Access
16 Ratings

Azure Data Factory

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

Based on 46 reviews and ratings

SAS/Access

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

Based on 16 reviews and ratings

Feature Set Ratings

  • SAS/Access ranks higher in 3 feature sets: Data Source Connection, Data Transformations, Data Governance
  • Azure Data Factory and SAS/Access are tied in 1 feature set: Data Modeling

Data Source Connection

8.9

Azure Data Factory

89%
9.7

SAS/Access

97%
SAS/Access ranks higher in 2/2 features
SAS/Access ranks higher in 2/2 features

Connect to traditional data sources

9.1
91%
6 Ratings
10.0
100%
5 Ratings

Connecto to Big Data and NoSQL

8.8
88%
6 Ratings
9.5
95%
4 Ratings

Data Transformations

8.3

Azure Data Factory

83%
8.5

SAS/Access

85%
SAS/Access ranks higher in 2/2 features
SAS/Access ranks higher in 2/2 features

Simple transformations

8.9
89%
6 Ratings
9.0
90%
3 Ratings

Complex transformations

7.7
77%
6 Ratings
8.0
80%
3 Ratings

Data Modeling

8.8

Azure Data Factory

88%
8.8

SAS/Access

88%
Azure Data Factory ranks higher in 4/6 features
Azure Data Factory ranks higher in 4/6 features

Data model creation

9.3
93%
4 Ratings
9.0
90%
2 Ratings

Metadata management

8.4
84%
5 Ratings
9.0
90%
2 Ratings

Business rules and workflow

8.5
85%
6 Ratings
9.0
90%
2 Ratings

Collaboration

9.2
92%
5 Ratings
9.0
90%
2 Ratings

Testing and debugging

8.7
87%
6 Ratings
8.0
80%
2 Ratings

feature 1

9.0
90%
2 Ratings
N/A
0 Ratings

Data Governance

8.1

Azure Data Factory

81%
9.7

SAS/Access

97%
SAS/Access ranks higher in 2/2 features
SAS/Access ranks higher in 2/2 features

Integration with data quality tools

8.1
81%
6 Ratings
9.5
95%
4 Ratings

Integration with MDM tools

8.1
81%
6 Ratings
10.0
100%
3 Ratings

Attribute Ratings

  • SAS/Access is rated higher in 2 areas: Likelihood to Recommend, Support Rating

Likelihood to Recommend

9.0

Azure Data Factory

90%
6 Ratings
10.0

SAS/Access

100%
5 Ratings

Support Rating

7.0

Azure Data Factory

70%
2 Ratings
10.0

SAS/Access

100%
4 Ratings

Likelihood to Recommend

Azure Data Factory

Suitable for virtually any scenario that involves working with linked Service, so that it is possible to connect Azure Data Factory to storage services for SQL data in the cloud, and that it is possible to access them at any time. Serves to make the information much cleaner and have the desired formats and structures in case of working with time tracking or general employee work tracking applications, so it is easy to create accurate and aesthetically acceptable analysis for general tracking software. It is extremely useful if you do not have any data server service, as Azure Data Factory has the ability to maintain almost 90 different data connectors without the need to use a server.

Read full review

Murray Clear | TrustRadius Reviewer
Murray Clear
View all 6 answers on this topic

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.

Read full review

Nikardi Jallah | TrustRadius Reviewer
Nikardi Jallah
View all 5 answers on this topic

Pros

Azure Data Factory

  • Easy to set up and get started.
  • Runtimes make integration with on-prem data simple and also allow for support of existing investments in SSIS.

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 6 answers on this topic

SAS/Access

  • Secure connections to databases
  • Managed access to databases and data
  • Customized access to databases

Read full review

Larry Burns | TrustRadius Reviewer
Larry Burns
View all 5 answers on this topic

Cons

Azure Data Factory

  • Error Flagging, Details of the error code is not specific especially faced this during Azure Table load
  • Missing feature of Data exploration functionality similar to Synapse Data explorer
  • missing access to orchestrate/create stream analytics job

Read full review

Gorthy Rohith | TrustRadius Reviewer
Gorthy Rohith
View all 6 answers on this topic

SAS/Access

  • Syntax for the connection string can be tricky
  • Specification of the data source driver can be tricky

Read full review

Jim Metcalf | TrustRadius Reviewer
Jim Metcalf
View all 5 answers on this topic

Pricing Details

Azure Data Factory

General

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

Starting Price

—

SAS/Access

General

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

Starting Price

—

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

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 2 answers on this topic

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.

Read full review

Larry Burns | TrustRadius Reviewer
Larry Burns
View all 4 answers on this topic

Alternatives Considered

Azure Data Factory

The easy integration with other Microsoft software as well as high processing speed, very flexible cost, and high level of security of Microsoft Azure products and services stack up against other similar products.

Read full review

Niloofar Keshvari Nia | TrustRadius Reviewer
Niloofar Keshvari Nia
View all 6 answers on this topic

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.

Read full review

Anonymous | TrustRadius Reviewer
Verified User
View all 5 answers on this topic

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

Read full review

Marco Urrea | TrustRadius Reviewer
Marco Urrea
View all 6 answers on this topic

SAS/Access

  • Bring usable data together quickly for downstream consumption e.g. modelling and reporting.

Read full review

Horst Wolter | TrustRadius Reviewer
Horst Wolter
View all 5 answers on this topic

Add comparison