ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Can SSRS be connected to PPM SaaS ODATA

book

Article ID: 111131

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction



Can SSRS be connected to PPM SaaS ODATA?

Environment

Release:
Component: ODDWH

Resolution

Based on Microsoft documentation for SSRS XML connections (which is what ODATA requires) found here:  https://docs.microsoft.com/en-us/sql/reporting-services/report-data/xml-connection-type-ssrs?view=sql-server-2017#Credentials, it shows that XML connections in SSRS require the use of domain authentication and do not support specified credentials or prompting for credentials.