Transactional and Analytical Models

Application Databases (OLTP Systems)

An application database supports the reads and writes behind a running product. Small, frequent operations and predictable response times matter.

An extraction job may need a large part of a table while the application is handling small customer requests. Both compete for the same database resources if they run on the source.

Find out how the source exposes changes and what read load it can tolerate. Those constraints help determine whether snapshots, incremental reads, or CDC are appropriate.

Treat it as a source with its own workload. Extracting data must not consume the resources the application needs to serve users.