|
|
|
The Query Tool provides an easy way to execute SQL SELECT queries against a model in CA ERwin Data Modeler, a model in a mart, 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 about using the ODBC data sources in CA ERwin Data Modeler with a third party tool, see the ODBC Reporting Guide.
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |