Spanish English German Portuguese
Spanish English German Portuguese

Sql Server Cdc Source V2 Connector

Sql Server Cdc Source V2 Connector

att_0_for_1847984546.png

Connector to integrate into GlobalSuite records, tables, collections, and data changes from Sql Server Cdc.

Tags: Integration | Source | CDC | Databases | Cloud

Tool or system

Sql Server Cdc

Tool manufacturer

Microsoft

Connector provider

Confluent Cloud

Connector name

Sql Server Cdc Source V2 Connector

Connector type

Source

Tags

Integration | Source | CDC | Databases | Cloud

Information it handles

records, tables, collections, and data changes

Details

The Sql Server Cdc Source V2 Connector allows integrating into GlobalSuite information from Sql Server Cdc related to records, tables, collections, and data changes.

It is designed to keep management processes, evidence, and indicators updated without relying on manual uploads, especially in scenarios of catalog synchronization, change auditing, regulatory reporting, and elimination of manual uploads.

Features

  • Configurable integration of records, tables, collections, and data changes from Sql Server Cdc into GlobalSuite processes.

  • Selection of tables, collections, views, or fields to synchronize only information with functional value.

  • Support for additions, modifications, and deletions when the source or target system allows it.

  • Mapping of keys, fields, and entities to maintain consistency with corporate catalogs and inventories.

  • Traceability of changes and results for auditing, reconciliation, and data quality control.

Key benefits

  • Keeps catalogs, inventories, and critical records synchronized with less manual intervention.

  • Reduces errors due to duplication or misalignment between databases and GlobalSuite processes.

  • Facilitates change auditing, information reconciliation, and regulatory reporting.

  • Allows incorporating operational information into the GRC flow without waiting for specific exports.

  • Improves data quality by working with structured sources and defined mapping rules.

Installation

Configuration note: Before activating the integration, validate credentials, permissions, functional scope, and a data test with the responsible area.

  1. Access the GlobalSuite® Marketplace and select Sql Server Cdc Source V2 Connector.

  2. Configure the connection with Sql Server Cdc: URL or endpoint, credentials, permissions, and environment.

  3. Define the functional scope of synchronization: records, tables, collections, and data changes, filters, and frequency.

  4. Map the received fields with the corresponding entities, evidence, or processes in GlobalSuite.

  5. Run a test, review the synchronized records, and activate the integration.

More information

https://debezium.io/documentation/

Use this connector when you need to integrate information from Sql Server Cdc into GlobalSuite processes, for example, for catalog synchronization, change auditing, regulatory reporting, and eliminating manual uploads. Before publishing it, agree with the owning area on what data is needed, how frequently it should be updated, and who will review the results.