This is what SAP's HANA platform is for, a microbatched CDC framework to an in memory operational data store with a standard SQL engine for traditional reporting and analytics (in theory .... being SAP, it's also weirdly engineered on the backend)
Kafka can be useful for more than staging reporting data. This pattern is more about separation from core ERP (and core ERP bureaucracy) vs. ERP reporting.