Here are the slides from my 2-hour #PowerDesigner presentation to the UK SAP Database & Technology User Group (UKSUG) today

This was an opportunity I could not miss – a 2-hour presentation on modelling to an audience of database experts!
Starting with a brief look at using Visio and/or Excel for data modelling and governance, I talked about the extras we can gain by using PowerDesigner to design databases.
Of course, it’s not ‘just’ databases we’re concerned with, the relationships those databases have with our business and technical architecture is also important.
The next key topic is the role of Data Models and others (such as the Requirements model) in Governance and Design.
Next it’s mapping data sources and targets to demonstrate and create data lineage, showing how PowerDesigner supports multiple DBMS Versions (and what you can do to change how it does that), creating a CUBE for Business Objects, finally (almost) focusing on the support provided for SAP IQ.
Finally, I described some real-world uses of PowerDesigner.

I’m looking forward to my 2 hours talking to UKSUG about #PowerDesigner next week

Discover the history and key capabilities of SAP PowerDesigner (it’s more than just a data modelling tool), and how it can make life easier for you in Data Governance and Database Development.
This session will show you why you must not use Excel or Visio for data modelling, and find out just how easy it is to get started with PowerDesigner.
Also discover the hidden power of PowerDesigner’s unique customisation capabilities, such as automating the creation of audit tables.

Wednesday June 10th, from 13:00 to 15:00 British Summer Time

(12:00 to 14:00 GMT)

To register, contact Laura Goss
uksug@pbprojects.co.uk

#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

If you want #PowerDesigner to provide support for MongoDB as well as JSON

The SAP PowerDesigner Product Group is considering a request (CR 742011) to provide direct support for MongoDB in PowerDesigner.

If this is something you’re really looking forward to to, follow this link to the Knowledge Base article – https://launchpad.support.sap.com/#/notes/1877090 – now click the star in the top-left corner to mark it as a Favourite to be automatically notified when the enhancement is implemented. Marking it as a favourite also acts as a kind of unofficial opinion poll.