Forum Discussion

runemalo's avatar
runemalo
Frequent Visitor
9 years ago
Solved

Connecting to on-demand data

Hi,   I am trying to analyze data from C.A. Clarity PPM On-demand (cloud solution) in MS PowerBI. Is there any good solutions to create a connection between these? From my understanding, it would h...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi runemalo,

     

    I can't find any connector of CA both desktop and service side. Perhaps you can try to use Odata, ODBC, of Web mode to connect to CA api.(if it support these connect functions)

     

    Regards,

    Xiaoxin Sheng

VEEROCHET's avatar
VEEROCHET
Regular Visitor
9 years ago

Interested about any progress on this too... Anyone?

runemalo's avatar
runemalo
Frequent Visitor
9 years ago

Hi,

 

We decided to put this on hold, as apparently there is a direct connection in its way (it might actually already have been implemented in the last version from CA).

 

I would love to hear if anyone has any news on this topic!

  • svconclusivefla's avatar
    svconclusivefla
    New Member
    8 years ago

    I have this up and running with an Odata connection into CA PPM.  It links to a data wharehouse vs the real time system.  So far this has made our Clarity reporting so much easier.  

  • sylwestercz's avatar
    sylwestercz
    Helper I
    9 years ago

    Hi All,

     

    I am interested in CA PPM Power BI Connector as well. Please let me know if is already available. 

     

    Thank you.

    Sylwester

  • svconclusivefla's avatar
    svconclusivefla
    New Member
    8 years ago

    I have this up and running with an Odata connection into CA PPM.  It links to a data wharehouse vs the real time system.  So far this has made our Clarity reporting so much easier.  

  • ScottBrier's avatar
    ScottBrier
    Frequent Visitor
    8 years ago

    Are you grabbing all records from a given table and filtering/joining it in PBI, or are you actually sending queries - similar to those produced by Advanced Reporting - that return final data sets?