List of metadata fields that are synchronized in real time by the DWH job

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Could you please capture and share the list of metadata fields that are synchronized in real time by the DWH job? 

Resolution

Synchronized in near real time:

- Schema changes — adding, modifying, deactivating, or deleting objects/attributes (both OOTB and custom) in Classic Studio

- Object inclusion/exclusion — enabling or disabling an object/attribute for the Data Warehouse

- Historical backfill — when an object/attribute is newly enabled, existing values are backfilled automatically

- Instance data — insert/update/delete on object instances, from both Clarity (Modern UX) and Classic PPM

- Changes made in ODF

- Some XOG/REST updates — most objects, with exceptions noted below

- Timesheet Posting job — timesheet status updates (but not assignment-level data)

- Time Slicing / Timeslice Sync — SQL Curves, per-period TSV metrics, resource availability, total usage

- SQL Curve tables — if the "Include SQL Curve Data" option is enabled