Clarity

How to connect to CA PPM 15.2 Live in Sandbox using Jaspersoft Studio. Please forward if anyone has documented it to rshrinet@yahoo.com. 

I don't think all the ports required to make a JDBC connection would be open there..

Hi Ratnesh,

I don't have access to sandbox, however if you can share the detail below PPM URL with credentials, I can test and let you know. 

All you need to do to connect to studio is 

1. Create an user under Advance Reporting 

2. Grant him the Role_administrator right

Regards

Suman Pramanik 

I am looking to connect to the following environment .

https://cppm1109-test.ondemand.ca.com/niku/nu#action:npt.overview

uid - rshrinet
pwd - Karoti64 - Last logged in 4/11/2016

Hi Ratnesh,

Couple of things were missed 

1. Advance Reporting rights were not granted to user rshrinet, I have granted the same and run the Job " Create Jaspersoft User" 

2. Create a user in Advance Reporting to ensure you can login to studio

3. The user name is UID :rshrinet_reportdev PWD: rshrinet_reportdev

4. Download the Jaspersoft studio and connect now 

Docs: Create and Publish Jaspersoft Studio Reports - CA PPM - 15.2 - CA Technologies Documentation 

I connected the same and it works now 

Regards
Suman Pramanik