Introduction
This document describes why the use of Microsoft Excel in to connect to the Cisco Information Server (CIS) via Open Database Connectivity (ODBC) makes all tables from all catalogs visible even though the Data Source Name (DSN) created in the ODBC administrator has catalog filter specified. This article also explains why some CIS published objects such as Parameterized queries are not visible in the Excel client.
DSN created Excel Connectivity is present with the use of the composite 6.2 driver and 32-bit ODBC Administrator. Why do all tables from all catalogs appear in the Data Connection Wizard?
This is a result of a limitation in Excel's Data Connection Wizard. If you choose Data > Get External Data From Other Source > From Microsoft Query, only tables in the catalog that are selected in the DSN in the ODBC driver manager display.
Why do only published tables display in the Excel client while other CIS objects like Parameterized queries do not display?
Parameterized queries do not display due to a limitation of the client such as Data > Get External Data from Other Sources > From Data Connection Wizard or Data > Get External Data from Other Sources > From Microsoft Query. When you use Squirrel or DB Visualizer in order to connect to CIS via JDBC ODBC bridge, the CIS parameterized queries are visible.
Microsoft Query only has options available to query for tables, views, system tables, and synonyms. Microsoft Query does not allow you to select queries. These issues are a limitation of the client application and not the CIS ODBC driver.
Feedback