Reply
Highlighted
New Contributor
Posts: 2
Registered: ‎10-11-2017

Need Solution to Push Real Time Data from Kafka to DB2

[ Edited ]

Usecase: 

Real time data needs to push from Apache kafka to DB2 9.1.6. There might be couple of business logics will apply after fetching the data from kafka. What is the best solution to do this usecase? How efficiently DB2 can handle the real time data?

 

One of the Option:

  1. Kafka -> Spark streaming(processing) -> DB2 
Expert Contributor
Posts: 129
Registered: ‎08-08-2013

Re: Need Solution to Push Real Time Data from Kafka to DB2

Hi @Vikasreddy ,

 

you should have a look at KafkaConnect (here or here).

You can use e.g. the JDBC-Sink to directly push data from Kafka to RDBMS.

 

Regards...

Champion
Posts: 595
Registered: ‎05-16-2016

Re: Need Solution to Push Real Time Data from Kafka to DB2

@Vikasreddy 

I would recommend   Apache flink  if you are looking for   high throughput rates and low latency.

 

Announcements