Use YAML configuration for Kafka connections, improve local runtime support

Use YAML configuration for Kafka connections, improve local runtime support #2844