In this short video, we'll show how to enrich a stream of data with data from a relational database. Source code: github.com/ale... Blogpost: woolford.io/202...
I'd probably have some sort of microservice make the API calls and write them to a Kafka topic. Then use a sink connector to write from that topic to a relational database (see www.confluent.io/hub/ for a list of connectors).