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 have been simple if the data was on-premise, using MS SQL server, however, I have not seen a solution to how to pull on-demand data in to PowerBI? Do I need to create a webservice? How is this done?

 

Thank you for your help,

 

Rune

  • 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

11 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi runemalo,

     

    I'm not very clear the "C.A which you mentioned, can you share some detail content of your requirement?

     

    Regards,

    Xiaoxin sheng

    • runemalo's avatar
      runemalo
      Frequent Visitor
      9 years ago

      Hi Anonymous ,

       

      Thank you for your response. C.A. refers to CA Technologies, https://www.ca.com/us.html , and their on-demand cloud solution for Project Portfolio Management (PPM).

       

      Best regards,

       

      Rune

      • Anonymous's avatar
        Anonymous
        Not applicable
        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