Open Data API delivery “Open-XDX”

1. Open Data Exchange Open Data API delivery “Open-XDX” David Webber, Information Architect, Oracle Public Sector

2. The following is 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. Open Data Digital Strategy Vision "Open Data is the new default… anywhere, anytime on any device, and everything should be APIs" Steven VanRoekel Federal CIO – Whitehouse Digital Strategy Architect

4. Open Data APIs explained • Internet-based secure information delivery • Public information – such as road works, health services, voting • Private information – patient data, student data, company data • API “Application Programming Interface” • e.g. computer to computer exchanges • “Open Data” – standards-based information formats • e.g. XML-based (such as NIEM* exchanges) *NIEM – see NIEM.gov – National Information Exchange Model

5. Oracle Open Data Solution – Open-XDX • Open-XDX is an all new component designed to deliver rapid Open Data APIs • Integrates into Oracle Fusion Middleware foundation and SQL database products (MySQL, Oracle DB) • Uses XML configuration templates and code-less methods and open source NIEM tools • Allows plug-and-play delivery for Oracle customers and applications

6. Integration Conceptual ViewOpen XDX deployment Data Delivery Design Test Deploy SQL CAM Editor DB XML Open XDX Open XDX FMW SQL XML CAMV • Device • Browser • Server Web • Generate Data • Validate Data • Send Data • Visual Editor • SQL Browser • Dictionaries • Drag and Drop • Open XDX • Web Services • FMW / BPM

7. Open XDX - Conceptual Overview Data Exchange Existing Information Databases Control template contains information of the exchange structure design and DB mapping rules of data tables and columns SQL SQL Template JDBC connection Rapid Deploy Structure Open-XDX Rules Configuration DB Mappings Parameters Send Open Data XML

8. Option #1 – Visual Mapping Mode Data Exchange Mapping Data store connection wizard XML structure viewer Control template contains information of the exchange structure design and DB mapping rules of data tables and columns Drag and Drop Mappings Template Structure Rules Store Configuration Database schema viewer DB Mappings Parameters • Individual column assignments made as DB mapping rules to existing XML structure layout; • Original XML layout imported from industry schema (such as NIEM PMIX shown here) Existing application SQL tables; e.g. Oracle Healthcare, E-Business Suite, custom system, etc.

9. Option #2 – Visual Designer Mode Data Exchange Design XML structure viewer Drag and Drop Designer EMPTY (Patient Report) Database schema viewer • Start with new empty XML structure; • Toggle database viewer to designer mode.

10. Visual Designer Mode Data Exchange Design XML structure viewer Control template contains information of the exchange structure design and DB mapping rules of data tables and columns Drag and Drop Designer Drag and Drop of Table Template Structure Rules Store Configuration Database schema viewer DB Mappings Parameters • Drag and Drop table into XML structure • Complete XML structure components automatically inserted (with DBMappings); • All component names / definitions conform to NIEM NDR (smart rename wizard converts SQL to XML)

11. Demonstration – Open-XDX Data Generation Oracle Tools Data Exchange SQL 2 XML Designer Existing Information Open-XDX MySQL Workbench 1 Generate Application Data Tables Send Open Data XML Live Data Demo 3