TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Amazon Athena

    Score9.9 out of 10
    N/AAmazon Athena is an interactive query service that makes it easy to analyze data directly in Amazon S3 using standard SQL. With a few clicks in the AWS Management Console, customers can point Athena at their data stored in S3 and begin using standard SQL to run ad-hoc queries and get results in seconds. Athena is serverless, so there is no infrastructure to setup or manage, and customers pay only for the queries they run. You can use Athena to process logs, perform ad-hoc analysis, and run…

    $5

    per TB of Data Scanned

    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
    Pricing
    Amazon AthenaAzure Data Lake Analytics
    Editions & Modules
    Price per Query
    $5.00
    per TB of Data Scanned
    No answers on this topic
    Offerings
    Pricing Offerings
    Amazon AthenaAzure Data Lake Analytics
    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
    Amazon AthenaAzure Data Lake Analytics
    Considered Both Products
    Amazon AWS
    No answer on this topic
    Microsoft
    Chose Azure Data Lake Analytics
    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 …
    Incentivized
    Chose Azure Data Lake Analytics
    Both of the products selected are very good at what they do, but data lake analytics is able to bundle everything else within our preexisting data lake, which is a very big [deciding] factor.
    Incentivized
    Key User Insights
    Would buy again
    No answers on this topic
    100%
    Would buy again
    6 Answers
    Delivers good value for the price
    No answers on this topic
    100%
    Delivers good value for the price
    6 Answers
    Happy with the feature set
    No answers on this topic
    100%
    Happy with the feature set
    6 Answers
    Lived up to sales and marketing promises
    No answers on this topic
    100%
    Lived up to sales and marketing promises
    5 Answers
    Implementation went as expected
    No answers on this topic
    100%
    Implementation went as expected
    6 Answers
    Features
    Amazon AthenaAzure Data Lake Analytics
    Database-as-a-Service
    Comparison of Database-as-a-Service features of Amazon Athena and Azure Data Lake Analytics
    Feature
    Amazon Athena
    8.6
    4 Ratings
    1% below category average
    Azure Data Lake Analytics
    -
    Ratings
    Automatic software patching8.22 Ratings00 Ratings
    Database scalability9.03 Ratings00 Ratings
    Automated backups7.73 Ratings00 Ratings
    Database security provisions9.22 Ratings00 Ratings
    Monitoring and metrics8.04 Ratings00 Ratings
    Automatic host deployment9.22 Ratings00 Ratings
    Best Alternatives
    Amazon AthenaAzure Data Lake Analytics
    Small Businesses
    MongoDB Atlas
    Score8.2 out of 10
    No answers on this topic
    Medium-sized Companies
    Azure Database
    Score9.8 out of 10
    No answers on this topic
    Enterprises
    Google BigQuery
    Score8.4 out of 10
    No answers on this topic
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Amazon AthenaAzure Data Lake Analytics
    Likelihood to Recommend
    10.0
    (4 ratings)
    8.7
    (6 ratings)
    Usability
    10.0
    (1 ratings)
    -
    (0 ratings)
    User Testimonials
    Amazon AthenaAzure Data Lake Analytics
    Likelihood to Recommend
    Amazon AWS
    If you are looking to take a lot of the traditional "database administration" work off someone's plate, going with Amazon Athena certainly has "no code" options to optimize lots of database tasks. I would say this option is less appropriate if you have other Microsoft things at play, such as Power BI.
    Incentivized
    Read full review
    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
    Pros
    Amazon AWS
    • Nested Schemas like JSON data structure
    • Ability to adapt the data model to fit your queries better
    • Performance Improvement
    Incentivized
    Read full review
    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
    Cons
    Amazon AWS
    • Response caching can be improved.
    • Data Partitioning is tricky and understanding of the same could be improved.
    Incentivized
    Read full review
    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
    Usability
    Amazon AWS
    Easy to use. Scalable. Gets the job of data warehousing setup done. Using the datalake on S3 has become super convenient.
    Incentivized
    Read full review
    Microsoft
    No answers on this topic
    Alternatives Considered
    Amazon AWS
    Incentivized
    Read full review
    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
    Return on Investment
    Amazon AWS
    • The query speeds help us make more decisions in a day (speed).
    • If you need more horsepower for specific times in the day this option helps scale.
    • The security of your environment is well protected too.
    Incentivized
    Read full review
    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
    ScreenShots