1 / 52

AllFusion ERwin Data Modeler API

AllFusion ERwin Data Modeler API. Agenda. AllFusion ERwin DM API Objectives Architecture Components and their functions Examples of API use ERwin Spy XML Script Integration strategies and useful tips Summary Questions and answers Samples. AllFusion ERwin DM API. Objectives

melissa-cole
Download Presentation

AllFusion ERwin Data Modeler API

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. AllFusion ERwin Data Modeler API

  2. Agenda • AllFusion ERwin DM API • Objectives • Architecture • Components and their functions • Examples of API use • ERwin Spy • XML • Script • Integration strategies and useful tips • Summary • Questions and answers • Samples

  3. AllFusion ERwin DM API • Objectives • Architecture • Components and their functions

  4. ERwin DM API Objectives • Enables access to data in ERwin Modeling Core memory at run-time, as well as to models persisted in files and in Model Mart repositories. • Add-In and Stand-Alone • Generic, object-property based. Access to model data and metadata • COM technology, Automation-compatible

  5. ERwin DM API Architecture Modeling Core ERwin File I/O MM Repository API Application Persistence Directories Model Metamodel ERwin Spy XML Client Model Mart Clients Client

  6. ERwin DM API Components • Application • Property bag • Persistence unit • Session • Model object • Model property

  7. Application Component Modeling Core ERwin File I/O MM Repository Application API Persistence Directories Model Metamodel ERwin Spy XML Client Model Mart Clients Client

  8. Application Component • ISCApplication • Main entry point into API • Encapsulates API functionality • Must be instantiated • Key properties • Persistence units • Model Directories • Sessions

  9. Persistence Components Modeling Core ERwin File I/O MM Repository API Application Persistence Directories Model Metamodel ERwin Spy XML Client Model Mart Clients Client

  10. Persistence Unit Component • ISCPersistenceUnitCollection • Container of Persistence Units • Interfaced via Application object • Key properties / methods • Item • Add • Create

  11. Persistence Unit Component • ISCPersistenceUnit • Represents a model data unit in memory • Key properties / methods • PropertyBag • Save

  12. Property Bag Component • ISCPropertyBag • Holds properties of a persistence unit • Needed to create a new persistence unit • Must be instantiated • Key properties / methods • Value • Add

  13. Model, Metamodel Components Modeling Core ERwin File I/O MM Repository API Application Persistence Directories Model Metamodel ERwin Spy XML Client Model Mart Clients Client

  14. AllFusion ERwin DM Metamodel • Object-property based • Model-based vs. intrinsic • Exposed through API • Use ERwin Spy to view

  15. Session Component • ISCSessionCollection • Container of sessions • Interface via Application object • Key properties / methods • Item • Add • Remove

  16. Session Component • ISCSession • Use the session to access model data • Key properties / methods • Open • ModelObjects • BeginTransaction • CommitTransaction • Close

  17. Model Object Component • ISCModelObjectCollection • Container of model objects • Interface via session • Key properties / methods • Root • Collect • Item • Add • Remove

  18. Model Object Component • ISCModelObject • Represents a single Object • Key Properties / Methods • Name • ClassName • Context • Properties

  19. Model Property Component • ISCModelPropertyCollection • Container of model property objects • Interface via model object • Key properties / methods • HasProperty • Item • Add • Remove

  20. Model Property Component • ISCModelProperty • Represents a single property • Single and multi valued • Key properties / methods • FormatAsString • Value • DataType

  21. ERwin DM API Clients Modeling Core ERwin File I/O MM Repository API Application Persistence Directories Model Metamodel ERwin Spy XML Client Model Mart Clients Client

  22. Samples • SCAPI using VBScript • SCAPI using HTML

  23. ERwin Spy

  24. XML for AllFusion ERwin DM • Standard XML file format • Based on AllFusion ERwin DM Object-Property Model • DTD supplied • Supports both import and export

  25. XML File Terms • AllFusion ERwin DM objects • AllFusion ERwin DM properties • Object and property grouping • AllFusion ERwin DM IDs

  26. XML – AllFusion ERwin DM Objects • Appear as XML elements • Contain a Name and ID attribute <Entity id="{E53D9A6E-9F69-4516-A7E6-72C058E2634C}+00000000" Name="EntOne">

  27. XML – AllFusion ERwin DM Properties • Appear as XML elements • Property value stored as text • Optional RO attribute • <Type RO="Y">3</Type> • <Key_Group_Type>PK</Key_Group_Type> • <Parent_Domain>{39146A35-A713-4CAA-9FBF-9AA575FA9F44}+00000001</Parent_Domain>

  28. XML – Grouping • Child object grouping • <Entity id=…> • <Attribute_Groups> • <Attribute id=…> • </Attribute_Groups> • </Entity>

  29. XML – Grouping (continued) • Property grouping • <Entity id= …> • <EntityProps> • <Name>EntOne</Name> • <Type>1</Type> • <Index_Generate>1</Index_Generate> • </EntityProps>

  30. XML – AllFusion ERwin DM IDs • GUID + offset • Unique • Generated on import • id="{E53D9A6E-9F69-4516-A7E6-72C058E2634C}+00000000"

  31. XML Export • “Save As” file type • Exports complete AllFusion ERwin DM model

  32. XML Import • “Open” file type • Imports into a new model • Supports “partial” XML files

  33. <?xml version="1.0"?> <ERwin4 FileVersion="4002"> <Model id="0001" ModelType="3" TargetServer="192" DBMSVersion=“13“ DBMSMinorVersion="1"> </ERwin4> XML - Model

  34. Samples • XML

  35. Integration Strategies • Integration choices • Factors to consider • Examples

  36. Integration Choices • XML • API • Standalone • Add-In • Combined solutions

  37. Factors to Consider • Platform • Product dependencies • Level of integration • Size and speed

  38. Integration Example • AllFusion Data Model Validator • Issues • Ability to directly read ER1 files • Needed only physical information • Solution • Use the API in standalone mode • Provide the ability to launch AllFusion Data Model Validator from AllFusion ERwin DM

  39. Integration Example • AllFusion Component Modeler • Issues • Two-way integration • Product installation independent • Solution • Create an AllFusion ERwin DM add-in • Use both API and XML

  40. Overall Value • AllFusion ERwin DM API functions offer powerful capabilities to support: • Model migration and conversion • Tool and life cycle integration • Extended reporting

  41. Session Summary What have we covered? • AllFusion ERwin DM API, architecture, components • AllFusion ERwin DM metamodel • AllFusion ERwin DM XML • Integration strategies • Overall value

  42. Questions & Answers

  43. CA Education Making CA Clients Successful with CA Software • CA Education helps companies quickly transform the potential of Computer Associates software into a measurable performance advantage by providing a faster, easier, better approach to training • Stop by the Customer Pavilion for your Free 2002 Education Course Catalog and Schedule • Visit us on the web at ca.com/education, or contact us at 1-800-237-9273

  44. Samples • XML • SCAPI using VBScript • SCAPI using HTML

  45. XML Sample

  46. XML Sample Output

  47. VBScript Sample 1

  48. VBScript Sample 2

  49. VBScript Sample 2 (cont)

  50. VBScript Sample 2 Output

More Related