<--- Back to all connectors

SQL Server on RDS

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network. Streamkap can connect to SQL Server by reading the SQL Server change logs, real-time change data capture has less impact on your database while allowing you to sync your data in real-time to support your use cases.

Add Connector
View Documentation

SQL Server on RDS real-time sync using change data capture

  • Uses Change Data Capture (CDC) to read data from SQL Server
  • Snapshot/Backfill historical data before moving to streaming
  • Can include/exclude table/columns
  • Schema evolution support for supported destinations
  • Setup SQL Server change data capture in minutes

Marcin Migda

Staff Data Engineer

"Streamkap was 4x faster and had 3x lower total cost of ownership than our previous solution"

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.

Explore more connectors

DuckDB

DuckDB is a fast, embeddable, and open-source analytical database. It can run on a local machine, embedded in an application or in the cloud and excels at complex SQL queries on various file formats (like CSV and Parquet), and integrates seamlessly with languages like Python and R.

Explore more
Destination

MotherDuck

MotherDuck is DuckDB in multiplayer mode. A serverless data warehouse with all the power of DuckDB and the scale of the cloud. Streamkap supports MotherDuck as a destination.

Explore more
Destination

DynamoDB

DynamoDB is a serverless, NoSQL database service from Amazon that enables you to develop modern applications at any scale. DynamoDB is scalable, fast and flexible. Streamkap can connect to via DynamoDB streams for real-time change data capture. For historical data, Streamkap uses DynamoDB’s S3 export feature for cost-efficient backfilling of data.

Explore more
Source
Explore All Connectors