Oracle BPM Open Data Services (Part 1)

33 %
67 %
Information about Oracle BPM Open Data Services (Part 1)
Technology

Published on March 7, 2014

Author: drrwebber

Source: slideshare.net

Description

Executive introduction to using Oracle BPM and open data web services to drive workflow collaborations.

A Child Welfare Case Management and Court filing application is show cased.

The technical "how to" build directions are covered in Part 2

Quick Tutorial – Part 1 Using Oracle BPM with Open Data Web Services Health and Human Services Child Welfare Example 1 Copyright © 2012, Oracle and/or its affiliates. All rights reserved. August, 2013 David Webber and Serge Leontiev Public Sector NIEM Team

Disclaimer Notice The following is not intended to outline Oracle general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle. 2 Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Slide 2

Tutorial Overview  Introduce the Use Case – The Business Process and Actors  Demonstrate the Example Application – Discuss the Application Architecture – Review the Components, Features and Capabilities  Summary and Resources 3 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.

Demonstration Objectives Illustrate capabilities of BPM application solution Demonstrate use of information sharing web services Show scalable lightweight technology architecture Introduce Open-XDX tools Introduce SPARQL tools Illustrate rapid development using the Oracle platform and tools 4 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.

Use Case - Child Welfare Emergency Medication Child requires new medication(s) Psychotropic medication requires Court Authorization Caseworker initiates Court Case Attending Physician completes Medical report Parents provide input, assent / object Judge Reviews Case 5 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.

Actors, Roles and Actions Case Worker  Initiates Case for Child Physician (Doctor)  Provides Medical Report Childs Parent  Complete Health History and Consent Forms County Judge  Reviews Case and Presides 6 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.

Business Process Workflow Diagram (WYSIWYE) 1 2 (from CWS/CMS) 8 Case worker (creates initial case records) 5 4 3 (from case history) (prescription drug history) (diagnosis and treatment) 6 (updates case details and pass to court system) 7 Doctor Copyright © 2012, Oracle and/or its affiliates. All rights reserved. 7 (send court decision to case worker) (form completed by judge with case outcome) Judge + Parent

Application Demonstration Note: All names and details used are completely fictitious 8 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.

Development Conceptual View Design Test SQL CAM Editor XML Deploy DB Delivery Open XDX Open XDX SQL XML BPM BPM • Generate Data Validate Data Share Data • CAMV Visual Editor SQL Browser Dictionaries Drag and Drop • • • • 9 • • • Copyright © 2012, Oracle and/or its affiliates. All rights reserved. • • • Open XDX Web Services Oracle BPM • Device Browser Server

Conceptual Architecture Components Deployed Application Systems 1 3 Oracle BPM User Forms 4 2 User Forms Courts Systems (NIEM) 10 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.

Components Summary  Open-XDX open data toolkit with visual mapping editor  Web service message exchanges with XML  PDFbox Java library for PDF form handling  SNOMED semantic lookup tools  BPM user forms and SQL integration  BPM workflow engine and dashboard 11 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.

Component Overview – Open-XDX Mapping Services with XML  Visual Mapping from data sources  Template driven “code free” Java engine creates deployed web services  SQL automatically generated  XSD schema creates binding for data sources in BPM forms 12 Copyright © 2012, Oracle and/or its affiliates. All rights reserved. SQL JDBC connection Open-XDX Engine XML instance generated CAM Template + mapping + rules Open-XDX = Open XML Data eXchange services („open data‟) Web Service (WSDL) XSD schema content definition

Capability – Visual Data Mapping Editor Target XML Structure 13 Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Drag and Drop Case Management Database

Capability – CAM Editor Developer Tools Editing/XML/SQL/Mapping CAM Template XSD Schema XML Content Structure - required MindMap Model UML Model Rules CAM EDITOR Documentation Copyright © 2012, Oracle and/or its affiliates. All rights reserved. XML Instance XML Dictionary SQL 14 Target Renderings (via XSLT transforms) Documentation HTML, XML, Excel

Component Overview – User Forms  Associate XSD schema with BPM form  SQL JDBC connection One click BPM form generation from schema field definitions  Supports CRUD access to SQL data stores  Code free approach 15 Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Open-XDX Engine XML instance generated CAM Template Open-XDX = Open XML Data eXchange services („open data‟) XSD binding BPM User Form

Component Overview – Fillable PDFs   Import XSD schema into JDeveloper Java objects SQL JDBC connection Map XML elements to PDF form text objects  Java PDFbox library merges XML content into PDF blank form  Output is prefilled PDF form  Deliver via REST as binary object 16 Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Open-XDX Engine XML instance generated CAM Template XML to PDF using Apache “PDFbox” Java class library XML to PDF service

Component Overview – SNOMED lookup  NIH SNOMED drug catalogue preloaded as RDF into Oracle Database  Use prescription drug name for semantic SPARQL lookup  Return drug classification and related information as XML results  Display in BPM form 17 Copyright © 2012, Oracle and/or its affiliates. All rights reserved. NIH SNOMED RDF dictionary Oracle Database SPARQL search Java Results Handler RDF content is queried to retrieve semantic content XML result generated

Features and Capabilities Summary  Combines capabilities of Oracle BPM with rapid data integration via SOA  Build workflows quickly and link to interactive forms  Minimizes coding; visual development approach  Leverages XML with SQL, PDF forms and JSON  Create scalable open data web services 18 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.

Resources and Links  Open-XDX and CAM editor software tools – http://www.cameditor.org  Product Information on Oracle BPM Suite – http://www.oracle.com/us/technologies/bpm/suite/overview/index.html  Java Developer Magazine article “BPM without Barriers” – http://java.ulitzer.com/node/2269751 19 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.

Open-XDX Specific Resources SNAPSHOT OF PROJECT ACTIVITIES Showcase site for integration exchanges using NIEM and Open Data Global Test bed initiative for Information Exchange (GITB) CAMV validation tools www.VerifyXML.org 20 Copyright © 2012, Oracle and/or its affiliates. All rights reserved. 20

CAMeditor.org Project Site SNAPSHOT OF PROJECT ACTIVITIES 165,000+ CAMeditor.org page visits to site 165+ countries have downloaded tools; 30% of visitors are from U.S.; 800+ downloads weekly 3,500+ student views of online video training resources 8 languages now available www.cameditor.org 21 Copyright © 2012, Oracle and/or its affiliates. All rights reserved. www.niemtrainingvideos.org

22 Copyright © 2012, Oracle and/or its affiliates. All rights reserved.

Add a comment

Related presentations

Related pages

Oracle BPM and Open Data Web Services with Open-XDX - Part 1

Illustrating the use of Oracle BPM with Open Data Web Services, JDeveloper, XML, NIEM, JSON, SQL, Web forms, PDF forms and SPARQL application ...
Read more

Oracle BPM and Open Data Web Services with Open-XDX - Part ...

Developer level tutorial of using Oracle BPM with Open Data Web Services to build a working solution. We cover the details of configuring and ...
Read more

Oracle BPM

Oracle Process Cloud Service Launch Webcast (1:12) Webcast: Intelligent ... Why Oracle BPM? Oracle helps your enterprise excel in process management by ...
Read more

Oracle Business Process Management - Fundamentals of BPM

Oracle Business Process Management ... Click Data Association to open Data ... A new project will be created and added as part of the Oracle BPM ...
Read more

Oracle Business Process Management Suite 12 c

Oracle Business Process Management Suite 12c ... What's New in Oracle BPM 12c; Data sheet: ... for online citation services, ...
Read more

Working with BPM Projects - 11g Release 1 (11.1.1.7)

4 Working with BPM Projects. ... 4.1 Introduction to Oracle BPM Projects. ... including data objects, services, Business Rules, ...
Read more

Oracle® Fusion Middleware - Oracle Help Center

3.3.1 Oracle BPM Project ... 25.3.4.1 How to Create Service Data Object ... an exported Oracle BPM project or from Oracle BPM MDS. To open a project: 1.
Read more

Comparing a brand new Oracle Proces Cloud Service (PCS ...

... with traditional on-premise Oracle BPM Suite - part 1 By Lukasz Romaszewski-Oracle on Aug ... New Integration Model with Oracle SOA Cloud Service ;
Read more