I learned that "Change Data Capture" available under Factory Resources works ok, but after an initial load. So there are 2 strategies when there is already some data in the Source:
- Use a "Copy Activity" to perform the initial load in the destination and then use the "Change Data Capture"
OR
- Use a regular data flow in a pipeline with the "Full on first run, then incremental" run mode