Skip to main content

Create SQL Server Source

The SQL Server source is a Change Data Capture connector that leverages SQL Server's Binary Log. This connector will perform an initial snapshot of the data. Then, it will stream every INSERT, UPDATE, DELETE operation and push the events into a Meroxa stream.

Before creating a source connector:

  1. Setup - Setup your SQL Server instance and acquire the credentials needed to talk to Meroxa.
  2. Add Resource - Add a SQL Server resource to your Meroxa Resource.

Input#

The input of SQL Server is a table name.

Creating Connector#

Then, to configure SQL Server as a source:

First, you must create a new pipeline.

Then, using the CLI, you can run the following command to add a new source to a pipeline:

meroxa connector create to-sqlserver-connector \ --from my-sqlserver \ --input dbo.Users \ --pipeline my-pipeline

The command above creates a new source connector called to-sqlserver-connector, sets the source to a resource named my-sqlserver, and configures the input.