What users are saying about
30 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
190 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.3 out of 100

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.
Murray Clear | TrustRadius Reviewer

Azure SQL Database

Your upcoming app can be built faster on a fully managed SQL database and can be moved into Azure with a few to no application code changes. Flexible and responsive server less computing and Hyperscale storage can cope with your changing requirements and one of the main benefits is the reduction in costs, which is noticeable.
Niloofar Keshvari Nia | TrustRadius Reviewer

Feature Rating Comparison

Data Source Connection

Azure Data Factory
8.7
Azure SQL Database
Connect to traditional data sources
Azure Data Factory
9.1
Azure SQL Database
Connecto to Big Data and NoSQL
Azure Data Factory
8.4
Azure SQL Database

Data Transformations

Azure Data Factory
8.3
Azure SQL Database
Simple transformations
Azure Data Factory
8.9
Azure SQL Database
Complex transformations
Azure Data Factory
7.7
Azure SQL Database

Data Modeling

Azure Data Factory
8.6
Azure SQL Database
Data model creation
Azure Data Factory
9.4
Azure SQL Database
Metadata management
Azure Data Factory
8.0
Azure SQL Database
Business rules and workflow
Azure Data Factory
8.5
Azure SQL Database
Collaboration
Azure Data Factory
8.5
Azure SQL Database
Testing and debugging
Azure Data Factory
8.3
Azure SQL Database
feature 1
Azure Data Factory
9.0
Azure SQL Database

Data Governance

Azure Data Factory
8.4
Azure SQL Database
Integration with data quality tools
Azure Data Factory
8.7
Azure SQL Database
Integration with MDM tools
Azure Data Factory
8.1
Azure SQL Database

Database-as-a-Service

Azure Data Factory
Azure SQL Database
9.0
Automatic software patching
Azure Data Factory
Azure SQL Database
8.6
Database scalability
Azure Data Factory
Azure SQL Database
9.6
Automated backups
Azure Data Factory
Azure SQL Database
9.0
Database security provisions
Azure Data Factory
Azure SQL Database
9.0
Monitoring and metrics
Azure Data Factory
Azure SQL Database
8.8
Automatic host deployment
Azure Data Factory
Azure SQL Database
8.9

Pros

Azure Data Factory

  • Easy to create ETL workflows
  • Pre-defined templates to design the pipelines
  • Easy to create schedules to run the pipelines
  • Fast and reliable
  • Interactive user interface with drag/drop and multiple useful options on the dashboard
  • Easy integration with other Azure services
Panav Beri | TrustRadius Reviewer

Azure SQL Database

  • Maintenance is always an issue, so using a cloud solution saves a lot of trouble.
  • On premise solutions always suffer from fragmented implementations here and there, where several "dba's" keep track of security and maintenance. With a cloud database it's much easier to keep a central overview.
  • Security options in SQL database are next level... data masking, hiding sensitive data where always neglected on premise, whereas you'll get this automatically in the cloud.
Anonymous | 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

Azure SQL Database

  • One needs to be aware that some T-SQL features are simply not available.
  • The programmatic access to server, trace flags, hardware from within Azure SQL Database is taken away (for a good reason).
  • No SQL Agent so your jobs need to be orchestrated differently.
  • The maximum concurrent logins maybe an unexpected problem.
  • Sudden disconnects.
  • The developers and admin must study the capacity and tier usage limits https://docs.microsoft.com/en-us/azure/azure-subscription-service-limits otherwise some errors or even transaction aborts never seen before can occur.
  • Only one Latin Collation choice.
  • There is no way to debug T-SQL ( a big drawback in my point of view).
Arthur Zubarev | TrustRadius Reviewer

Likelihood to Renew

Azure Data Factory

No score
No answers yet
No answers on this topic

Azure SQL Database

Azure SQL Database 8.0
Based on 1 answer
This is best solution as a DBA one could expect from a service provider and as a cloud service, it removes all your hassles.
Zimran Azim | 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

Azure SQL Database

Azure SQL Database 9.0
Based on 6 answers
We give the support a high rating simply because every time we've had issues or questions, representatives were in contact with us quickly. Without fail, our issues/questions were handled in a timely matter. That kind of response is integral when client data integrity and availability is in question. There is also a wealth of documentation for resolving issues on your own.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Azure Data Factory

SSIS was used for on-premise SQL work, Azure data factory is required to unlock the full potential of Azure connected databases. The ease of configuration and the ability to schedule workflows solved so many data integration issues at speed. Without investing in ADF we would not have achieved the level of data integration we have.
Anonymous | TrustRadius Reviewer

Azure SQL Database

We moved away from Oracle and NoSQL because we had been so reliant on them for the last 25 years, the pricing was too much and we were looking for a way to cut the cord. Snowflake is just too up in the air, feels like it is soon to be just another line item to add to your Azure subscription. Azure was just priced right, easy to migrate to and plenty of resources to hire to support/maintain it. Very easy to learn, too.
Anonymous | TrustRadius Reviewer

Return on Investment

Azure Data Factory

  • Facilitate better decision-making and improve business processes.
  • Optimize business process outcomes by increasing internal efficiency and operational effectiveness.
  • Boosts revenue growth while improving business process agility.
Niloofar Keshvari Nia | TrustRadius Reviewer

Azure SQL Database

  • Perfect for small and medium databases, being very cost effective.
  • As a Platform as a Service, there is no concern about patches, upgrades and end of life.
  • Be aware of security and network capabilities. The service cannot run in the VNET as Azure Virtual Machines do.
Anonymous | TrustRadius Reviewer

Pricing Details

Azure Data Factory

General

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

Azure Data Factory Editions & Modules

Additional Pricing Details

Azure SQL Database

General

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

Azure SQL Database Editions & Modules

Edition
2 vCORE$0.50441
6 vCORE$1.51311
10 vCORE$2.521
  1. Per Hour
Additional Pricing Details

Rating Summary

Likelihood to Recommend

Azure Data Factory
8.9
Azure SQL Database
8.5

Likelihood to Renew

Azure Data Factory
Azure SQL Database
8.0

Support Rating

Azure Data Factory
7.0
Azure SQL Database
9.0

Add comparison