How do I call a CIS published procedure from a Microsoft Excel client?

Introduction

This document describes how Microsoft Excel client tool users can log in to Composite Data Services in order to see published views and procedures.

How do I call a CIS published procedure from a Microsoft Excel client?

Excel's view will only display the Composite published views (virtual "tables"). In order to expose the published procedures, open Microsoft Query from Excel. Query contains a "Procedures" button that exposes the published procedures in the Composite Data Service.

Complete these steps from Query:

1. Choose the File menu and click Execute SQL.
2. In the Execute SQL dialog box, click Procedures.

You will then see a list of the published procedures in that Cisco Information Server (CIS) source.