In order to configure MS SQL Server Database select “MS SQL Server” under “Database Type”and enable “Source” or “Target” or both flags under “Database”:
The following parameters should be provided:
Server– Host name or IP address of the database server
Port– Database port number
DB– Database name to be connected to
Username– Database User name
Password– Database User password
Housekeeping – This parameter determines how the CDC data will be cleaned up. The possible values are:
0 – data will be cleaned up by an SQL Server job only,
1 – install Repstance job to clean up data only after extraction and keep SQL Server cleanup job, which is a time based CDC setting,
2 – install Repstance job and remove SQL Server cleanup job, data will be cleaned up only by the Repstance job.