Previous Topic: Introduction

Next Topic: ODBC Data Sources

Query Tool

Any ODBC-compliant tool can be used to communicate with this component, such as a banded report writer, spreadsheet program, or ad hoc query tool. This includes Business Objects™ Crystal Reports® 2008, which is installed with CA ERwin DM. You also can use the built-in query tool with CA ERwin DM. To launch it, click Query Tool on the Tools menu.

The following illustration demonstrates how CA ERwin DM's Query Tool reports against CA ERwin DM:

ODBC Query Tool ERwin ODBC

The following illustration demonstrates how Crystal Reports 2008 reports against CA ERwin DM:

ODBC Crystal Reports Example

The following illustration demonstrates how Microsoft® Office Excel® reports against CA ERwin DM:

ODBC Example using MS Excel 2007