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

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