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.

Please vote for your favourite data modelling tool, whatever it is #PowerDesigner #ERwin #Idera #ERStudio

The people at ERwin pay a lot more attention than some other vendors do to promoting their product, including asking their users to vote for them in various polls or awards. Currently they’re asking their users to vote for ERwin in the “Readers’ Choice Awards” for Database Trends and Applications.

The following data modelling tools are listed in the poll –
PremiumSoft Navicat Data Modeler, Dell Toad Data Modeler, IDERA ER/Studio, ERwin, TimeXtender, SAP PowerDesigner.

That’s an interesting selection of tools, partly due to the absence of any tool from IBM, and also because there are two I’ve barely even heard of.

Voting closes on May 20th, so make sure to vote for your favourite modelling tool, whatever it is. My message is the same as it is to every registered voter in the UK today (lots of elections on in the UK today) – cast your vote and be heard!

Go to http://www.dbta.com/ReadersChoice/2016/Vote.aspx