Previous Topic: Execute a Query Against a DatabaseNext Topic: Change the Instance of an ODBC Connection


Execute a Query Against erwin ODBC

To run a query against the current 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 Reporting 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 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:

Change the Instance of an ODBC Connection