title: Kafka/Connect/Streams for DB field update
body: <p>my problem is the following:</p>
  
  <p>I have 2 kafka topics: </p>
  
  <ul>
  <li><code>customer-purchase</code>: contains information about a purchase made by a customer, with a field indicating the status being equal to <code>NEW</code>.</li>
  <li><code>purchase-status</code>: containing events updating the latest status of the purchase, e.g. <code>IN TRANSIT</code>, <code>DELIVERED</code>...</li>
  </ul>
  
  <p>Using kafka, kafka connect and/or kafka streams, I would like to end up with an SQL database which contains the purchase enriched with the latest status information.</p>
  
  <p>In a DB world this would result in a simple <code>UPDATE</code> query. </p>
  
  <p>Theoretically, I could write 1 consumer (or 1 connect sink) for the <code>customer-purchase</code>, where everything is simply dumped to the DB and 1 consumer for the <code>purchase-status</code> which would trigger a DB <code>UPDATE</code> query, but I was wondering whether there is a more kafka-like way to do this.</p>
  
  <p>Note: using kafka-streams and joining the 2 topics there seemed a little overkill to me since I actually don't need the join but a simple update of a field. But I might be completely wrong in this assumption!</p>