MS SQL Server Agent for Gluesync: Key Features
Core principles
This agent establishes a connection to MS SQL Server via a built-in JDBC driver.
Change data capture
This agent implements the Change Data Capture (CDC), a set of APIs that put their foundations directly top of the SQL Server transaction logs making possible to get incremental changes from database version 2008 via the SQL Agent jobs, this CDC is compatible with Enterprise edition and Standard from 2022 onwards. This agent can work even if your tables do not have Primary Keys physically defined on tables, unlike the Change Tracking feature.