

You can open a model in *.erwin or *.erwin_tmpl format, and a SQL DDL file in the format *.sql, *.ers, or *.ddl. Save As XML, ER1, and ERT is not supported. You can save your models in the native *.erwin format or as a template (*.erwin_tmpl).

To avoid problems, work with a database that has fewer than 25 tables. This may result in problems in the Complete Compare Resolve Differences dialog, where objects and properties between the models will not match. Note: If you are working with a database as part of the compare process, only the first 25 tables are reverse engineered to the model used during the compare. In addition, demand loading of databases and Alter Script generation are not supported. The "Finish" button is disabled in the Resolve Differences dialog. You can use Complete Compare features to evaluate and compare models, but you cannot commit changes you make in the Complete Compare wizard to the models you compare. For example, if you reverse engineer a DB2/LUW script that contains 25 tables and a materialized view, the temporary table used to create the materialized view will cause you to exceed the allowed table limit for the model. Note: Some operations that include the creation of temporary tables may also result in exceeding the allowed table limit.

For other databases, a warning message displays, stating that the import feature is disabled. For Oracle and SQL Server, the reverse engineer process stops after creating 25 tables in the new model. If you attempt to reverse engineer a script or database with more than 25 tables, or attempt to open a model with more than 25 tables, a warning message displays, reminding you of the object creation limitation in the Community Edition. There is no restriction on the number of views you can create. You can reverse-engineer, import using Metadata Integration (MITI) bridges, or create up to 25 entities/tables per model. Most of the basic features of CA ERwin Data Modeler are available, with limited access to the following features: 25 Entities/Tables Per Model The Community Edition of CA ERwin Data Modeler includes a limited number of features from the main product, and is designed to help Data Architects learn data modeling techniques, create simple data models, and learn about the design and maintenance of a production database. CA ERwin Data Modeler Editions › Community Edition
