DATA MODELING WITH POWERDESIGNER 16.7
Duration: 4 days
Goals:
1. Define glossary terms
2. Distribute model templates using the Library
3. Create and manage conceptual and logical data models
4. Generate and manage physical data models
5. Generate database creation scripts
6. Produce implementation details, such as triggers, procedures, and views
7. Reverse engineer an existing database to create physical, logical and conceptual models
8. Utilizing Impact & Lineage analysis in complex modeling environment
9. Compare and merge models
10. Synchronize physical data models with databases
11. Manage large models and multiple designers using the PowerDesigner Repository
12. Create effective reports on PowerDesigner models
Content:
1. SAP PowerDesigner
Identifying Key Components of the SAP PowerDesigner Environment
Creating a Project in the Workspace
2. Conceptual Data Models (CDMs) and Logical Data Models (LDMs)
Applying Model Properties and Options
Creating Entities and Domains
Creating Relationships in CDMs and LDMs
Creating Inheritance Links in a Model
Checking a CDM
3. Physical Data Models (PDMs)
Generating a PDM from Another Model
Implementing Data Integrity Checks in a PDM
Creating Views, Stored Procedures, and Triggers
Creating Indexes and Alternate Keys
Checking a PDM
Generating a Database from a PDM
Reverse Engineering from a Database
4. Model Synchronization
Comparing Models
Merging Models
Synchronizing Models
5. Model Organization
Creating and Modifying a Package
Creating a Diagram
Creating a Package from a Diagram
Creating a Dependency Matrix
6. Reporting
Creating a Report Template
Creating a Report
Generating a Report
Creating a Multi-Model Report
7. Impact Analysis
Creating Requirements
Creating a Link Between Models
Generating an Impact Analysis Model (IAM)
8. The Repository
Creating a Glossary
Modifying Documents in the Repository
Setting up a Repository Workflow
Integrating Changes Across Repository Branches
Managing a Repository