CA PPM OData Refresh Job

book

Article ID: 141475

calendar_today

Updated On:

Products

STARTER PACK-CLARITY PPM Clarity PPM SaaS

Issue/Introduction

Refresh Data Warehouse OData Model Job

Environment

Release : 15.3, 15.4, 15.5, 15.6, 15.7

Component : CA PPM SAAS OPERATIONS ODATA

Resolution

(SaaS only) Refresh Data Warehouse OData Model Job


This job exposes OData entities for the objects that are enabled for the Data Warehouse as part of the Load Data Warehouse job. For example, if you enable a new custom object for the Data Warehouse, the job creates a OData model for the object so that you can access the object as an OData entity. Clarity PPM SaaS customers can run this job to refresh the data warehouse OData model for entities added or removed as part of the Load Data Warehouse job. Users can then write queries and run reports against the OData entities using a reporting solution such as Microsoft Power BI.
Restrictions


Before running this job, verify that the data warehouse read-only user has access to the tables and views in the data warehouse schema.
The job is incompatible with the Load Data Warehouse job. Run the job after the Load Data Warehouse job executes successful