What users are saying about
23 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
17 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

Feature Set Ratings

    Database-as-a-Service

    8.4

    Amazon Athena

    84%

    Azure Data Lake Analytics

    Feature Set Not Supported
    N/A
    Amazon Athena ranks higher in 6/6 features

    Automatic software patching

    8.0
    80%
    2 Ratings
    N/A
    0 Ratings

    Database scalability

    8.0
    80%
    2 Ratings
    N/A
    0 Ratings

    Automated backups

    7.7
    77%
    3 Ratings
    N/A
    0 Ratings

    Database security provisions

    9.0
    90%
    2 Ratings
    N/A
    0 Ratings

    Monitoring and metrics

    8.7
    87%
    3 Ratings
    N/A
    0 Ratings

    Automatic host deployment

    9.0
    90%
    2 Ratings
    N/A
    0 Ratings

    Attribute Ratings

    • Amazon Athena is rated higher in 1 area: Likelihood to Recommend

    Likelihood to Recommend

    9.3

    Amazon Athena

    93%
    3 Ratings
    8.6

    Azure Data Lake Analytics

    86%
    7 Ratings

    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.
    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.
    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
    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.
    Read full review

    Cons

    Amazon AWS

    • Query manager can incoperate GUI based query designer
    • Auto-completion engine sometimes overwrite the query
    • Time range selection should be implicit
    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.
    Read full review

    Pricing Details

    Amazon Athena

    Starting Price

    $5 per TB of Data Scanned

    Editions & Modules

    Amazon Athena editions and modules pricing
    EditionModules
    Price per Query$5.001

    Footnotes

    1. per TB of Data Scanned

    Offerings

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services

    Entry-level set up fee?

    No setup fee

    Additional Details

    Azure Data Lake Analytics

    Starting Price

    Editions & Modules

    Azure Data Lake Analytics editions and modules pricing
    EditionModules

    Footnotes

      Offerings

      Free Trial
      Free/Freemium Version
      Premium Consulting/Integration Services

      Entry-level set up fee?

      No setup fee

      Additional Details

      Alternatives Considered

      Amazon AWS

      Amazon Athena, a product from Amazon, competes with offerings from Google and Microsoft. Overall, I think your database choice depends on some of the other applications you are running at your company. For example, if you are using Microsoft Power BI for reporting needs, you might want to consider going the Azure route.
      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.
      Read full review

      Return on Investment

      Amazon AWS

      • Easy to query terabytes of data with faster response
      • Pricing model is also cheap
      • No indexing and partitioning
      Read full review

      Microsoft

      • Azure Data Analytics has helped us save resources by securely moving data and documents from on-premise to the cloud.
      • Our overall working efficiency has improved thanks to the quick and short time required for processing data.
      • We have saved up to 30% of our revenue thanks to the multiple integrations readily available with other Microsoft applications.
      Read full review

      Add comparison