Symptom
Creating a Graphical view or SQL View with SuccessFactors as source system shows changing or inconsistent result set in Data Preview
Environment
SAP Datasphere
Reproducing the Issue
- Create a SuccessFactors connection
- Create a remote table
- Use the table in a Graphical View or SQL view
- Preview the data in the target object of the view and it shows changing data. This could happen for a single field or multiple fields based on the view created
Cause
Federated data access using the SuccessFactors ODATA connection uses client side pagination concept that cause inconsistent data retrieval
Resolution
Federated data in SuccessFactors uses client side pagination concept that cause inconsistent data retrieval. This is explained under SAP SuccessFactors Connection help page. As the documentation suggests it is important to replicate the data in to Datasphere to avoid data inconsistencies.
See Also
Keywords
Datasphere, SF, SuccessFactors, data, inconsistent, changing, Federated, ODATA , KBA , DS-MD-AM , Analytic Model , Problem