Request for Port Number of DWH DB in SaaS environment

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Hello - my report developer asked for following information: "Port # of the CA PPM Data Warehouse". We are not able to connect via odata because we are using the enterprise version of Power BI, so we are looking into building a custom interface to access the DWH. 

Environment

Release: CODFSS99000-15.4-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Resolution

We do not expose the port numbers of the underlying Oracle DB server hosts for the CA PPM DWH database in our SaaS environments. The only way you can connect directly to and query the DWH DB is using our v2 or v4 OData API or the JDBC connection in Jaspersoft Studio. We have seen customers connect to Power BI Enterprise using OData, but it's true that we only support Power BI Desktop edition. It's worth your effort to try and make that work.