PowerBi and OData connection in GCP SSO

book

Article ID: 209886

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Wondering if we can use just one Clarity account for PowerBi and OData connection in SSO?

Environment

CLARITY SAAS OPERATIONS

Resolution

Please review the following Techdocs documentation prior to setting up a new Clarity account for access to the OData server.

Access OData Endpoints Using Clarity Credentials

Note: Users cannot access the Data Warehouse OData endpoints using their OD Portal login credentials or domain credentials in a Federated SSO environment. To allow access to the Data Warehouse OData Endpoint URL in these environments, complete the following steps:

1) Create specific report users in CA PPM SaaS.
You can re-use existing product users provided they do not have the External Authentication option checked in the resource properties under Administration. If the option is checked, create new report users.

2) Set up a password for these users in CA PPM SaaS so that they can use it for accessing the Data Warehouse OData Endpoints.