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
DELETE operation and push the events into a Meroxa stream.
Before creating a source connector:
- Setup - Setup your SQL Server instance and acquire the credentials needed to talk to Meroxa.
- Add Resource - Add a SQL Server resource to your Meroxa Resource.
The input of SQL Server is a table name.
Then, to configure SQL Server as a source:
Using the Dashboard, perform these steps to add a new source to a pipeline:
- Create a new pipeline.
- Add a source connector:
- Name your new connector and select your SQL Server resource:
- Select "Create" and Done 🚀.
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.