Previous Topic: Execute a Query Against a Database

Next Topic: Use Crystal Reports With CA ERwin Data Modeler

Report on Your Data Model › The Query Tool › Execute a Query Against ERwin ODBC

Execute a Query Against ERwin ODBC

To run a query against the current CA ERwin Data Modeler model, you must first activate the ODBC connection. The connection may already be active, if you selected the option to start the ODBC driver on the Integrations tab in the Options dialog.

To connect to ERwin ODBC

  1. Click Query Tool on the Tools menu.

    The Query Tool opens.

  2. Open a query (*.qry or *.sql) file or create a new query.

    Query text displays in the Query box and is ready for execution.

  3. Click the Connect to ERwin ODBC ODBC_Connect_ODBC icon on the toolbar.

    The ODBC connection is established. The Disconnect ODBC_Disconnect icon becomes active. Use other features in the Query Tool to execute and save the query and result set.

More information:

The Query Tool

Execute a Query