<--- Back to all connectors
SQL Server on RDS
Stream changes from Amazon RDS for SQL Server in real-time using Change Data Capture (CDC). Capture every insert, update, and delete without impacting your database performance.
Stream RDS SQL Server Changes in Real-Time
Key Features
- Real-time CDC - Capture changes as they happen using SQL Server’s native CDC
- Zero Performance Impact - Read from transaction log without affecting database performance
- Schema Evolution - Automatically handle schema changes without manual intervention
- Exactly-once Delivery - Guaranteed data consistency with exactly-once semantics
How It Works
Streamkap uses SQL Server’s native CDC feature on Amazon RDS:
- No impact on your production database performance
- No need to modify your application code
- Changes are captured in the order they occurred
- Full support for inserts, updates, and deletes
Getting Started
- Enable CDC on your RDS SQL Server instance
- Create a user with appropriate permissions
- Connect Streamkap to your RDS instance
- Start streaming data to your destination
Supported Features
- Amazon RDS for SQL Server 2016+
- Multi-AZ deployments
- Read replicas
- Enhanced monitoring integration
Why Streamkap?
Reliable
Serverless platform providing enterprise reliability and scale.
Affordable
Only pay for GB into Streamkap.
Longterm
Retain data for as long as you need.
Flexible
Read once, write to many destinations.
