Reports › 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 icon on the toolbar.

   The ODBC connection is established. The 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

Change the Instance of an ODBC Connection