erwin DM R14 – Importing objects into erwin DM models from Excel
Methods and attributes erwin model
There are several methods to import attributes and entities from Excel into an erwin model. The choice depends on the format of the data and how you plan to integrate it: create a new model from Excel or use it to automate modelling?
The mass editor, known to many, allows exporting results to an editable CSV file in Excel and importing the updated objects into the original model. However, it only updates existing objects, it does not create new ones.
To add objects and update attributes in a model, you can use external scripts with the erwin DM API instead of the Data Modeller tools. With VBA macros in Excel, it is possible to create a script that processes any data format to modify or add objects in new or existing models.
Rather than update an existing model, the third and fourth models both create a new model completely, either by using the built-in MITI import bridge where each Excel sheet represents a table, or indirectly using Excel functions. Through the use of functions built into Excel, a list of entities and attribute definitions is formatted into an oracle DDL script, which can then be reverse engineered as a standard SQL file. Which method you use will depend on the format of the source data.
erwin Data Modeler
erwin Data Modeler is the industry-leading data modelling solution that enables organisations to discover, design, visualise, standardise and deploy enterprise data through an intuitive, graphical facility built on industry standards and best practices.
