Quick Tutorial – Part 1 Using Oracle BPM with Open Data Web Services

1. Quick Tutorial – Part 1Using Oracle BPM with Open Data Web Services • August, 2013 Health and Human Services Child Welfare Example • David Webber and Serge LeontievPublic Sector NIEM Team

2. 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. DisclaimerNotice

3. 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

4. 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

5. 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

6. 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

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

8. Application Demonstration Note: All names and details used are completely fictitious

9. Development Conceptual View Design Test Deploy Delivery SQL CAM Editor DB XML SQL XML Open XDX Open XDX BPM • Device • Browser • Server • Generate Data • Validate Data • Share Data • Visual Editor • SQL Browser • Dictionaries • Drag and Drop • Open XDX • Web Services • Oracle BPM CAMV BPM

10. Conceptual Architecture Components Deployed Application Systems Oracle BPM 1 3 User Forms 4 2 User Forms Courts Systems (NIEM)

11. 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

12. Component Overview – Open-XDX Mapping Services with XML CAM Template + mapping + rules SQL JDBC connection • 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 Open-XDX = Open XML Data eXchange services (‘open data’) Open-XDX Engine XSD schema content definition Web Service (WSDL) XML instance generated

13. Capability – Visual Data Mapping Editor Target XML Structure Case Management Database Drag and Drop

14. CAM Template Capability – CAM Editor Developer Tools Target Renderings (via XSLT transforms) Editing/XML/SQL/Mapping XSD Schema - required XML Content Structure MindMap Model CAM EDITOR UML Model XML Instance Rules XML Dictionary SQL Documentation HTML, XML, Excel Documentation

15. Component Overview – User Forms SQL JDBC connection • Associate XSD schema with BPM form • One click BPM form generation from schema field definitions • Supports CRUD access to SQL data stores • Code free approach CAM Template Open-XDX = Open XML Data eXchange services (‘open data’) Open-XDX Engine XSD binding BPM User Form XML instance generated

16. Component Overview – Fillable PDFs CAM Template SQL JDBC connection • Import XSD schema into JDeveloper Java objects • 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 XML to PDF using Apache “PDFbox” Java class library Open-XDX Engine XML to PDF service XML instance generated

17. Component Overview – SNOMED lookup NIH SNOMED RDF dictionary Oracle Database • 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 RDF content is queried to retrieve semantic content SPARQL search Java Results Handler XML result generated

18. 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

19. 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

20. Open-XDX Specific Resources SNAPSHOT OF PROJECT ACTIVITIESShowcase site for integration exchanges using NIEM and Open Data Global Test bed initiative for Information Exchange (GITB) CAMV validation tools www.VerifyXML.org 20

21. CAMeditor.org Project Site • SNAPSHOT OF PROJECT ACTIVITIES165,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 www.niemtrainingvideos.org