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

book

Article ID: 144708

calendar_today

Updated On:

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