I have engaged with a number of customers recently starting out with PowerDesigner. In more than one case the customer acquired PowerDesigner as part of a larger solution such a Data Services Enterprise Edition or Intelligent Business Operations. As a consequence the customers had not investigated PowerDesigner and were unsure of how to get started. Nevertheless the idea of using Power Designer for Enterprise Architecture, Data Modelling or Business Process Modelling was attractive and from there I had a number of discussions on next steps. This blog outlines four key things needed to get started. 

Infrastructure

Obtaining a Server

As PowerDesigner is installed on a desktop sytems this step is often overlooked. In practice a lot of the value of PowerDesigner is associated with having a central repository available and for enterprise deployments this is esstential. As a consequence it pays to initiate the process of obtaining a server early in your PowerDesigner project. I recommend using a single Windows based server. This simplifies the initial deployment and can be reviewed later if needed. The minimum recommended system in the manual is a dual-core machine, with 2-4GB of RAM. I suggest doubling this – 4 cores and 8 GB RAM.  My reasoning is that it is most effective to install all the server components on one system as part of the initial setup.


Obtain a License Key

License keys are obtained via the SAP Support Portal . To access the keys on the portal you will need a login (often called an s-user). Typically the SAP team in many organisations already have these logins; it is possible to create additional users if needed. The Getting Started page provides the instructions for administration of users.

The process for creating a PowerDesigner key is described in the How to Request License Keys – SAP Sybase document. The recommended approach is to use a central license management (sysam) system to provide served licenses. This has two advantages:

  1. 1. There is only one license key file created which reduces the administration overhead.
  2. 2. Users can access the license from any machine when on-line. License can be “checked out” for off-line use through the “obtain mobile license” feature.

Important: The license key is linked to the MAC address of the server. So obtaining the server is a prerequisite to generating the license key.

Install

The installation processes documented on the Help Portal. Installation involves a number of components including:

  • Repository
  • SySAM
  • Web Server
    • node.js server
  • repository proxy

The diagram below illustrates all of the components.

/wp-content/uploads/2015/08/pd_765200.png

My recommendation is to install in the following sequence:

  • Install sysam and the license key – this makes the PowerDesigner client available.
  • Install the repository database. This can be the SQLAnywhere database supplied with PowerDesigner or MS SQL Server /  DB2 / ASE. Whatever database is selected it is important to ensure that the database is correctly licensed and backed up. The installation guide provides a sizing formula based on the size of the models and frequency of update. This is often difficult to determine before starting and it is often more practical to simply use a 50 GB database to get started.
  • Install a PowerDesigner client system with the ODBC drivers for the repository database.
  • Create the repository database structures – this requires connecting the client to the database directly.
  • Install the Web Portal and node.js service.
  • Install the Repository proxy.
  • Create a file share on the server with the version of PowerDesigner – including all service packs downloaded for installation. For most organisations this is adequate to ensure a standard installation during startup. The installation documentation provides information on automated (silent) installs for larger deployments.
  • Install clients as required.

Training

PowerDesigner looks simple enough but to get started it really pays get trained. I attended the Data Modelling course nearly ten years ago but it still pays off in productivity every time I create a model. SAP offer the following courses:

Take a serious look at the Virtual Live Classroom delivery option.

If you prefer the self study route there are many resources including:

Pilot

There is no substitute for a practical experiment to understand where and why PowerDesigner will benefit your efforts. Select a pilot project and get started. A few ideas I recommend that customers focus on in the pilot include:

  • Keep the scope as small as possible. This makes sense for any pilot but particularly true for a modelling tool – where the output can be abstract – a smaller scope means it’s easier to show results early.
  • Remember the second of Steven Covey’s seven habits “Begin with the end in mind.” In the case of PowerDesigner this means figuring out what will the output be, who will consume the output and how will it be delivered. This might sound obvious but it’s easy to start modelling and then later find out that it’s harder to produce the output than expected.
  • Ask the question posed by George Box “Remember that all models are wrong; the practical question is how wrong they have to be to not be useful?” In this regard it’s key to establish early on how much detail your models will require to be useful. Too much detail extend the project and delays value, too little detail renders the model useless. The best time to find this out is on a small scale pilot.

Standards

It’s not a subject that this blog can cover comprehensively but once the pilot is done it is essential to pause and look at standards and structures. At the minimum the standards should include:

  • Repository structure and administration
    • Folders, projects and permissions
    • Roles and responsibilities
    • Portal and client access
    • Versioning
  • Modelling Standards
    • Types of models to be used
    • Scope of models
    • Notation and other standard internal to models identified

If you read this far I’m assuming you are looking at starting and implementation. Good luck and please let the community have some feedback.

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

  1. George McGeachie

    Nice post, Peter.

    As well as the technicalities you’ve described, any organisation implementing a complex package like PD needs to work out what they expect it to do for them before going too far down the implementation path. That means requirements, process and data models, possibly even enterprise architecture models. We need to make sure we’re as rigorous in our use of models as the organisation we’re supporting with PD – ‘eating our own dog food’ as some say.

    Describing the modelling processes will help us decide when and how to configure the tool, and what automation we need to build. PD is a very powerful, flexible tool; if you charge into implementation too fast you can cause problems in the future.

    By the way, thanks for plugging my book for me 🙂

    (0) 
  2. Paul Meaden

    Hi Peter,

    I’m trying to create a case for a Powerdesigner in my company’s SAP architect practice. How can I get a view of the license cost per-seat?

    thanks

    Paul

    (0) 
    1. George McGeachie

      I’m sure the list prices are on the SAP web site, though your SAP sales contact might be able to offer you a better deal if you’re already a customer. When you look at prices, remember that they’re for concurrent licences, not named users – if you’re spread across several time zones, this could save you a lot of money.

      (0) 
    2. Benoit Le Nabec

      Hi,

      For our clients, as rule of thumb we calculate1.3 users by1 concurrent licence because all users are not connected at the same time. It do not just modeling in a day!

      Another way to determine this ratio is to do a survey of the future users of PowerDesigner.DBA, Solution Architect, Data Architect, Enterprise Architect, etc.

      Hope this can help you for you case!

      Bye

      (0) 
    3. Peter Blignaut Post author

      Paul, It is really best to check with you local SAP sales representative. The advice from George and Benoit is very relevant if you can obtain concurrent licensing but this may not be available to all customers depending on sales channel and existing contracts. Bundles and standard discounts can make a big difference. Depending on you location you may find PowerDesigner in the SAP Store.

      (0) 
  3. Dominique Culioli

    Hello,
    Thanks a lot for your post. I have one question. Is it possible to use a Sysame server and a repository with a Citrix connection ?
    Best regards,
    Dominique

    (0) 
  4. Mel Calucin

    Hi Peter,

    Thanks for the great blog.

    I have started my PowerDesigner journey, and this is what I found so far.

     

    The How to Request License Keys – link is broken.   I used this link instead:

    https://support.sap.com/content/dam/library/SAP%20Support%20Portal/keys-systems-installations/keys/new-request-license-keys-sybase.pdf

     

    I installed PowerDesigner 16.6 sp2 patch 1 on a 4 core 4 GB RAM system.

     

    I’m finding out that everything works but PowerDesigner Portal/Web.  I pretty sure that it’s a memory issue.I’m going to get a minimum of 8 GB.

     

    I selected Tomcat to go with PowerDesigner Portal, and I set my JAVA_OPTS environment variable as -Xms500m -Xmx1300m – XX:MaxPermSize=250m.   Did you go with Tomcat?  If so, what configuration settings did you set for Tomcat given that you have 8 GB ram?

     

    Thanks.

    Regards,

    Mel Calucin

    (0) 

Leave a Reply