Integration Hub
>
Microsoft SQL Server CDC Bulk
docker pull solace/solace-micro-integration-bulk-cdc-sqlserverClick to Copy!
Asset Type:
Micro-Integrations
Provider:
Category:
Database & Data Storage
Endpoint:
Source
Support:
Solace – Included,
Solace – Support Available
Platform:
Cloud-Managed,
Self-Managed
Microsoft SQL Server CDC Bulk
The Solace Micro-Integration for Microsoft SQL Server Bulk CDC bridges data between a Solace event broker and Microsoft SQL Server. It provides a flexible and efficient way to load Microsoft SQL Server Bulk CDC data into your Solace-backed, event-driven architecture and the event mesh. Each instance supports one workflow. Only header mapping is supported; payload mapping is not available.
Self-Managed
- Captures inserts, updates, and deletes from multiple SQL Server tables simultaneously using Debezium
- Deploy locally or as a container
- Spring Framework–based configuration with advanced logging and live metrics export
- One workflow (source-to-target pipeline) per instance
Cloud-Managed
- Captures inserts, updates, and deletes from multiple SQL Server tables simultaneously using Debezium, streaming changes to topics on an event broker service
- Supports Basic Authentication and SSL Certificate Authentication (JKS or PKCS12 truststore)
- Configurable snapshot mode (initial, always, no_data, never, when_needed, and more)
- Header transformations and Smart Topics supported; payload transformations not supported
- Checkpoint state persisted in a Last Value Queue (LVQ) on the event broker