My article on medium summarizes experiences from various projects with log-based change data capture (CDC). There are many use cases for which CDC is beneficial. Some DBs even have CDC functionality integrated without requiring a separate tool.
The article first compares change columns, triggers, and log-based change data capture. Afterwards, replication-mode and auditing mode is explained. Use cases like database migration, microservices architecture, DWH/Data Lake ingest, etc. are discussed. The final chapter gives some hints about standard tools like Oracle Golden Gate or IBM IIDR and open source activities around Debezium and Kafka.