Accessing OData Endpoints in Clarity SaaS Environment
searchcancel
Accessing OData Endpoints in Clarity SaaS Environment
book
Article ID: 185945
calendar_today
Updated On: 08-16-2024
Products
Clarity PPM SaaS
Issue/Introduction
This article shows how to set up and use a Clarity user to connect to the OData endpoints to access the DWH database in the SaaS environment
Environment
Release : All Supported
Resolution
Go to Administration > General Settings > Data Warehouse OData Service
Obtain the V4 Endpoint URL. The URL format is https://%report_host%.ondemand.ca.com/api/odata4/SCHEMAxDataSourceV4
Here is a break down of the two Endpoint URLs you see:
Data Warehouse OData v2 EndPoint URL - Defines the OData URL for the Clarity PPM 15.4 or newer instance which exposes the data warehouse to the customer. Use this URL for external authentication with OData v2. Example: http://<host:port>/api/odata/ppm_hdp_datasource_v2
Data Warehouse OData v4 EndPoint URL - Defines the OData URL for the Clarity PPM 15.4 or newer instance which exposes the data warehouse to the customer. Use this URL for external authentication with OData v4. Example: http://<host:port>/api/odata4/ppm_hdp_datasource_v4
Obtain the OData Authenticator. The format is in SCHEMAxDWHHDP
Go to Administration > Resources
Filter for a resource that does not have 'External Authentication' checkmarked.
Obtain the resource username.
Open a browser and enter in the following fields:
Endpoint URL
Username
Password
Here is an example of how to enter the user name:
If the username is: testuser@example.com then the username to enter would be: testuser@example.com|SCHEMAxDWHHDP
Once the credentials are validated, the DWH metadata will appear.