Smart Data INtegration requires that MSSQLLogReader Adapter User be assigned sysadmin privilleges.
All Supported Platforms
Reproducing the Issue
- The Role ‘sysadmin’ is always checked during LogReader initialization, without it, QUEUE will fail.
- Even with “Database Data Capture Mode” set to “MSCDC”, Role Sysadmin must be granted because LogReader call MSSQL system procedure sys.sp_cdc_enable_db
- to enable data capture. Without sysadm we will hit error related to authorization.
This is by design
KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem
SAP SuccessFactors HCM Core 1811