![object explorer on erwin data modeler object explorer on erwin data modeler](https://bookshelf.erwin.com/bookshelf/public_html/2021R1/Content/Resources/Images/DVTableConvertedHub_538x373.png)
A generic ODBC driver is included to work with any database not readily supported. The Data Modeler supports Oracle, SQL Server, Sybase, DB2, AS/400 and many other legacy databases. Assuming table keys and relationships are not available when reverse-engineering a database, the tool will use indexes or names of fields to deduce table relationships. One of the most powerful features of ERwin 4.1 is its ability to infer table relationships. Filtering also can be based on the owners and users associated with the database. When performing a reverse-engineering operation, the tool can filter any object such as triggers, stored procedures and tables to build the model. The new UI also includes a model explorer, which groups tables and database elements in a Windows Explorer-like view and makes it easy to identify relationships.ĮRwin can easily reverse- and forward-engineer databases by creating logical and physical graphical models and by allowing instant bidirectional synchronization between the two.
![object explorer on erwin data modeler object explorer on erwin data modeler](https://www.softwaretestinghelp.com/wp-content/qa/uploads/2018/11/erwin.png)
Developers can color-code keys inside table diagrams for easy identification. The new version supports a full color palette to enhance any section of a graphical diagram. ERwin can also recreate models by reading script file dumps, providing users access to model information without using a live database.ĮRwin works with IDEF, information-engineering and dimensional-modeling methodologies. The types of models available to developers have also changed with the new version, allowing DBAs to work with logical models or physical models or both simultaneously. ERwin 4.1 provides version control through its model manager facilities. The new version is capable of handling access conflicts, providing impact analysis on any changes made to a model, restricting users from any section of a model through security settings, and tracking any changes made to a model. > COMPANY: Computer Associates International
![object explorer on erwin data modeler object explorer on erwin data modeler](https://images.visual-paradigm.com/docs/vp_user_guide/11/94/1288/1294/drag_from_model_explorer_and_drop_on_the_diagram_25269.png)
> DISTRIBUTORS/INTEGRATORS: Tech Data, Ingram Micro, Lifeboat > WARRANTY: 90 days if purchased through CA PRODUCT SNAPSHOT > NAME: AllFusion ERwin Data Modeler