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?