Designer 10g

1
Designer 10g Repository Object Browser

• Maandag 28 februari 2005
• Lucas Jellema (AMIS)

2
Agenda

• Repository Object Browser (ROB)
• Korte Introductie historie en architectuur
• Overzicht functionaliteit op hoofdlijnen
• Rapportages, Browsen en Zoeken
• Verfijningen van de output
• Beheer
• Designer 10g
• Analyse Entity Relationship Modeling
• Design Database Design
• Build Server Generation Design Capture
• Oracle SCM (Software Configuration Management)
• Files en Folders
• Versiebeheer
• Check Out/Check In
• Compare en Merge

3
ROB - History

• 1996 Initial Designer Web Browser Cherry Pie
• Used by Oracle Consulting
• 1999 Oracle Designer Web Assistant 6.0 (2.1)
• Free on OTN
• 2001 Oracle Designer Web Assistant 6i/i9
• Part of iDevelopment Accelerators Suite
• 2003 Repository Object Browser
• in Designer 9i (9.0.2.4) and 6i R4.6
• 99.6 code from ODWA taken over by Oracle
  Product Development from Oracle Consulting (some
  new titles and graphics)

4
Benefits and Objectives of Designer Web Browser

• Access to Designer contents
• For not highly trained users
• With a user-friendly interface
• From simple, lightweight PCs
• Without additional Designer licenses
• In a controlled, read-only manner
• Across WAN, even from outside the fire-wall
• Advanced functionality for experienced Designer
  users
• Useful Search, Security Management, VHV,
  Dependency Management
• Web-based file manipulation
• Multiple simultaneous sessions on Designer

5
ROB Architecture and Technology
Oracle Designer 9i Repository
6
Toegang tot de ROB

• Via een URL
• Bijvoorbeeld http//localhost7777/pls/rob/cdwp.s
  tartup
• Een URL kan gekoppeld zijn aan een
  username/password in Oracle Designer
• Dan is geen login benodigd
• Maar is er ook geen enkele afscherming van
  gegevens (binnen het KPN intranet)
• Een URL kan losgekoppeld zijn van een Designer
  user-account
• In dat geval moet je in de browser inloggen met
  je Designer account

7
ROB Main Menu, Core functionality
8
Publishing
publish
9
Oracle Designer Publishing Capabilities

• Oracle Designer Repository Reports
• Write your own Reports using the Designer API
• Print (Screen) from RON, Design Editor and
  Diagrammers

10
Limitation of Designer Publishing

• Reports are not as complete or compact as could
  be desired
• Browsing through related documentation difficult
• Data cannot easily be distributed or made
  accessible to remote users (across Fire Wall)
• Oracle Designer Tools can be intimidating and
  hard to learn/use
• Every user needs fat PC and Designer license

11
Implications

• Extra license dollars
• Extra money and time to invest in training and
  installation
• Limited Functionality -gt Real requirements are
  not implemented,
• system does not do what it is supposed to do
• Paper based reports to deal with some limitations

12
Reports for Element Type
13
ROB Reports

• Oracle Method style Reports for major Element
  Types
• with relevant detailed elements
• with relevant properties (when they have a value)
• Cross References between reports
• for all inter element references, such as Foreign
  Key, Entity Relationship, Function Entity Usage,
  etc.
• references between analysis and design element
  types (entity/table, function/module, etc.)
• Navigate within Workarea or Configuration

14
Example Table Definition Report
15
ROB Reports - Extras

• Clickable Diagrams
• Enables drill down from the diagram to the
  details in the related element reports
• Full Support for CDM RuleFrame
• Reports for Business Rules, Rule Design
  Definitions
• Entity/ Function Reports include related Business
  Rules
• Table/ Module Reports include Rule Design
  Definitions
• Ability to enhance multi-line text with
  element/web links and (clickable) graphics
• e.g. screen mock-ups in functions or module
  definitions

16
ROB Reports - Advantages

• Easy and fun to use
• Always up-to-date
• Can lead to better feedback from end-users
• Offers a starting point for acceptance tests
• Remote sites have instant access
• Saves you money in licenses, training and a huge
  pile of paper
• Helps protect the environment

17
Business Rules and CDM RuleFrame

• The Repository Object Browser offers support for
  Business Rule Analysis and Design
• According to the CDM RuleFrame methodology
• To optimally benefit you need Headstart Utilities
  from the iDevelopment Accelerators Suite
• Benefits from using ROB
• Business Rule reported as one element in one
  report
• Instead of scattered across Events, Entities and
  Business Functions
• Clear insight in relations between Data, Process
  and Rules
• Rules triggered by Modules and Functions, Data
  Events on Entities triggering Business Rule
  validation
• Enable CDM Objects in ROB Management Facility,
  ROB Preferences

18
Business Rule Development process
19
Multi-Line Text manipulation

• Include references to other Repository Elements
• objectnameTYPEshort name typeVLABELversion
  label and objectCRNTYPEshort name
  typeVLABELversion label(TYPE and VLABEL are
  optional!)
• to a ConfigurationCFGcfgname or
  CFGcfgnameVLABELversion
• to a Workarea WAwaname
• to an Object IRID IRIDirid value or to an
  Object IVID IVIDivid value

20
Diagrams and Images

• Create GIF of JPEG of the images you want to
  present in your reports
• That also applies to diagrams
• Locate these images
• In the images directory on the Web Server (where
  all ROB-images are)
• Inside the Repository by uploading from the
  file-system
• Refer to the images from any multi-line text
  property in the object
• image_file_name.gif
• Or define a graphic and use GRAPHICOCM_ERD
• Optionally include hot-spots or clickable areas
• That allow the user to hyperclick and navigate
  across the Repository

21
Collaboration
collaborate
22
Collaboration and Oracle 10g SCM

• Oracle SCM can also contain files and folders
• Opportunity exists to have all project and system
  documentation in a single Repository using the
  same software configuration mgt procedures
• Checking in can be done through
• Repository Navigator in Oracle Designer
• Oracle Forms, Oracle Reports
• Oracle JDeveloper

23
Collaboration - Limitations

• Many files are not created with Oracle Tools
  (plans, testing document, user doc, MS Project
  files, etc.)
• Not all Project Staff have knowledge of Oracle
  Repository
• Staff are not able to check in these files in the
  Oracle Repository
• Not all staff may have Oracle Repository Client
  Tools installed

24
Collaboration - Implications

• Multiple separate project/system environments
  need to be maintained
• Different SCM procedures are needed for each
• Files may be lost or impossible to return to
  previous version
• Difficult to share files without interference
• No single source of truth potentially leading to
  confusion and cock-ups

25
ROB - Collaboration

• Easy to use browser based interface to perform
  the following actions in the Oracle Repository
• Create folders
• Check in and upload files
• Check out and download/view files
• Give project staff access to folders and
  workareas
• Version history is readily available
• who/when/why has checked in/out

26
File and Version Management
27
ROB Repository Navigator for Folders and Files
28
ROB Collaboration - Advantages

• One single point of truth for all system and
  project documentation
• Single set of SCM procedures
• No need to learn, install Oracle Designer/Oracle
  Repository
• Saves
• Browser Based, Easy to use
• Supports geographically dispersed teams

29
Search, Browse and Manage Security

• Search facility
• To find Repository Objects through a large number
  of criteria across workareas, version trees and
  folders
• Save search criteria for reuse
• Directly download files found in any search
• Object Browser
• For full RON-style (though read-only) details on
  all elements in the Repository (complement the
  Reports)
• Support for Dependencies
• Security Manager
• Manage Repository access rights using Roles

30
ROB Search

• Extensive web based search engine
• Basic search
• Name, Element type, Folder etc.
• Advanced search
• Multi Line text contains, File contains, Extra
  where clause
• Version search
• All checked out elements (by a certain user)
• Audit search
• Who has created/updated what and when?

31
ROB Search Facility
32
ROB Search - Advantages

• Fast and Easy search of elements
• Download any version of any file
• Fast and Easy access to version meta-data
• Supports Development Manager to control project
  progress
• Supports Repository Manager in management of the
  Repository
• Save queries to library for (public) reuse

33
ROB Object Browser

• Read only RON on the Web
• Displays any Element Versions in a tree style
  fashion
• Sub nodes include
• attributes
• details (secondary access elements)
• associations
• Property palette gives a list of all properties
• Supports User Extensions and Dependency Mgt

34
ROB Object Browser - Advantages

• Extends ROB Reports by
• Giving information of any element version
• Showing all properties
• Gives easy access to dependency information for
  impact analysis
• Links to version history viewer to get life cycle
  overview of element

35
Repository Object Browser and Dependency
Management
36
Parsing Standard and User Defined Dependencies
with the ROB

• The ROB will report on all dependencies parsed by
  the standard Oracle SCM parsers
• For SQL, PL/SQL, Java, Forms, Reports etc.
• The ROB can parse all dependencies derived from
  the structured, meta-model based dependencies
• From the Dependencies node in the Object Browser
• The thus parsed depdencies are reported on by
  both the Object Browser and the standard
  Dependency Manager
• The ROB will also parse user-defined dependencies
• Defined in Multi-Line Text properties

37
Dependencies in the ROB
38
Security Manager - For Managing Oracle SCM
Security through roles
Note Roles are disabled by default. To enable,
you have to activate a few lines of code in
package jr_role (see paper for details)
39
Customizing and Extending the ROB

• Customize Report
• Additional or less properties
• Your own lay-out style
• Add Report for currently unsupported element type
• Add features such as
• Extend Search, Upload (Zip)file, Custom business
  rule methodologies, Support Import/Export,
  Download of Reports in PDF, Static HTML
  generation, Text Editor, Support for DML on
  Designer elements, Dynamic Diagram reporting

40
Example Create report for Business Units

• Copy files cdwp_dom.pks and cdwp_dom.pkb to
  cdwp_bun.pks and cdwp_bun.pkb
• Replace the current logic in these packages for
• retrieving and displaying data for Domains
• with code to retrieve and display Business Unit
  data
• Insert a record into table PIE_ELEMENTS
• INSERT INTO PIE_ELEMENT_TYPES (short_name,
  gif_file, plural, detail_procedure, display_name)
  VALUES (BUN, business_unit.gif, Business
  Units, bunapp.bun_report)
• Optionally change procedure odwalpad.launchpad

41
Conclusies Repository Object Browser

• Read-only Toegang via je browser tot vrijwel alle
  gegevens in Oracle Designer
• Met of zonder login op je eigen account
• Beperkte manipulatie van gegevens
• Files en Folders creeren en verwijderen
• Uploaden en Downloaden van files
• Alle file-types
• Speciale Functies
• Search, Rollen, Dependencies, Clickable
  Diagrammen