TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Azure Data Lake Analytics

    Score8.3 out of 10
    N/AMicrosoft's Azure Data Lake Analytics is a BI service for processing big data jobs without consideration for infrastructure.N/A

    Azure SQL Database

    Score8.9 out of 10
    N/AAzure SQL Database is Microsoft's relational database as a service (DBaaS).

    $0.50

    Per Hour

    Pricing
    Azure Data Lake AnalyticsAzure SQL Database
    Editions & Modules
    No answers on this topic
    2 vCORE
    $0.5044
    Per Hour
    6 vCORE
    $1.5131
    Per Hour
    10 vCORE
    $2.52
    Per Hour
    Offerings
    Pricing Offerings
    Azure Data Lake AnalyticsAzure SQL Database
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    Azure Data Lake AnalyticsAzure SQL Database
    Considered Both Products
    Microsoft
    No answer on this topic
    Microsoft
    No answer on this topic
    Key User Insights
    Would buy again
    100%
    Would buy again
    6 Answers
    100%
    Would buy again
    13 Answers
    Delivers good value for the price
    100%
    Delivers good value for the price
    6 Answers
    100%
    Delivers good value for the price
    12 Answers
    Happy with the feature set
    100%
    Happy with the feature set
    6 Answers
    92%
    Happy with the feature set
    12 Answers
    Lived up to sales and marketing promises
    100%
    Lived up to sales and marketing promises
    5 Answers
    92%
    Lived up to sales and marketing promises
    11 Answers
    Implementation went as expected
    100%
    Implementation went as expected
    6 Answers
    92%
    Implementation went as expected
    12 Answers
    Features
    Azure Data Lake AnalyticsAzure SQL Database
    Database-as-a-Service
    Comparison of Database-as-a-Service features of Azure Data Lake Analytics and Azure SQL Database
    Feature
    Azure Data Lake Analytics
    -
    Ratings
    Azure SQL Database
    9.2
    28 Ratings
    6% above category average
    Automatic software patching00 Ratings9.026 Ratings
    Database scalability00 Ratings9.028 Ratings
    Automated backups00 Ratings10.028 Ratings
    Database security provisions00 Ratings9.028 Ratings
    Monitoring and metrics00 Ratings8.027 Ratings
    Automatic host deployment00 Ratings10.023 Ratings
    Best Alternatives
    Azure Data Lake AnalyticsAzure SQL Database
    Small Businesses
    No answers on this topic
    MongoDB Atlas
    Score8.2 out of 10
    Medium-sized Companies
    No answers on this topic
    Azure Database
    Score9.8 out of 10
    Enterprises
    No answers on this topic
    Google BigQuery
    Score8.4 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Azure Data Lake AnalyticsAzure SQL Database
    Likelihood to Recommend
    8.7
    (6 ratings)
    8.0
    (28 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    8.0
    (1 ratings)
    Usability
    -
    (0 ratings)
    9.0
    (1 ratings)
    Support Rating
    -
    (0 ratings)
    9.0
    (5 ratings)
    User Testimonials
    Azure Data Lake AnalyticsAzure SQL Database
    Likelihood to Recommend
    Microsoft
    Azure Data Lake Analytics services are beneficial when working with a lot of data. It can process enormous amounts of data extremely quickly. Service is secure and easy to set up, build, scale, and run on Azure. Regarding big data analytics and reporting, parallel processing has a significant impact. It consolidated our analytics from multiple systems and increased our analysis productivity. This tool has excellent support for reporting tools like Power BI and is very quick when performing analytics.
    Incentivized
    Read full review
    Microsoft
    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.
    Incentivized
    Read full review
    Pros
    Microsoft
    • Process large data transformation jobs using pretty much any language needed.
    • Native integration with Azure storage.
    • Top notch security that fulfills all audit needs.
    • Easy to consolidate enterprise data under one location - Single source of truth.
    Incentivized
    Read full review
    Microsoft
    • 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.
    Incentivized
    Read full review
    Cons
    Microsoft
    • There's a bit of bias towards cloud with ADL Analytics. Depending upon a company's infra strategy and investment plans, there are some challenges with migration and integeration.
    • Not worth the time/effort/money if the organization doesn't have "Volume" of data. Cost effective only when daily loads exceed around 1million.
    • While training materials are available online, Adoption rate - Yet to pick up.
    Incentivized
    Read full review
    Microsoft
    • 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).
    Incentivized
    Read full review
    Likelihood to Renew
    Microsoft
    No answers on this topic
    Microsoft
    This is best solution as a DBA one could expect from a service provider and as a cloud service, it removes all your hassles.
    Incentivized
    Read full review
    Usability
    Microsoft
    No answers on this topic
    Microsoft
    It just works!
    Read full review
    Support Rating
    Microsoft
    No answers on this topic
    Microsoft
    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.
    Incentivized
    Read full review
    Alternatives Considered
    Microsoft
    We did some research about Alibaba Cloud Data Lake Analytics and even being cheaper than Azure Data Lake Analytics, we decided to go for the second one once we noticed they have more features and better documentation. Another thing we considered during this process was the fact that we have more people that already have Azure Cloud knowledge.
    Incentivized
    Read full review
    Microsoft
    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.
    Incentivized
    Read full review
    Return on Investment
    Microsoft
    • It lets us manage and scan data, making our work easy and efficient.
    • It helped me manage real-time data, process it, and send it to reporting.
    • Data centralization or data warehousing projects are being implemented with its help.
    Incentivized
    Read full review
    Microsoft
    • 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.
    Read full review
    ScreenShots