The S/4 Connector is a simple way of getting S/4Hana table data 1:1 into Apache Kafka. Once the data is available in Kafka, any services or data consumers can use the data in the frequency they need. A Data Warehouse might consume the data just once a day, other consumers within milliseconds.
Internally this connector does use the same techniques as SAP SLT does, but in a slightly optimized manner, tailor made for S/4Hana. Therefore it does not suffer from the side effects of SLT and has less impact on the source system.