Request for Port Number of DWH DB in SaaS environment

Document ID : KB000115938
Last Modified Date : 26/09/2018
Show Technical Document Details
Issue:
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. 
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.