The Query Tool provides an easy way to execute SQL SELECT queries against a model in CA ERwin Data Modeler or against a database catalog. You can execute a query against the objects and properties in the model, the metadata defining those objects and properties, and the action log that records the changes that are made to your model during the modeling session.
You can create new queries or paste text from another source (such as a *.sql file) into a query.
You can save a query to a .*qry file for later execution. Query results can be saved to a *.csv (comma-separated values) file.
Although the Query Tool provides a built-in query interface in CA ERwin Data Modeler, you can also use any third-party reporting tool that has ODBC capability to query CA ERwin Data Modeler modeling data.
Note: For more information on using CA ERwin Data Modeler's ODBC data sources with a third party tool, see the ODBC Reporting Guide, which is located in the Doc subdirectory of your CA ERwin Data Modeler installation.
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |