Workflow Studio

1
Workflow Studio

• Essential tools for ARSystem developers
• Panacea Workflow Systems
• Date 06/05/2005

2
Agenda
This presentation includes the following

• Product Overview
• Company Overview
• Products Highlights Workflow Studio
• Why choose Panacea tools ?
• Customer comments
• Product Highlights Workflow Studio
• Licensing Pricing
• Questions

3
Company Overview

• Founded in 1997
• Primary focus is the product business
• also some AR System Consulting
• Requirement Analysis Development Deployment.
• Specialist AR System API skills.
• Integration skills (Database, MQ Series, XML ).
• Consulting customers include Ericsson, Orange,
  Telenor
• 200 Customers / approx 900 servers worldwide
• 16 Value Added Resellers Globally
• Currently markets
• Workflow Studio
• Workflow Studio
• Scapa StressTest

4
Overview Migrator Workflow Studio

• Intended users ?
• Administrators/Developers using the AR System

• Purpose of the tools ?
• Suite of tools designed to safely migrate AR
  System applications, document applications,
  improve application performance and generally
  ease day to day tasks in the maintenance of the
  AR System and in development life-cycle.

• Why do you need them ?
• Using these tools your administrators/developers
  don't lose valuable business time on routine
  maintenance tasks. Changes can be implemented
  quickly and smoothly between development
  environment and production, ensuring minimal
  disruption to application users.

5
Overview Migrator Workflow Studio

• Uses published Remedy APIs same as the AR System
  Administrator tool.
• No additional integration before use
• Installs on a client workstation (licensed per
  server)
• Enables connection to multiple servers

6
Selection of Panacea customer - Germany

• T-Systems US Army
• Cable Wireless Deutsche Bank
• Berlin Police Mannesmann VDO
• BMW UTA Telekom
• AGIS Stadtwerke Munchen GmbH
• AM Informatik RZF
• Softlab Porsche
• ASCOM Comconsult
• Deteline Gmbh Citicorp Dienstleistungs GmbH
• Infineon T-Com
• Daimler Chrysler Vector Informatik GmbH
• HZD

7
Product Highlights

• Workflow Studio - Migration

8
Making changes without Workflow Studio
Backup Production Server (AR or DB level)
Development Server
Production Server
definitions
data
9
Making changes without Workflow Studio
Clear down Production Server
Development
Production
Delete all schemas, workflow and data
10
Making changes without Workflow Studio
Create Export Files
Development
Production
definitions
data
11
Making changes without Workflow Studio
Import definitions and additional data
Development
Production
definitions
data
12
Making changes without Workflow Studio
Reimport Production data!!
Development
Production
data
13
Making changes without Workflow Studio

• Involves the import/export of each workflow
  object which is being changed. This this is
  time-consuming, and due to the number of
  operations involved an error prone manual
  process.
• Often involves downtime on the system you are
  changing, so clients are unable to connect , or,
  requires developers to be working out of hours
  (weekends) which is expensive to the organisation
• Often the export process leaves references to
  original server/workflow which must be altered
  manually before importing onto target

14
With Workflow Studio

• Process highlighted in previous slides is made
  simple using the Workflow Studio
• Select Workflow Objects in explorer-like
  interface from source server
• Drag and drop objects onto target server

15
Migration of AR System objects

• Explorer interface shows relationships between
  objects.
• For example, a Form related workflow
  (AL,FIL,ESC,GRPS, MENUS)
• Powerful dependency engine calculates which
  objects depend on others and includes them in
  migration
• This is essential if you want to ensure the
  object you are migrating will function correctly
  in target environment.
• Migrate your entire server or select any of
  objects below
• Forms (VUIs, fields)
• Workflow (active links, filters, guides, menus)
• Applications
• Packing Lists
• Web Services
• Groups
• Distributed Mappings/Pools
• VUIs ( only associated fields)

16
Migration of AR System data

• Workflow Studio enables the Migration of data
  associated with a form
• For one or multiple forms you can migrate

• All records
• Specify qualifications for data transfer in order
  to take a subset of records.
• number of records defined in preferences

17
Migration of AR System data

• Migrate form , workflow , data or any combination
  of the three by using the simple dialogue below

Shows qualification Specified for Testbug
18
Migration to/from file

• Panacea allows any AR System objects or data to
  be migrated to/ from a Panacea Export file (PTG)
• PTG file store is based on Industry Standard XML
• Simple drag and drop operation
• Migrate individual fields (no need to take the
  whole form)
• Migrate Individual Views
• Migrate just Data for forms
• Migrate entire application
• Migrate just workflow
• anything

19
Safe Migrations the Panacea Approach

• Panaceas unique phased migration procedure
  ensures that objects and data are migrated in the
  correct order and at the correct time.
• Furthermore the panacea approach reports objects
  which contain invalid/broken references by
  checking them prior to migration (not reporting
  errors at end)

20
Migration - Replication Phases

• Phase 0 (Integrity Checking)
• Dependency Checking
• Reporting on
• Errors
• Missing Groups
• References to field IDs that no longer exist
• Forms
• Menus
• Guides
• Warnings
• Foreign/Aliased Server References
• Hand-modified Macros Users Macros
• External Dependencies (Run process)
• Automatic sequencing
• e.g. Groups
• e.g. Joins (recursive)
• e.g. Query Menus

21
Migration - Replication Phases

• Phase 0
• Phase 1
• Copy Groups
• Wait for AR Server re-cache

22
Migration - Replication Phases

• Phase 0
• Phase 1
• Phase 2
• Copy Schemas VUIs Fields

23
Migration - Replication Phases

• Phase 0
• Phase 1
• Phase 2
• Phase 3
• Copy Menus

24
Migration - Replication Phases

• Phase 0
• Phase 1
• Phase 2
• Phase 3
• Phase 4
• Update Schemas Fields (query) Menus

25
Migration - Replication Phases

• Phase 0
• Phase 1
• Phase 2
• Phase 3
• Phase 4
• Phase 5
• Copy/Update Active Links Filters Escalations

26
Migration - Replication Phases

• Phase 0
• Phase 1
• Phase 2
• Phase 3
• Phase 4
• Phase 5
• Phase 6
• Copy Data

27
Migration - Replication Phases

• Phase 0
• Phase 1
• Phase 2
• Phase 3
• Phase 4
• Phase 5
• Phase 6
• Phase 7
• Delete operations if specified (PTG)

28
Integrity Checking report

• Example of integrity check report produced prior
  to Migration (Phase 0)

29
Differencing Engine

• Panacea features a powerful comparison tool,
  which allows comparing between
• Two servers
• ANY object on two servers (field/field)
• A server and Panacea Export files
• Allows you to identify object differences that
  exist quickly
• Check whether a migration has been successful
• Save time by Identifying only objects which
  differ and only migrate these
• Colour coded tree view highlights differences
  clearly for each object/attribute
• Summary Report/Detailed Report for printing
• / Add your comments before saving or printing /

30
Comparison Engine

• Differences Report

31
Other features

• Schedule Panacea to Archive data workflow
  objects
• Between Production and Disaster Recovery server
• Direct to Panacea export files
• Whole application (data/objects) or selected
  data/objects can be recovered in the event of
  Server failure

32
Other features

• Installshield integration
• Allow users unfamiliar with AR System to perform
  upgrades of patch by using familiar installshield
  dialogues/process
• Send copies of version upgrades on CD for upgrade
  via this method if site is remote (not accessible
  from main network)

33
Product Highlights

• Workflow Studio

34
Workflow Studio Development features

• Developed initially as a Performance Analysis
  tool to highlight the use of inefficient queries
  within your AR System, the tool now includes
• Performance analysis
• Documentation tool
• Powerful Search Engine
• Unique XML Source code viewer
• Navigator (cross referencing tool)
• Off-line cache
• Migrator integration (export to PTG)
• Graphical Application Viewer
• ARS Log File Debug Tool

35
Performance Analysis
Failing to use indexes when appropriate is THE
main cause of performance problems in using the
AR System Remedy Performance Tuning Guide

• Performance Analysis. How we do it
• Analyse every Workflow query.
• Convert to SQL.
• SQL Show or Explain Plan
• SQL Field Selectivity
• GUI - Display results and Filter.
• Result pinpoints inefficient queries in minutes
  rather than weeks
• Improves response time of app
• Improved response time user satisfaction
• No more trawling through log files

RDBMS
36
Performance Analysis

• Complete analysis report for a particular form
• Performance hints provided indicate possible
  improvements
• Color-coded with red items indicating
  inefficiencies
• Field index analysis indicates suitable
  candidates for indexing

37
Document your AR System application

• Document your AR System applications to Microsoft
  Word automatically, saving your Administrators
  time (and sanity!)
• Schedule documentation sessions to be run out of
  hours
• Table of contents for each object type
• Document single objects on their own
• Application.
• Packing List.
• Form
• Active Link
• Filter
• Document results of a search or contents of a PTG
  export file
• Ensures a readable copy of your application
  exists

38
Document your AR System application

• ( example of field output)

39
Searching your application

• Search your AR System for any object. Some
  possible uses include
• Find whether a field is used in Workflow before
  removing it
• Find all Active links that fire on Modify
• Search for a particular string which is appearing
  in a user message

40
Admin View / Navigator

• Workflow studio allows users to work on-line
  against the server or work off-line via cache
• Objects are available to view from tool in
  familiar look and feel of the AR System Admin
  tool
• Use the object cross referencing feature to jump
  to related objects by double clicking on the
  names (which are hyperlinks)
• huge time saving for developers when debugging or
  understanding existing workflow
• Integrates with Panacea Export to PTG feature

41
Admin View / Navigator Server cache

• Example below shows user viewing a field in
  Admin View.
• Accessing the fields relationships tab to find
  where this field is used across the complete
  server
• Double clicking the AL name takes you to the
  Admin View for that object

42
XML Source Code View

• Unique and scalable method of viewing many
  workflow objects in one window (XML based view)

43
Graphical View

• Graphically understand the relationships and
  dataflow within your application

44
Debug ARS Log File

• Process user logs to quickly debug workflow
  problems. The Workflow Studio displays workflow
  execution patterns in a colour coded treeview,
  allowing easy navigation around the log file.

45
Review

• Using Workflow Studio and Workflow Studio
• saves money and development time by automating
  common manual administration development tasks
• ensures complex migration procedures are
  performed correctly and safely every time.
• ensures less downtime, less errors and
  consequently less cost to business
• you can Schedule migrations out of hours in
  order to free up administrator time.
• ensure optimal performance within your AR System
  workflow without lengthy/expensive health checks.
  
• automatically archive/backup your application
  and data, allowing Administrators the possibility
  of reverting back to previous versions if
  required

46
Other reasons to use Panacea tools ?

• Tools developed by ex-Remedy engineers who
  understand the AR System and the development
  lifecycle
• 8 years Migration / AR System development
  expertise
• Tools built around the AR System APIs - same
  validation performed as via the Admin tool
• Customer focused company
• approved enhancements normally make it into the
  product with 2-4 weeks

47
Customer comments

• Chas Roberts, "County Of Riverside" - US "The
  customer support at Panacea is quite simply the
  best in the industry. I have never been so well
  supported, with lightning fast response as well
  as personalized service. If you are looking for a
  product that will consistently perform as
  advertised, as well as surprise you with it's
  ease of use and after sale support commitment,
  look no further than Panacea Workflow Systems,
  Ltd."
• Daryl Pinch, "Logica Mobile Networks" - Europe
  "Panacea's migration tool has proved to be a
  massive benefit and we have already realised our
  return on investment. Furthermore, since using
  the Workflow Studio tool to help pinpoint all our
  inefficient queries, our users have commented on
  the improvement in overall performance"
• Dave Ware "Ericsson Enterprises Ltd" - Europe
  "Remedy allows us to keep up with ever changing
  process requirements - with Panacea we deliver
  them every week if necessary. Using the Workflow
  Studio tool we took an estimated 20 days off the
  time taken to Performance tune the queries within
  our remedy application, and the end result is
  improved user response time - a great tool"
• J.T. Davies, Freightliner Corporation US
  Panacea Migration works correctly and reliably
  the first time! Our post-migration repairs in
  production have been completely eliminated after
  we switched from ___ to Panacea.

48
Licensing and cost

• products licensed on a per-server basis
• install tool onto as many administrator/developer
  clients as required
• Download evaluation copy from
  http//www.pws-europe.com
• Full product pricing and info available from
  web-site
• http//www.pws-europe.com

49
Workflow Studio

• Essential tools for ARSystem developers
• Questions