Microsoft SQL Server CDC Function
SQL Server writes all changes to the user tables marked for this purpose to special CDC tables during operation - if configured accordingly.
The process reads this data directly and interprets the change entries.
- Data source: All defined data sources for the type Microsoft SQL Server
are displayed in the list. A new reference can be created by selecting the line
‘new Data Source…’ in the list without leaving the process definition. The
button
shows the
properties of a selected data source. - Source agent: The agent used for the input part of the process is the one specified for the selected input source.
- Beginning of the replication (LSN): Select from the available options.
- Manual specification of LSN: Defines the (re)start of data retrieval
when starting the process. The LSN defines the desired starting point of the
processing when reading the SQL Server CDC.
If this process has already been executed and status information has been written, processing will automatically continue at the correct position in the SQL Server CDC, otherwise an LSN can be defined manually.
If no status information and no explicit start LSN is defined, the CDC data capture is started at the time of the process start. - Clicking the button
displays stored status information. The button 
deletes currently stored status
information.
The definitions for processing data from SQL Server CDC are described in Processing Options of Data from Active Logs/Realtime CDC.