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
Find out more

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.

Read more
A9Roowwxa cp3jx4 ilg 1