Posts Tagged ‘PowerDesigner’

PowerDesigner Tips – Model Patterns

Data model patterns identify common model structures and define how they should look and interact with other parts of the model.  PowerDesigner can assist in this process by automating the setup of objects (tables, columns, mappings) based on the pattern to be applied and ensuring consistency through the use of custom model checks. Stereotypes Anyone […]

PowerDesigner Tips – Deploying a Model

In its most basic form, deploying a data model means simply applying the model directly to a database via ODBC or a DDL script.  But that neglects much of that value in your model beyond the physical structure. Here are the steps in our model deployment process.  We’ve scripted these in the build tool, but […]

PowerDesigner Tips – Utility Scripts

Here’s a few utility scripts I’ve developed to aid in your XEM scripting: Scope Many functions, especially members of ExtensibleObject, require the “scope” or code of the XEM be included when referencing extended attributes, methods, collections, etc.  I’ve added these lines to the global script section as a helper: ‘ Extension navigation. All references to […]

PowerDesigner Tips – Exporting Model Metadata

Once you’ve invested the time and effort into creating really solid, well documented data models, it would be really great to let some folks know about it, right!?!? If you’re using PowerDesigner, you’ve got a few options: Use the included (in some editions) web repository.  This requires the use of the model repository and displays […]

PowerDesigner Tips – Mappings in the Model

We’re constantly looking for ways to streamline the BI development process.  Data mapping (source to target) can be a complex and cumbersome process due to: Ongoing model changes – the target moves! Poor (or “loose”) communication between those mapping and the development team. Lack of consistency in collecting and documenting mappings (Excel, I’m looking at […]

PowerDesigner Tips – Column Ordering

In our standards XEM file (extended model definition), I’ve added column ordering functionality by categorizing each column and then ordering the categories. Column groups are defined in a BaseColumn template.  We have:   PRIM,0,%Primary% ROWMETA,3,%extIsRowDateMeta% META,4,%extIsMetaColumn% AKNONMETA,1,%AllKeys% BASE,2,TRUE  

PowerDesigner Table Object Hierarchy

PowerDesigner – Standards in Action

I love PowerDesigner.  It’s the Cadillac (Mercedes, BMW, etc.) of the modeling tools.  I love that I can do conceptual, logical, and physical data modeling.  I can do business process modeling with direct linkage to my data models.  And I can model mappings between everything for both data flow relationships (ETL mappings) and design flow […]