I'm exploring using the CDC resource for our ETL. However at one DB per client, we have several hundred databases. With the feature still in preview, what attempts/thoughts are there concerning scaling in a multi-tenant environment?
Recognizing that the CDC feature may not be the best tool at this time, we are trying to reduce our report latency to allow for real-time reporting.