Kafka Summit London 2018 - Look Ma, no Code! Building Streaming Data Pipelines with Apache Kafka

Kafka Summit London 2018 - Look Ma, no Code! Building Streaming Data Pipelines with Apache Kafka

Have you ever thought that you needed to be a programmer to do stream processing and build streaming data pipelines? Think again!

Companies new and old are all recognising the importance of a low-latency, scalable, fault-tolerant data backbone, in the form of the Apache Kafka streaming platform. With Kafka, developers can integrate multiple sources and systems, which enables low latency analytics, event driven architectures and the population of multiple downstream systems. These data pipelines can be built using configuration alone.

In this talk, we'll see how easy it is to stream data from a database such as Oracle into Kafka using the Kafka Connect API. In addition, we'll use KSQL to filter, aggregate and join it to other data, and then stream this from Kafka out into multiple targets such as Elasticsearch and MySQL. All of this can be accomplished without a single line of code!

Why should Java geeks have all the fun?

2bded62396ea66c84bd10e91c718dea9?s=128

Robin Moffatt

April 24, 2018
Tweet

Transcript

  1. 1.

    Look Ma, no Code! 
 Building Streaming Data Pipelines with

    Apache Kafka Kafka Summit London 24 Apr 2018 / Robin Moffatt @rmoff robin@confluent.io https://speakerdeck.com/rmoff/
  2. 2.

    2 Let’s take a trip back in time. Each application

    has its own database for storing information. But we want that information elsewhere for analytics and reporting.
  3. 3.

    3 We don't want to query the transactional system, so

    we create a process to extract from the source to a data warehouse / lake
  4. 4.

    4 Let’s take a trip back in time We want

    to unify data from multiple systems, so create conformed dimensions and batch processes to federate our data. This is all batch driven, so latency is built in by design.
  5. 5.

    5 Let’s take a trip back in time As well

    as our data warehouse, we want to use our transactional data to populate search replicas, Graph databases, noSQL stores…all introducing more point- to-point dependencies in our system
  6. 6.

    6 Let’s take a trip back in time Ultimately we

    end up with a spaghetti architecture. It can't scale easily, it's tightly coupled, it's generally batch-driven and we can't get data when we want it where we want it.
  7. 8.

    8 Apache Kafka, a distributed streaming platform, enables us to

    decouple all our applications creating data from those utilising it. We can create low- latency streams of data, transformed as necessary.
  8. 10.

    10 Happy days! We can actually build streaming data pipelines

    using just our bare hands, configuration files, and SQL.
  9. 12.

    12 $ whoami • Partner Technology Evangelist @ Confluent •

    Working in data & analytics since 2001 • Oracle ACE Director & Dev Champion • Blogging : http://rmoff.net & 
 https://www.confluent.io/blog/author/robin/ • Twitter: @rmoff • Geek stuff • Beer & Fried Breakfasts https://speakerdeck.com/rmoff/
  10. 13.

    13

  11. 14.

    14

  12. 16.

    16 Build Complex Pipelines Raw logs Raw logs Error logs

    Elasticsearch HDFS / S3 Stream Processing App Server
  13. 18.

    18 Build Applications + Pipelines Raw logs Raw logs Error

    logs SLA breaches Elasticsearch HDFS / S3 Alert App Stream Processing App Server
  14. 19.

    19

  15. 20.

    Confluent Partner Briefing 20 The Connect API of Apache Kafka®

    ✓ Centralized management and configuration ✓ Support for hundreds of technologies including RDBMS, Elasticsearch, HDFS, S3 ✓ Supports CDC ingest of events from RDBMS ✓ Preserves data schema ✓ Fault tolerant and automatically load balanced ✓ Extensible API ✓ Single Message Transforms ✓ Part of Apache Kafka, included in
 Confluent Open Source Reliable and scalable integration of Kafka with other systems – no coding required. { "connector.class": "io.confluent.connect.jdbc.JdbcSourceConnector", "connection.url": "jdbc:mysql://localhost:3306/demo?user=rmoff&password=foo", "table.whitelist": "sales,orders,customers" } https://docs.confluent.io/current/connect/
  16. 21.

    21 Kafka Connect Kafka Brokers Kafka Connect Tasks Workers Sources

    Sinks Amazon S3 syslog flat file CSV JSON
  17. 22.

    22 Streaming Application Data to Kafka • Modifying applications is

    not always possible or desirable • And what if the data gets changed within the database or by other apps? • Query-based CDC with Kafka Connect's JDBC source is one option for extracting data • Polls the source DB --> Latency & Load implications • Requires key/ts in the schema • Can't capture deletes https://www.confluent.io/blog/no-more-silos-how-to-integrate-your-databases-with-apache-kafka-and-cdc
  18. 23.

    23 Liberate Application Data into Kafka with log-based CDC •

    Relational databases use transaction logs to ensure Durability of data • Log-based Change-Data-Capture (CDC) mines the log to get raw events from the database • CDC tools that integrate with Kafka Connect include: • Debezium • GoldenGate • Attunity • + more https://www.confluent.io/blog/no-more-silos-how-to-integrate-your-databases-with-apache-kafka-and-cdc
  19. 24.

    24 Single Message Transform (SMT) -- Extract, TRANSFORM, Load… •

    Modify events before storing in Kafka: • Mask/drop sensitive information • Set partitioning key • Store lineage • Modify events going out of Kafka: • Route high priority events to faster data stores • Direct events to different Elasticsearch indexes • Cast data types to match destination
  20. 28.

    28 KSQL: a Streaming SQL Engine for Apache Kafka™ from

    Confluent • Enables stream processing with zero coding required • The simplest way to process streams of data in real-time • Powered by Kafka: scalable, distributed, battle-tested • All you need is Kafka–No complex deployments of bespoke systems for stream processing Ksql>
  21. 29.

    KSQL for Streaming ETL CREATE STREAM vip_actions AS 
 SELECT

    userid, page, action FROM clickstream c LEFT JOIN users u ON c.userid = u.user_id 
 WHERE u.level = 'Platinum'; Joining, filtering, and aggregating streams of event data
  22. 30.

    KSQL for Anomaly Detection CREATE TABLE possible_fraud AS
 SELECT card_number,

    count(*)
 FROM authorization_attempts 
 WINDOW TUMBLING (SIZE 5 SECONDS)
 GROUP BY card_number
 HAVING count(*) > 3; Identifying patterns or anomalies in real-time data, surfaced in milliseconds
  23. 31.

    KSQL for Real-Time Monitoring • Log data monitoring, tracking and

    alerting • syslog data • Sensor / IoT data CREATE STREAM SYSLOG_INVALID_USERS AS SELECT HOST, MESSAGE FROM SYSLOG WHERE MESSAGE LIKE '%Invalid user%'; http://cnfl.io/syslogs-filtering / http://cnfl.io/syslog-alerting
  24. 32.

    CREATE STREAM views_by_userid WITH (PARTITIONS=6, REPLICAS=5, VALUE_FORMAT='AVRO', TIMESTAMP='view_time') AS 


    SELECT * FROM clickstream PARTITION BY user_id; KSQL for Data Transformation Make simple derivations of existing topics from the command line
  25. 36.
  26. 40.

    40 Confluent Open Source : Apache Kafka with a bunch

    of cool stuff! For free! Database Changes Log Events loT Data Web Events … CRM Data Warehouse Database Hadoop Data
 Integration … Monitoring Analytics Custom Apps Transformations Real-time Applications … Apache Open Source Confluent Open Source Confluent Enterprise Confluent Platform Confluent Platform Apache Kafka® Core | Connect API | Streams API Data Compatibility Schema Registry Monitoring & Administration Confluent Control Center | Security Operations Replicator | Auto Data Balancing Development and Connectivity Clients | Connectors | REST Proxy | CLI Apache Open Source Confluent Open Source Confluent Enterprise SQL Stream Processing KSQL
  27. 41.

    41 Streaming ETL, powered by Apache Kafka and Confluent Platform

    @rmoff robin@confluent.io https://slackpass.io/confluentcommunity https://www.confluent.io/download/
  28. 42.

    42 Kafka Summit San Francisco 2018 Dates: October 16-17, 2018

    Location: Pier 27, San Francisco CFP Opens: April 30, 2018 www.kafka-summit.org Presented by
  29. 43.

    Look Ma, no Code! 
 Building Streaming Data Pipelines with

    Apache Kafka Kafka Summit London 24 Apr 2018 / Robin Moffatt @rmoff robin@confluent.io https://speakerdeck.com/rmoff/