2

We face a big time performance issue when we do a full sync or run the CDS project with all data for HCMWorker entity (Talent to FinOps), it even takes 16+ hours at times for just 600~ records We have tried following options: 1. Clear staging table before we run the sync 2. Tried using HCM base worker entity but that unfortunately doesn't have all the fields required. 3. Run it during off hours but being retail customer it's generally never off hours for us but only low traffic hours. 4. Forced query plan, but dealing with support team and convincing support and then DSE team is difficult and time consuming to do most of the times The issue appears to be mutiple joins in the enity data dources, which makes it difficult to analyse the query plan too. Moreover the related tables are base tables so you can't even add indexes from your side.

Category: Integrations
STATUS DETAILS
Declined
Ideas Administrator

Thank you for your suggestion. After careful consideration, we’ve decided not to proceed with this functionality at this time.After careful consideration, we’ve decided not to proceed with this functionality at this time. This posting is provided “as is” with no warranties, and confers no rights.