DX NetOps

 View Only
Expand all | Collapse all

Integrating the CAPM OpenAPI with Tableau

  • 1.  Integrating the CAPM OpenAPI with Tableau

    Posted Oct 06, 2016 08:29 PM

    I know a few people have asked about how to integrate CAPM's OpenAPI with Tableau for reporting. There are a few things needed in order to make this work but the first thing is to make sure there are no firewalls blocking access. If that's all clear you can try this out and you should get a list of columns to select for building reports.

     

    NOTE: One critical item is that you have to make sure the query return format is set to atom

     

    From the CAPM 2.8 documentation:

    https://docops.ca.com/ca-performance-management/2-8/en/using/openapi/openapi-applications

    This sample query can be leveraged:

    (you'll need your CAPC user credentials and you'll use the PC for the query. The default port is 8181)

    http://PC_host:port/pc/odata/api/interfaces?$format=atom
    The Tableau documentation that I referenced can be found here:
    Have fun and if you create some awesome content please post some examples.
    Thanks,


  • 2.  Re: Integrating the CAPM OpenAPI with Tableau

    Posted Oct 07, 2016 11:49 AM

    What about odbc?  Or some Splunk add-on?