Looking for on Premises tool to read data from SQL logs and populate data warehouse

I am looking for an on-premises tool that can efficiently import and export and transform data across multiple environments. The tool should work by reading database logs to minimize application performance impact. I've already evaluated CDC (Change Data Capture) and Service Broker but would prefer other solutions. Importantly, the tool must operate effectively in a secure environment.