Convert CamelCaseNames to Mixed Case Names

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.

Steps involved

  • 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

Leave a Reply

Your email address will not be published. Required fields are marked *