Symptom
Smart Data INtegration requires that MSSQLLogReader Adapter User be assigned sysadmin privilleges.
Environment
-
SDI 1.x/2.x
-
All Supported Platforms
Reproducing the Issue
NA
Cause
- 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.
Resolution
This is by design
Keywords
KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem
Product
SAP SuccessFactors HCM Core 1811