PDR603: Real Enterprise Modeling Converting to PowerDesigner from ERwin

1
PDR603 Real Enterprise Modeling Converting
to PowerDesigner from ERwin
Matt Creason Senior Systems Consultant mcreason_at_sy
base.com August 15-19, 2004
2
The Enterprise. Unwired.
3
The Enterprise. Unwired.
Industry and Cross Platform Solutions
Unwire People
Unwire Information
Manage Information

• Adaptive Server Enterprise
• Adaptive Server Anywhere
• Sybase IQ
• Dynamic Archive
• Dynamic ODS
• Replication Server
• OpenSwitch
• Mirror Activator
• PowerDesigner
• Connectivity Options
• EAServer
• Industry Warehouse Studio

• Unwired Accelerator
• Unwired Orchestrator
• Unwired Toolkit
• Enterprise Portal
• Real Time Data Services

• SQL Anywhere Studio
• M-Business Anywhere
• Pylon Family (Mobile Email)
• Mobile Sales
• XcelleNet Frontline Solutions
• PocketBuilder
• PowerBuilder Family
• AvantGo

Sybase Workspace
Products supported by PowerDesigner
4
Topics

• Where does PowerDesigner fit?
• PowerDesigner Concepts
• Interface
• Data Model Notation
• Tri-level Design
• Link and Synchronize Concept
• Model Management in the Repository
• What is it?
• Concepts
• Security
• Architecture
• Mapping of Objects
• Conversion of ERwin Models
• Import
• Project methodologies
• Governance

5
Where Does PowerDesigner Fit?
Business ProcessModeling Market
Business users,non-IT users
Data ModelingMarket
UML ModelingMarket
OO Developers,Application Designers,Project
Leaders
Designers, Data Analysts,Project Leaders, DBAs
6
PowerDesigner Concepts

• Interface
• Workspace
• Multi-model support
• Customizability
• Data Model Notation
• IDEF1X
• James Martin Information Engineering
• Merise
• Tri-level Data Design
• Conceptual
• Logical
• Physical

7
Link and Synchronize Concept
C, VB.NET, Java, J2EE PowerBuilder, XML, Web
Services, WSDL
Business Process Model
ebXML BPEL4WS
Object-Oriented Model
Conceptual Logical Data Models
O/R Mapping
XML DTD/Schema Model
XML DTD XML Schema
Physical Data Model
Forward Engineering
ODBC
Reverse Engineering
Database SQL Script (DDL)
Roundtrip Engineering
Import/Export
8
Model Management in the Repository

• What is it?
• A schema that is deployed to 6 of the most common
  RDBMSs in production
• Sybase ASE
• Sybase ASA (ships with product)
• Oracle
• IBM DB2
• Microsoft SQLServer
• Informix
• Concepts
• Consolidation
• Extraction
• Versioning
• Branching
• Security

9
Repository Architecture
10
Mapping of Objects - CDM
11
Mapping of Objects - PDM
12
Conversion of ERwin Models

• Initial import What happens
• CDM, PDM or CDM/PDM pair
• Project methodologies
• A two-phased approach
• Step 1 Initial Conversion
• Step 2 Refinement to make the best use of the
  PowerDesigner environment
• Governance
• Normally reduced in size due the functionality of
  PowerDesigner and the controls provided
• Must be thought of and updated to preserve data
  quality in the organization

13
PowerDesigner Vision

• Continue to Lead in Data Modeling
• Continue to Innovate in Integrated Modeling
• PowerDesigner 11 in Beta Today
• Requirements Management
• Impact Analysis
• Enhanced Business Process Modelling
• New Information Liquidity Model
• Visual Studio .NET plug-in (like Eclipse)
• Enhanced Enterprise Features (Repository, Change
  Management)

14
More Information

• PowerDesigner Web Site
• http//www.sybase.com/powerdesigner
• CodeXChange
• http//powerdesigner.codexchange.sybase.com
• PowerDesigner Newsgroup
• news//forums.sybase.com/sybase.public.powerdesign
  er.general
• PowerDesigner Advanced Documentation
• Accessible from PowerDesigner help menu
• PowerDesigner VBScript online help
• Accessible from PowerDesigner help menu
• Microsoft Windows Script online help
• Can be downloaded from http//msdn.microsoft.com
• OLE Automation samples
• OLE Automation\.
• PowerDesigner Metamodel
• Examples\MetaModel.oom

15
Conclusion
QUESTIONS ???
16
PDR603 Real Enterprise Modeling Converting
to PowerDesigner from ERwin