Description:
erwin Data Modeler includes an API that allows programmatic access to erwin Models. The erwin API provides a means to directly access all objects and properties within a model. Through the erwin API objects and properties may be created, edited and/or deleted.
The attached spreadsheet and sample models provide examples of the basic concepts involved in creating APIs. They perform specific tasks, but also serve as a tutorial and provide a framework for creating customized API applications.
Solution:
The attached files include an Excel spreadsheet with VBA examples to serve as a tutorial as well as sample eMovies models. Please make copies of the eMovies samples so that you can restore the original model after it has been modified through the API.
These examples require the presence of a fully-licensed installation of erwin Data Modeler r7. It should work with ERwin Data Modeler r8/r9, but that has not yet been tested. however, some metadata names were changed so the code will have to be modified accordingly.