Appendix A: Configure CDC on SQL Server

This appendix describes how to configure CDC for SQL Server 2014 and later.

Configure CDC on SQL Server

If your SQL Server version is 2014 or later and SAP Data Services version is 4.2 SP9 or later, you can configure CDC to capture the changes in your source tables on a SQL Server database:

1. Run the following SQL statement in the database in which the source application tables exist:

EXECUTE sys.sp_cdc_enable_db;
GO

2. Run the following SQL statement for the source tables, such as F0901 and F0902 tables for JD Edwards EnterpriseOne, by modifying the parameters to create a unique change table for the respective application table.

EXEC sys.sp_cdc_enable_table
@source_schema = N'<SchemaName>',
@source_name = N'<TableName>',
@role_name = N'<RoleName>',
@supports_net_changes = 0
GO

For example, see the following:

EXEC sys.sp_cdc_enable_table
@source_schema = N'dbo',
@source_name = N'F0911',
@role_name = N'Magsw',
@supports_net_changes = 0
GO

After the SQL statement is run successfully, the CDC tables are created under the system tables in your source database containing application tables with the following naming convention: cdc.<SchemaName>_<TableName>_CT.