Home icon

Near real-time dashboards from a source database to a cloud data warehouse on AWS

Public Sector Blog

This article describes a comprehensive solution for creating near real-time dashboards by streaming data from a source database to a cloud data warehouse using AWS services.

  • Architecture involves AWS Database Migration Service (DMS), Amazon Kinesis Data Streams, Amazon Redshift, and Amazon QuickSight
  • Uses Change Data Capture (CDC) to identify and transfer database changes in real time
  • Demonstrates a fictional county tracking office wait times as an example use case
  • Key steps include:
    • Configuring source MySQL database
    • Setting up Kinesis Data Streams
    • Configuring AWS DMS for CDC
    • Creating Amazon Redshift Serverless instance
    • Developing QuickSight dashboard
  • Enables near real-time data streaming without impacting source database performance

The solution provides a powerful method for organizations to stream change data and create real-time business intelligence dashboards using AWS services.

Go to article

The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.

Related articles

Mar 14
2025
Amazon Data Firehose now delivers real-time streaming data into Amazon S3 Tables
Mar 17
2025
From Mainframe to AWS Cloud: A comprehensive mapping guide – Part 2 (Databases)
Mar 25
2025
Amazon RDS for SQL Server supports linked servers to Teradata databases
Jan 29
2025
Hybrid big data analytics with Amazon EMR on AWS Outposts

The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.