Leverage Real-Time Clickstream Data Using ksqlDB and Elasticsearch
May 26, 2020Bill Bejeck

Summary
This post details building an end-to-end IoT motion detection and alerting system using Confluent Cloud and ksqlDB. It covers hardware choices (Raspberry Pi Zero W), software components (Motion, librdkafka, Docker), and the architecture for ingesting motion events into Kafka. The system utilizes ksqlDB for real-time stream processing and querying, enabling both real-time monitoring with push queries and historical event search with pull queries. The UI is built with React and Next.js, demonstrating how to leverage real-time clickstream data using ksqlDB and Elasticsearch for analysis and visualization.
More from the Real-time Insurance Quoting with Data Streaming trail
- Accelerating Insurance Claims With a Stream Processing Architecture
- Transforming T+1 Trade Settlement for Modern Markets With Confluent
- Data Streaming in Healthcare: Achieving the Single Patient View
- Real-Time Order Management: The Key to Streamlining Your Business Operations
- Real-Time Inventory in Retail with Confluent