Converting from Logical to Physical: Discussion of the issues

1
16843 Harbour Town Drive Silver Spring, MD
20905 Tel [phone] Fax [phone]
Myriad Solutions, Inc.
Converting from Logical to Physical Discussion
of the issues
Manan Shah manan_at_myriadinc.net
2
Agenda

• Design Layer Architecture
• Traditional Modeling Cycle
• Logical vs. Physical
• Technical Demo
• Other Helpful Features
• Complementary Tools
• Q A

3
CA Modeling Suite
Data Model Validator
ERwin Data Modeler
Process Modeler
Model Manager
Model Navigator
4
Modeling Life Cycle
Logical Only Model
Model Derivation
Model Sync.
Model Derivation
Physical Only Model
Fwd. Eng.
Complete Compare
Rev. Eng.
DB System (i.e. Oracle, MS SQL, DB2)
5
Modeling Life Cycle(contd)
Logical
Update Physical
UpdateLogical
Physical
Complete Compare
Fwd. Eng.
Rev. Eng.
DB System (i.e. Oracle, MS SQL, DB2)
6
Logical vs. Physical
7
Product Demo
8
Helpful Features

• Naming Standard File (.NSF) Organization under
  utilize this feature.
• Name Hardening Ability to lock object names, so
  accidental changes cannot occur. (Version 7.x
  Feature)
• Option Set DOUBLE-EDGED SWORD. Shortens your
  development time by almost 50-60, if used the
  right way.
• Sessions Gives you the ability pause your
  complete compare and return at a later time.
  (Version 7.x Feature)
• Known Differences Filter out object that will
  always remain as a conflict. (Version 7.x
  Feature)

9
Complementary Tools
10
Profile
Product/Service Overview

• Architecture, Design, Implementation,
  Customization, Integration, and Fulfillment of
  only CA Products with an Emphasis on AllFusion
  and AllFusion Enterprise Solutions.
• Data Warehousing Architecture consulting and
  implementation expertise.
• Focus on Federal/State/Local/Commercial
  compliance regulations, including DODAF, SOX,
  etc.
• Complete support for Application Development
  Lifecycle.
• Skill Sets AllFusion Data Modeling,
  Non-Modeling (ESP), NIKU, GEN, Harvest, Unicenter
  SQL Station, and Commercial Storage and Security
  Products.

Key Differentiators
Key Features/Attributes

• Technical staff is certified on Erwin Data
  Modeler and eTrust commercial products.
• Expertise in Project, Process, and Portfolio,
  Management consulting services.
• Change and Configuration Management consulting
  services.
• GSA Schedule, NY State Contract, Approved
  Supplier to GSIs.
• Pre-Sales and Post Sales support on AllFusion
  (examples PBGC, SSA, FedEx/Kinkos, FDIC)
• Working on 8A/Hubzone certification

• Strong expertise in data architecture for
  modeling and non-modeling solutions.
• Only sell CA Products.
• Provide first line of support for the AllFusion
  line of products.
• Financing options available (P3).
• Competitive Product Displacement Initiative.

Opportunity Fit

• Client/Account Portfolio

• Federal Clients US Army, USDA, Dept of Labor,
  US PTO, CACI, SRA, CDC
• Commercial Clients McKinsey, Fedex/Kinkos,
  Blue Cross/Blue Shield of PA, Bristol Myers
  Squib, AOL, Brick St. Insurance, Raymond James,
  Circuit City, Cisco, GEICO, Lexmark, Manhattan
  Associates, Starwood Hotels
• GSA Contract - GS-35F-0468N
• NY State Contract
• W VA State Contract
• Approved Supplier for Lockheed Martin, SRA,
  Northrop Grumman, SCITOR, and CGI AMS.

• AllFusion Product Sales (Modeling and
  Non-Modeling, Enterprise and Commercial
  Products).
• Data Warehousing and Data Architecture consulting
  and implementation services.
• GSA Opportunities/Fed Bid
• Application Development Projects.
• AllFusion Implementation and related services.