Automated Data Analytics on AWS enables you to derive meaningful insights from data in a matter of minutes through a simple and intuitive user interface.
This solution helps to easily consolidate data distributed across siloes, apply fine-grained governance controls, and query data through a tailored user experience that is abstracted from underlying AWS services. The solution is quickly deployed to an AWS account through a single click, removing the need for deep technical expertise.
Ready to use out of the box, no need to build your own platform. If you are early in your data journey, get started quickly with the solution, and expand your capabilities over time.
Removes the heavy lifting of joining and managing disparate datasets.
Anyone with SQL skills can quickly and easily derive insights from their data.
Users can share datasets and queries across teams with flexible controls to enforce access protection.
The diagram below presents the architecture that will be automatically deployed following the steps in the solution's Implementation Guide and accompanying AWS CloudFormation template.
Once deployed, users will access the application through a standalone user interface that abstracts away the underlying AWS services used.
The AWS CloudFormation template provisions the following infrastructure and services provided by the solution.
Amazon EventBridge for event-driven application messaging between micro-services and notifications for user.
- AWS Lambda functions for handling API requests (NodeJS & Java), and deploy dynamic infrastructure for each data product (NodeJS).
- AWS Step Functions for managing the lifecycle of data products, and asynchronous life-cycle of query execution.
- Amazon S3 buckets for storing processed data, user-defined scripts, and file uploads.
- AWS Glue tables and resources for handling the data extract, transform, and load (ETL) processing.
- Amazon Athena for performing federated queries which stores results in Amazon S3 buckets.
- Amazon DynamoDB data stores for saved queries, query history, and query caching, and governance metadata.
- AWS Lambda functions for handling source import.
- AWS CloudFormation stack to manage resources.
- AWS Step Function for orchestrating lifecycle management.
- AWS Glue crawlers, data catalogues, and jobs for ETL.
- AWS Secrets Manager to store external credentials.
- Amazon ECS tasks for processing large data ingestion jobs.
- Amazon Athena and Amazon Comprehend for detecting PII entities.
Ingress (Data Connectors): Automated Data Analytics on AWS supports multiple source data connectors out-of-the-box including file upload, AWS S3, Amazon Kinesis, Amazon CloudWatch, Google BigQuery, Google Cloud Storage, and Google Analytics, and databases such as MySql5, Postgres, Oracle, and MS SQL.
Egress (Clients): Automated Data Analytics on AWS support both JDBC and ODBC standards for consuming data from common clients.
Note: Before you launch the solution in the AWS Management Console, ensure that you meet the prerequisites in the implementation guide.
Learn how Stax, a global B2B software-as-a-service company, enhanced its analytics using Automated Data Analytics (ADA) on AWS.