Skip to content

Latest commit

 

History

History
73 lines (47 loc) · 3.76 KB

add-source-sql-server-on-vm-db-cdc.md

File metadata and controls

73 lines (47 loc) · 3.76 KB
title description author ms.author ms.topic ms.custom ms.date
Add SQL Server on VM DB (CDC) as source in Real-Time hub
This article describes how to add SQL Server on Virtual Machine (VM) Database (DB) Change Data Capture (CDC) as an event source in Fabric Real-Time hub.
ahartoon
anboisve
how-to
11/18/2024

Add SQL Server on VM DB (CDC) as source in Real-Time hub

This article describes how to add SQL Server on VM DB (CDC) as an event source in Fabric Real-Time hub.

The SQL Server on VM DB (CDC) source connector for Fabric eventstreams allows you to capture a snapshot of the current data in a SQL Server database on VM. The connector then monitors and records any future row-level changes to the data. Once these changes are captured in the eventstream, you can process this data in real-time and send it to various destinations for further processing or analysis.

Prerequisites

  • Access to a workspace in the Fabric capacity license mode (or) the Trial license mode with Contributor or higher permissions.
  • A running SQL Server on VM database.
  • Your SQL Server on VM database must be configured to allow public access.
  • Enable CDC in your SQL Server on VM database by running the stored procedure sys.sp_cdc_enable_db. For details, see Enable and disable change data capture.

Enable CDC in your SQL Server on VM database

  1. Enable CDC for the database.

    EXEC sys.sp_cdc_enable_db;

  2. Enable CDC for a table using a gating role option. In this example, MyTable is the name of the SQL table.

    EXEC sys.sp_cdc_enable_table 
   @source_schema = N'dbo', 
   @source_name   = N'MyTable', 
   @role_name     = NULL 
GO

    After the query executes successfully, you enabled CDC in your SQL Server on VM database.

Get events from SQL Server on VM DB (CDC)

You can get events from an SQL Server on VM DB (CDC) into Real-Time hub using the Data sources page.

[!INCLUDE launch-get-events-experience]

  1. On the Data sources page, select Database CDC category at the top, and then select Connect on the Azure SQL MI DB (CDC) tile.

    :::image type="content" source="./media/add-source-sql-server-on-vm-db-cdc/select-sql-server-on-vm-db-cdc.png" alt-text="Screenshot that shows the selection of SQL Server on VM DB (CDC) as the source type in the Data sources page." lightbox="./media/add-source-sql-server-on-vm-db-cdc/select-sql-server-on-vm-db-cdc.png" :::

    Use instructions from the Add SQL Server on VM DB CDC as a source section.

Add SQL Server on VM DB CDC as a source

[!INCLUDE sql-server-on-virtual-machine-cdc-source-connector]

View data stream details

  1. On the Review + connect page, if you select Open eventstream, the wizard opens the eventstream that it created for you with the selected SQL Server on VM DB (CDC) as a source. To close the wizard, select Close or X* in the top-right corner of the page.
  2. In Real-Time hub, select All data streams. To see the new data stream, refresh the All data streams page. For detailed steps, see View details of data streams in Fabric Real-Time hub.

Related content

To learn about consuming data streams, see the following articles: