The Community Edition of CA ERwin Data Modeler includes a limited number of features from the main product, and is designed for learning data modeling techniques, creating simple data models, and learning about the design and maintenance of a production database.
Most of the basic features of CA ERwin DM are available, with limited access to the following features:
You can reverse-engineer, import using Metadata Integration (MITI) bridges, or create up to twenty-five entities/tables per model. There is no restriction on the number of views you can create.
If you attempt to reverse engineer a script or database with more than twenty-five tables, or attempt to open a model with more than twenty-five tables, a warning message displays, reminding you of the object creation limitation in the Community Edition. For Oracle and SQL Server, the reverse engineer process stops after creating twenty-five tables in the new model. For other databases, a warning message displays, stating that the import feature is disabled.
Note: Some operations that include the creation of temporary tables may also result in exceeding the allowed table limit. For example, if you reverse engineer a DB2/UDB script that contains twenty-five 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.
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. The "Finish" button is disabled in the Resolve Differences dialog. In addition, demand loading of databases and Alter Script generation are not supported.
Note: If you are working with a database as part of the compare process, note that only the first twenty-five tables are reverse engineered to the model used during the compare. This may result in problems in the Complete Compare Resolve Differences dialog, where objects and properties between the models will not match. To avoid problems, work with a database that has fewer than twenty-five tables.
You can save your models in the native *.erwin format or as a template (*.erwin_tmpl). Save As XML, ER1, and ERT is not supported.
You can open a model in *.erwin or *.erwin_tmpl format, and a SQL DDL file in the format *.sql, *.ers, or *.ddl.
Support for printing models is included in the Community Edition, although the output includes a unique watermark.
You can work with Transforms in CA ERwin Data Modeler Community Edition to implement design decisions, such as denormalizing and partitioning tables. However, because of the limitation to twenty-five entities/tables per model, some Transform operations may not be possible. For example, if you are near the limit of twenty-five tables and choose to partition a table, you may surpass the table limit, and the transform operation will not complete. The same is true for Transform actions that create temporary tables, such as toggling the display between the source and target objects.
The Advisories Pane on the main workplace window reports a message reminding you that the intended action did not complete because of the object creation limit.
Support is included for modeling using the following databases:
Support is limited to the following Metadata Integration (MITI) Bridges for import. Export using Metadata Integration (MITI) Bridges is not supported.
Note: If the file you import has more than twenty-five tables, the ERwin DM Community Edition imports only the first twenty-five tables.
Other limitations of the Community Edition include the following:
Note that if you attempt to access a disabled feature in the Community Edition, a pop-up message appears to remind you the feature is not available.
The Community Edition includes the main online help file (ERWIN.CHM) but User Guides in PDF format are not installed. You can access the PDF User Guides from the CA ERwin DM Product Page on support.ca.com after you create a user name and password to access the site.
| Copyright © 2009 CA. All rights reserved. | Email CA about this topic |