The Query Tool
Erwin Tool Videos
The Query Tool provides a convenient way to execute SQL SELECT queries against a model in erwin Data Modeler (DM), 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.
Successful import depends upon the erwin API connecting to the mart server. The erwin libraries used are EAL.dll and ERXML.dll. Starting with Erwin Data Modeler 9.8 / 2021 R1, Erwin requires the user to re-confirm the license in the UI if the tool has not been used for more than 72 hours. Erwin Data Modeler, Mart & Web Portal Technical Support Portal The custom mart reporting has changed in 21R1. Article created 2 months ago. Erwin Data Modeler, Mart & Web Portal Technical Support Portal AdoptOpenJDK Is being targeted as a vulnerability. CA ERwin Data Modeler (or ERwin for short) is a data modeling and database design tool that is used to create conceptual, logical, and physical data models. ERwin can create the actual database from the physical model, and create different physical implementations from a single logical model. ERwin can also reverse-engineer existing.
Irwin Tools
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 erwin DM, you can also use any third-party reporting tool that has ODBC capability to query erwin DM modeling data.
For more information on using ODBC data sources and sample queries, refer to the How to Generate or View Reports and Useful Queries topics respectively.
Erwin Tool Sets
More information: