Microsoft SQL Server CDC (Change Data Capture)

Change Data Capture (CDC) streams row-level inserts, updates, and deletes from SQL Server into Weld. Weld consumes the change stream and applies it to your destination with low latency and reliable propagation of updates and deletes.

---

Prerequisites

Before enabling CDC in Weld, ensure the following are true in your SQL Server environment:

• Network access: Weld can reach your SQL Server instance.
• Authentication: A SQL Server login/user for Weld with the required permissions.
• Table readiness:
  • Tables you plan to capture should have a stable row identifier (primary key recommended).
  • Know which schemas/tables you want to replicate.
• Operational readiness:
  • You have a plan to monitor/maintain CDC-related resources and retention (where applicable).

---

🔧 Enable CDC in Weld (once available)

Step 1 — Connect SQL Server in Weld

Create or open your SQL Server connection in Weld.

Step 2 — Choose CDC as the sync mode

Select CDC in the connector settings.

Step 3 — Select tables

Pick the tables to replicate and enable CDC for them.

Step 4 — Configure destination

Choose the destination dataset/schema and naming pattern. Configure apply frequency/latency targets as needed.

Weld will begin consuming changes and applying them to your destination.

---

Housekeeping

If you stop or permanently delete a sync, ensure any CDC-related resources created for that sync are cleaned up (where applicable) to avoid unnecessary retention or overhead.