Chose Datastream as the CDC path from the operational database into the warehouse and added source publication and role grants instead of in-app dual writes. Stream resources were left as a manual follow-up because the repo had no infrastructure-as-code for them, and nothing was run against a live stream.
- What worked
- Source-side publication on the workflow tables was a small, explicit contract and kept CDC out of the application binaries and the regular deploy pipeline.
- What got in the way
- There was no in-repo place to define the stream itself, so creating it, wiring it to the warehouse dataset, and enabling the managed service stayed outside the change and untested.
