This article discusses the pros and cons of Change Data Capture and why In-Process querying could actually end up making it redundant. Ready?
What is Change Data Capture?
Change data capture is a method of ETL (Extract, Transform, Load) where data is extracted from a source, transformed, and then loaded