How to import data into excel using CA Performance Management OpenAPI odata URL

Article Id: 144708

Status: Published

Updated On: 23-06-2020 15:15

Products:

CA Infrastructure Management , CA Performance Management - Usage and Administration , DX NetOps

Issue/Introduction:

I want to import data from CA Performance Management Odata API into Excel

Cause:

Analyze data from CA Performance management in Excel

Environment:

Release : 3.7

Component : IM Reporting / Admin / Configuration

Resolution:

The following are the steps to Import CA Performance Management Data into Microsoft Excel.

a) Open excel - > Click on Data -> From other Sources ->

b) Provide the OpenAPI Odata URL

C) Click on Load