#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

Looking for recommendations for an online #training #platform #Dataversity #Udemy

I want to convert my existing software training courses into online training, which is straightforward enough (though it will take some time, as I’m picky about the quality of what I deliver). There are some obvious platforms I could use:

  • Dataversity – well-known to many of us in Information Management for their conferences and webinars, and they host online training as well
  • Udemy – hosts a multitude of training courses on a multitude of topics. They have a lot of very useful guidance for building courses

If anyone can recommend another platform, I’d be grateful. Here’s what I’d like it to do for me:

  • handle payments for me
  • support a subscription model
    • allowing someone access to all my training (or specified courses) for a period, perhaps a month, a year, or longer
  • allow customers to download resources, such as the model output from a session
  • quizzes
  • certification paths – e.g. do courses 1 to 4 and get a certificate
  • bundling multiple courses for a discount
  • support a mixture of technologies
    • PowerPoint
    • Videos

There’s probably some more, but that’ll do for now.

#PowerDesigner adds support for Amazon #Redshift

Late last year, SAP issued Service Pack 5 for PowerDesigner 16.6. From the list of new features, it’s obvious that SAP are putting a lot of focus on the web-editing capabilities of the tool. In this service pack, there are changes that affect process modellers, enterprise architects, requirements modellers, and data architects. I shan’t list them all here – see the note below for details of how to access them yourself.

I’m going to focus on what matters to data architects – the new support for Amazon Redshift. SAP have done the usual excellent job of enhancing the underlying database support in the Physical Data Model (PDM) in order to handle this DBMS. For example, they’ve added a new type of object, “External Schema”, and extended the properties available for Tables, Columns, Views, and Users. The latter includes recognising Schemas as a Stereotype of User.

For example, here’s the new ‘general’ tab for a column – I’ve highlighted some of the new properties for you.

Redshift column

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

 

click here for more