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 Data Modeler 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/LUW 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 watermark.
You can work with transformations in CA ERwin Data Modeler Community Edition to implement design decisions, such as partitioning tables. However, because of the limitation to twenty-five entities/tables per model, some transformation 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 transformation operation will not complete.
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 Community Edition imports only the first twenty-five tables.
Other limitations of the Community Edition include the following:
Note: 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 core online help files, but restricts access to the PDF guides for the product. To access and download these guides, go to the CA ERwin Data Modeler support page. To open or download PDF files, enter your user name and password to access the site.
The available PDF guides for this product are:
The following documents in the Technical Documentation Series are also provided:
To view PDF files, you must download and install the Adobe Reader from the Adobe website if it is not already installed on your computer.
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |