#PowerDesigner adds support for #SnowflakeDB

In the latest version of PowerDesigner (16.7), SAP have added support for Snowflake to the Physical Data Model. There isn’t space here to demonstrate everything they’ve provided so here’s a summary.

There are new properties for Tables, Columns, etc.:

SchemaNew Physical Options tab
UserNew Options and Object Properties tabs
TableNew Persistence property, plus Physical Options
ReferenceNew Options tab
ColumnNew Collation property, plus Physical Options

There’s a raft of new object types you can create:

  • File formats
  • Integrations
  • Managed Accounts
  • Network Policies
  • Notification Integrations
  • Pipes
  • Procedures
  • Resource Monitors
  • Sequences
  • Object Shares
  • Storage Integrations
  • Warehouses

To find out more about these new features, follow these two simple steps:

·        Search for PowerDesigner stuff on SAP.com – https://help.sap.com/viewer/p/SAP_POWERDESIGNER

·        click on the “New Features Summary” link

Work smarter with #PowerDesigner – How to display a ‘Relationships’ tab for entities

Data modelling tools vary in the kinds of dependencies that you can create between objects. For example, they all recognise that entities in a Conceptual or Logical Data Model (CDM or LDM) can participate in Relationships – when you view or edit the properties of an entity most (perhaps all) tools will show you a list of relationships as part of the dialogue. They might also show you other dependencies, such as a list of diagrams the entity appears on, a list of related tables in Physical Data Models, or some Data Lineage or other mappings. With most tools, that’s the limit. PowerDesigner goes beyond these basic modelling and development connections, allowing you to create several other different types of dependencies:

Shortcuts, Replications, Traceability Links, Related Diagrams, Extended Collections (extensions to the out-of-the-box capabilities)

One side-effect of this power and flexibility is the impact on the entity properties dialogue – most of these dependencies are all shown on the same tab. In the example below, the Contribution entity participates in four relationships, listed on a sub-tab; I can see that the entity also appears on at least one Diagram (indicated by the presence of the Diagrams sub-tab). There could be more sub-tabs, if the entity has other types of dependencies.

You might prefer to see relationships listed in a tab of their own. Well, with a little work, you can add that tab for yourself; you just need a simple model extension.

You create or use Model Extensions to change the way that PowerDesigner works, usually by adding additional metadata, or additional features such as imports, exports, and new object properties. In this example, we’re not adding a new feature, merely exposing some metadata that already exists – the Relationships collection.

Here’s what you need to do:

  • On the Model menu, select Extensions
  • Create a new entry in the list – just type the name – then click on OK
  • The new extension will appear in the Browser
extension in Browser
  • Double-click the extension to open it, then right-click Profile, and add the Entity metaclass to the extension
  • Add a new Form to the metaclass, call it Relationships
add form
  • Add the Relationships collection to the Form, then close the extension editor
  • Here’s the new tab

I’ve used this technique in other places as well, such as adding a Sub-Requirements tab to Requirements in a Requirements Model.