2014 Annual

    Atlanta, GA

    April 14-17, 2014

    at the Hilton Atlanta



    Dobler Consulting Logo

    Bradmark Logo

    Bay Storage Logo

    Appeon Logo

    The following sessions will be part of the in-conference SAP PowerDesigner track in Atlanta:

    • Automating & Accelerating DWH Design and Build with SAP PowerDesigner - Murat Cetinkaya (1 Hour Lecture)

      ING Bank has 32 emloyees in its DWH team and currently all ETL developers and modelers are using PD. We’ve been using PD since 2012 as DWH team and our software teams also are going to start using PD soon. We currently use PD 16.5 v2 with repository, proxy and license servers. We benefit from PD by using glossary, naming conventions, domains and many other functionalities.

      In this session I am going to talk about the reasons and problems we had in our DWH environment until last year when we were not using SAP PowerDesigner. Then I am going to talk about how we constructed and automated our new modeling and etl standards and architecture using SAP PowerDesigner. Also which bugs and problems we faced during pilot usage and how we solved them.

      Finally I'm planning to show the results so far and talk about gains in design and build processes. We will end with a Q&A section to help other customers.

    • Creating a Metadata-Driven BI Factory with SAP PowerDesigner - Marcel Schot and Martijn Evers (2 Hour Lecture)

      This session will focus on a subject called Data warehouse automation and how SAP Powerdesigner can be used and extended to become one of the key components for such and effort. Data warehouse automation is a concept focusing on using tools to automate the data warehouse processing based on metadata/datamodels instead of hand coding ETL and data models. It relies on techniques like structural model transformations and code generation. On the one hand this session will explain the techniques that we can use to automate, on the other hand we look at SAP PowerDesigner as a tool to support the techniques. We will look at:

      • Data Architecture & Data concerns
      • Model annotation
      • Model generation
      • Model deployment
      • Model mappings and ETL
      • ETL generation
      • Execution control and generation
      • Data processing & Business rules

      After this session attendants should understand the basics of Data warehouse automation and how SAP PowerDesigner can support such efforts by extending its functionality.

    • Joining the Dots - Mapping Expectations to Reality - George McGeachie (1 hour Lecture)

      Data models are often developed in total isolation, resulting in islands of disconnected metadata. Those data models could describe the transition of data from web form to database, from requirements to implementation, from ERP system to Data Warehouse, from Data Warehouse to data mart to report, from messaging standard to SOA messages, but they can’t do that unless you join them together. Call the connections what you like, you need to create them to make sense of the context of your data. Utilize your models by joining them to the metadata archipelago. Discover:

      • The whys and wherefores of data model mappings
      • How the data model pyramid can help you determine the mappings you need
      • Automating the creation of model mappings
      • How to prioritize your efforts
      • How to exploit those mappings
      • Who you need to have on your side
    • Model – Manage – Govern: PowerDesigner for Information Governance - Matt Creason (1 Hour Lecture)

      Simplifying your data landscape is the best way to build a roadmap to the future. The data must be rationalized, integrated & communicated to gain the maximum business value. Learn how to achieve and derive the business value from the data to speed integration efforts.

    • Modeling Big Data including Hadoop with SAP PowerDesigner - Javier Cuerva (1 Hour Lecture)

      This session will cover how SAP PowerDesigner can be used to model not only SAP Data Management products but Hadoop as well.

    • SAP PowerDesigner & Data Model Transformations - Martijn Evers and Marcel Schot (2 Hour Lecture)

      This session is about on the one hand about classical model propagation as supported by SAP PowerDesigner, and on the other hand about modern techniques like Data Vault and how to support them using SAP PowerDesigner. The session wil also focus on automation aspects and possibilities of SAP PowerDesigner with regard to model transformations This session is split into 3 main parts:

      • Classical model propagation using CDM->LDM->PDM
        • Understanding ER modeling & Separation of Data modeling Concerns
        • Model propagation and restructuring
      • Structural model transformations like Data Vault and Dimensional Modeling
        • Structural transformations
        • what is Data Vault?
      • Facilitating & automating transformations
        • Challenges in model propagation
        • Data Vault Modeling & Transformation
        • Dimensional transformation

      After this session attendants should understand the basics of datamodel 2 datamodel transformations including Data Vault. The strengths and weaknesses of SAP PowerDesigner in this regard. What it can do and what it can't to, and how to automate and extend SAP PowerDesigner for complex model transformations.

    • SAP PowerDesigner for the SAP Data Management Platform - Javier Cuerva (1 Hour Lecture)

      This session will cover the current and future SAP PowerDesigner support for the SAP Platform including support for SAP HANA, SAP Business Objects, and SAP ERP migrations to SAP HANA.

    • SAP PowerDesigner Roadmap and Futures - Matt Creason (1 Hour Lecture)

      This session will show the SAP PowerDesigner product road map highlights and explore the trends promoting the vision for architecture modeling tools at SAP.

    • SAP PowerDesigner Users - What's On Your Mind? - Matt Creason (1 Hour Round Table)

      In this round-table session, SAP management will be on hand to listen to areas of concern to SAP PowerDesigner users, and look for feedback with future direction of the product.

    • Take Control of your Database Schemas with SAP PowerDesigner - George McGeachie (Half-Day Workshop)

      How do you create and update your database schemas? Do you use lovingly hand- crafted DDL, or data models? If you're only using DDL, here's how you can use SAP PowerDesigner to take control of your schemas.

      Learn how to create a SAP PowerDesigner Physical Data Model from scratch or by reverse- engineering an existing design, control the DDL generated from the data model, check the validity of the model, and check the model against the database. Learn how the SAP PowerDesigner repository supports your versioning strategy.

    • Understanding the SAP PowerDesigner Proposition - Martijn Evers and Marcel Schot (1 Hour Lecture)

      SAP PowerDesigner is amongst one of the most powerful modeling packages around. In this session we’ll focus on all the strengths (and some weaknesses too!) of SAP PowerDesigner in contrast to other ER tools like ER/Studio and Erwin. We’ll discuss topics like modeling, model transformation and automation, and the strong customization focus paired with a generic modeling framework. Subjects covered:

      • ER modeling
        • Usage
      • ER modeling tools
        • Erwin
        • ER/Studio
      • SAP PowerDesigner
        • SAP PowerDesigner strengths
          • Automation & generation
        • SAP PowerDesigner issues
        • SAP PowerDesigner weaknesses
        • Product Integration
    • Using SAP PowerDesigner to Cutomize Workflow to Improve System Development - Roberto Pena & Ricardo Buzato (1 Hour Lecture)

      SAP PowerDesigner was customized to improve users work to develop systems in requirement, prototype, mainframe model, data modeling, meeting SOX needs. We will cover:

      • OOM model customizations to requiremet model
      • OOM model customizations to prototype
      • OOM model customizations to physical design
      • OOM model customizations to services model
      • Reports customizations to meet SOX requirements
    • What Can SAP PowerDesigner Do For Me? - George McGeachie (1 Hour Lecture)

      This session will introduce SAP PowerDesigner to you. Discover the depth and scope of what the tool can offer you, learn why a drawing tool just doesn't measure up, and discover some of the features that make SAP PowerDesigner unique. The session will demonstrate what the tool can do for you, it will not teach you how to use it.  Topics to be covered include:

      1. The Four Ds of Metadata (Discover, Document, Design, Do)
      2. SAP PowerDesigner and Metadata
      3. Why not use a drawing tool?
      4. SAP PowerDesigner Essential Knowledge (Building Blocks)
        • Not Just a Load Of Symbols
        • Frameworks, projects, and models
        • Diagrams
        • Objects
        • Sub-objects
        • Links
        • Examples
      5. SAP PowerDesigner practices
        • Leverage existing documentation
        • Import from Excel and other documents
        • Create and manage
        • Generate artefacts (XSD, BPEL, DDL etc)
        • Refactoring
        • Round-trip (XML, Databases, SAP PowerBuilder)
        • Links (Generation Links, Mapping Editor, Custom Traceability Links)
        • Collaboration via the Repository
        • Communication (via Web Portal, Reports, Excel Exports)
        • Extending SAP PowerDesigner's capabilities
        • SAP integration

    And don't forget the pre- and post-conference workshops:

    • Building the Data Model Pyramid with SAP PowerDesigner - George McGeachie - (Full-Day, Pre-Conference)

      In this fast-paced tutorial, learn how to construct a chain of three data models, conceptual, logical and physical, applying normalization and de-normalization techniques where appropriate.

      SAP PowerDesigner is the only data modelling tool with specialized support for all the levels of data model in the Data Model Pyramid. In the case study you'll see how SAP PowerDesigner Projects enable you to visualise and manage your chain of models, including simple links to Requirements and to Business Rules.

      We'll also cover the role of the SAP PowerDesigner repository, which provides facilities to support teamwork, change management, viewing and editing of models by non-specialists (via the web portal), and the management of common models and SAP PowerDesigner resources via the Library. We'll also examine the role that the SAP PowerDesigner Glossary can play in managing naming standards.

    • SAP PowerDesigner Power Programming: The Road to Automation - Martijn Evers and Marcel Schot (Full-Day, Post-Conference)

      This workshop will deep dive into all kinds of advanced subjects when automating & programming SAP PowerDesigner. We will look into creating, separating, modeling and managing extensions. We will look into model transformation/generation, annotation & definition. We will address ETL/GTL generation and offer tips & tricks when automating SAP PowerDesigner functionality like checks, UI and events.

      Some of the subjects covered are:

      • Making Extensions
        • Separation of concerns: separating your extensions
          What are the problems that you can encounter, shortcuts, changing models
        • Modelling Extensions using SAP PowerDesigner
          Using PD to MODEL extensions instead of programming them
        • Using the SAP PowerDesigner MetaModel in your Extension
        • How to best use the power of the Metamodel behind SAP PowerDesigner.
          MetaClasses, hasStereotype, using hasStereotype in your templates. How to access and make use of the MetaModel from VBScript.
      • Model Transformations
        • How is it handled, caveats
          Pre 16.5 versus 16.5
        • making extensions
        • Model annotation and model design
        • Extening SAP PowerDesigner
        • Using Extended Objects to template patterns
          Example of patterns and steps and how to use this in GTL
          Inheritance and Polymorphism
        • Using the SAP PowerDesigner MetaModel to simplify your code
          Copy objects
          From extended attribute to attribute and vice versa
      • Tips & tricks
        • GTL
          • Getting the item for wich a template is executed in a vbscript section of the template
          • Passing variables from and to GTL templates , implementing dynamic templates using extended objects (ETL generation using a pattern and steps)
        • VBScript
          • Scripting model checking, selecting, executing, fixing
          • Using collections, caveats when using shortcuts and packages
          • Reconnecting a model the hard-way (Shortcut - Replication)
          • Diagrams and repainting them
        • Modelling / extending
          • Patterns for extended objects and sub-objects
          • Navigating the SAP PowerDesigner MetaModel


    Copyright © 2014 ISUG-TECH. All Rights Reserved
    All material, files, logos and trademarks within this site are copyright their respective organizations

    Terms of Service - Privacy Policy - Contact the Help Desk