This video demonstrates how to create a logical data model with all object names in mixed case (This Is Mixed Or Initial Case) from a reverse-engineered physical model where all names are in “camel case” (ThisIsCamelCase) using erwin Data Modeler.
In doing this, it highlights a number of features of erwin Data Modeler, including the Bulk Editor, Naming Standards Model and Design Layers.
- Open your physical model
- Export a list of table and column names to a .csv file
- Open the csv file in Excel, add a column of names with spaces added in the appropriate places and save
- Back in erwin, open the Naming Standards Editor, import the .csv file into the glossary and save the .nsm file
- Use the new .nsm file when deriving a new logical model from the physical
What I did
We used the following features of erwin Data Modeler
- The Bulk Editor to export a list of table and column names to a .csv file
- A Naming Standards Model to define the translation of physical to logical names
- Design Layers to derive a logical model from a physical model
I also used
- A user-defined function in Microsoft Excel to generate the mixed case versions of the camel case names