Can SQL Server Change Data capture (CDC) log rows to an external DB? I have not used SQL Server CDC before, but to my understanding it works like this:


business data changes in source DB, e.g. SQL Server
CDC has been configured to track certain table/column changes, which it reads asynchronously from business data server transactional logs


I have two question:
1. Can CDC be triggered to store e.g. some DB rows to an external DB, or do any eventual database rows that are being created from the transaction logs, need to be stored back to the source DB?
2. Can CDC read from the business DB transactional logs and create new rows to a NoSQL DB?

Thanks!
CDC is just the component that exposes the changes. It is strictly tied to the host database where the changes occur. CDC is useless without an application you provide which consumes the changes. This application of yours can do anything with the changes, including storing them anywhere you fancy. You just have to implement this application.