The Guidance demonstrates how you can build a data pipeline without creating code or managing servers, making it easy for you to deploy data lakes quickly for your small or medium-size business. By using serverless AWS services, you can start using analytics services on AWS immediately, without facing a high barrier to entry or requiring in-house expertise.

Please note: [Disclaimer]

Architecture Diagram

Download the architecture diagram PDF 

Well-Architected Pillars

The AWS Well-Architected Framework helps you understand the pros and cons of the decisions you make when building systems in the cloud. The six pillars of the Framework allow you to learn architectural best practices for designing and operating reliable, secure, efficient, cost-effective, and sustainable systems. Using the AWS Well-Architected Tool, available at no charge in the AWS Management Console, you can review your workloads against these best practices by answering a set of questions for each pillar.

The architecture diagram above is an example of a Solution created with Well-Architected best practices in mind. To be fully Well-Architected, you should follow as many Well-Architected best practices as possible.

  • This Guidance uses various AWS services to handle the undifferentiated heavy lifting of integrating third-party data sources with your AWS account. Amazon AppFlow helps you securely transfer data between your Salesforce service and AWS, and AWS Glue helps you fully automate data preparations from external sources, making it easier to use Athena for querying.

    Read the Operational Excellence whitepaper 
  • This Guidance uses fully managed services to help secure connected third-party data sources so that you don’t have to manage the underlying data connecters that establish secure API integration. Amazon S3 encrypts your data at rest by default using managed encryption keys, and Amazon AppFlow manages the security credentials of connected data sources.

    Read the Security whitepaper 
  • This Guidance helps you reliably scale your data workloads without needing to manage infrastructure. For example, Amazon S3 is highly scalable and provides durable data storage. Amazon AppFlow helps you validate data, securely connect to data sources, and monitor data flow to resolve issues quickly. And Data Catalog provisions only the resources required to integrate your data.

    Read the Reliability whitepaper 
  • This Guidance makes it easy for you to establish and scale data integration with minimal effort by using Amazon AppFlow to automate bidirectional data flows between systems with just a few clicks. Data workflows easily scale and only run when needed.

    Read the Performance Efficiency whitepaper 
  • This Guidance uses Amazon AppFlow, which automatically provisions and runs data workflows based on a schedule you set based on your business objectives, helping you reduce costs. This Guidance also uses AWS Glue, which is fully managed and serverless, so you pay for only the resources consumed. Additionally, Amazon S3 lets you archive data into storage tiers to reduce cost. The Amazon S3 Intelligent-Tiering storage class provides automatic cost savings based on access patterns, without sacrificing performance.

    Read the Cost Optimization whitepaper 
  • This Guidance uses Amazon AppFlow and AWS Glue, which use serverless architectures to share underlying infrastructure and reduce unnecessary operations. You can schedule them to run automatically, and by combining Amazon AppFlow data workflow scheduling with automatic AWS Glue crawlers, you consume resources only when you need to, so they won’t run during idle times. This helps reduce the impact of provisioned infrastructure on the environment.

    Read the Sustainability whitepaper 

Implementation Resources

A detailed guide is provided to experiment and use within your AWS account. Each stage of building the Guidance, including deployment, usage, and cleanup, is examined to prepare it for deployment.

The sample code is a starting point. It is industry validated, prescriptive but not definitive, and a peek under the hood to help you begin.

AWS Smart Business
Blog

Reinventing Small and Medium Businesses with Better Data Insights

This post explores how smart businesses of any size can reinvent themselves in numerous ways.

Disclaimer

The sample code; software libraries; command line tools; proofs of concept; templates; or other related technology (including any of the foregoing that are provided by our personnel) is provided to you as AWS Content under the AWS Customer Agreement, or the relevant written agreement between you and AWS (whichever applies). You should not use this AWS Content in your production accounts, or on production or other critical data. You are responsible for testing, securing, and optimizing the AWS Content, such as sample code, as appropriate for production grade use based on your specific quality control practices and standards. Deploying AWS Content may incur AWS charges for creating or using AWS chargeable resources, such as running Amazon EC2 instances or using Amazon S3 storage.

Was this page helpful?