Multi Value Solving real world integration issues International

Multi. Value, Solving real world integration issues. International Spectrum Conference 2008 Nick Kelly – Product Manager Mark Fuller – Support Manager

Who is Northgate? • You might remember…. . ► Microdata ► Mc. Donnell Douglas ……. . All part of Northgate’s history! 2

About Northgate • • 3 Reality the first commercial Multivalue release (1974) 38 years + experience (company established in 1969) 06/07 revenue of $1. 1 billion ($1, 100 million) Company worth $2 billion ($2, 000 million) Approximately 6, 500 staff 46 locations worldwide Head Office: Hemel Hempstead, UK

Introduction • Need to integrate with external data sources? ► Publish your software as web services, ► Work with XML? • Walking through real challenges, ► We'll show you how our clients are solving real integration issues Police Force ► Largest UK building material supplier ► World renowned University ► ► 4 All Using Northgate's Reality.

Success 1 – UK Police Force • Challenge ► Integrate new Northgate Crime System with existing force systems, including Command & Control ► CRM Call Handling ► Central government reporting (NMIS) ► Force Personnel system ► Force Corporate Gazetteer ► Single View Policing, Unified front end via Web ► Email / SMS systems ► 5

Success 1 – UK Police Force CRM System Crime Reporting Address Updates Corporate Gazetteer Crime Statistics NMIS Government Gateway Crimes Reported Via 911 Reality Crime System Crime View Update Email / SMS SMTP Email Server Personnel Uplift Force Personnel System Single View Policing 6 Force Command & Control System

Success 1 – Command & Control • • Goal of the interface ► Pass reported crimes from C&C to the Crime system ► Issue Crime numbers to C&C Behaviour ► Real-time ► Fault-tolerant Target System Force Command & ► Oracle Control System Crimes Reported Via 911 Interface ► SQL (ODBC) into Reality Crime System 7

ODBC / SQL Support • ODBC Application e. g. MS Excel ODBC Driver • • • Reality SQL Service • • Reality Data 8 SQL Catalog SQL Manager • Utilize Relational Applications Supports Stored Procedures Application DBMS Portability Transparent SQL/MV Mapping Read, Write, Update Excellent Performance Successful implementations of Reality as a relational database

SQL Demo – (contact us for details…) 9

Success 1 – CRM – Call Handling • Goal of the interface ► Pass reported crimes from call handling to the Crime system ► Issue Crime numbers Real-time ► Fault Tolerant ► • • CRM System Target System ► Third Party Application Interface ► Web Services Crimes Reporting Reality Crime System 10

Web Services • With Reality see how easy it is to expose Data. Basic routines as Web Services ► Offer your services across: ► ► Machine, Intranet & Internet Integrate disparate applications Seamless integration for GUI applications Can communicate with any language supporting web services JAVA ► Microsoft suite via. NET (office, VB C# etc) ► etc ► ► 11 Platform independent

Web Services Demo – (contact us for details…) 12

Success 1 – Central Government Reporting (NMIS) • Goal of the interface ► Pass Crime information as mandated by Central Government Batch Update ► High Data Volumes ► • • Target System ► Northgate application Interface ► Data exchange via flat CSV files Reality Crime System Crime Statistics NMIS Government Gateway 13

External File Integration • Reality Environment Transparently Integrate with external Data stores ► Tables in local or remote relational Databases ► ► Oracle, SQLserver, My. SQL, etc. CSV, Tab Separated, etc. Reality File 1 2 O/S File ODBC DB 1, 2, 3 A, B, C 1 2 3 A B C 14 1^2^3 A^B^C

CSV Demo – (contact us for details…) 15

Success 1 – Force Personnel system • Goal of the interface ► Import personnel information from Force Personnel system Regular scheduled scan of Personnel system ► Back-off if Force Personnel system off-line ► ► Third Party Application (Cedar) ► • Oracle (on AIX) Interface Reality Crime System ► SQL ODBC from Reality Personnel Uplift Force Personnel System 16

SQL-View • Allows Reality to Access and Update data from any ODBC data source, in its native ODBC format. ► 17 Allows Reality Applications to exchange data with ODBC databases.

SQL View Reality SQL View Local or Remote ODBC DB Restrictions. No record locking No Indexes 18 Table Stored and viewed as individual fields. Table

SQL View Demo – (contact us for details…) 19

Success 1 – Corporate Gazetteer (Address database) • • Goal of the interface ► Synchronise the Crime address data with the force central gazetteer Behaviour Real-time ► Large Data Volumes ► Back-off if gazetteer system off-line ► • Target System ► Northgate Compass Application Written in Java ► On Oracle ► • Interface ► Web services Passing XML Corporate Gazetteer 20 Address Updates Reality Crime System

XML Parser • More and more information is passed in XML format ► Easily create and extract data from XML documents ► Very simple to build documents ► Driven by simple to construct queries ► Highly performant Coded in ‘C’ ► Parser into a DOM tree ► 21

XML Parser Demo – (contact us for details…) 22

Success 1 – SVP • • • Goal of the interface ► Present & Update Crime information on a common front end Behaviour Reality Crime ► Realtime System Target System ► Northgate Single View Policing Application Written in Java ► On Reality ► • 23 Interface ► Call remote Data. Basic routines (JReal) ► Data access via SQL (JDBC) Crime View Update Single View Policing

JDBC / SQL Support • • Java Application, or Servlet • JDBC Driver • • Reality SQL Service Reality Data 24 SQL Catalog SQL Manager • Utilize Relational Applications Application DBMS Portability Transparent SQL/MV Mapping Read, Write, Update Excellent Performance Successful implementations of Reality as a relational database

JReal • JReal Client • • • Web Server JReal App JReal Servlet • • Reality Environment 25 Create New MV Applications in Java Latest GUI Look and Feel Increased Portability Retain Existing Business Rules Access To Vast Toolset Library Client, Server, or Web-server Call Data. Basic Subroutines from Java Access Reality MV Data

Success 1 – Email / SMS notifications • Goal of the interface ► Send Email and SMS messages from the Crime system • Target System ► SMTP Mail Server • Interface ► Sockets from Data. Basic Reality Crime System 26 Email / SMS SMTP Email Server

TCP/IP Sockets • • Email server Any Other Application • Reality Environment 27 Communicate with other applications Allows Data. Basic programs to interact with non-Reality programs via high performance Sockets Locally, remotely, intranet, Internet Reality Environment

Sockets Demo – (contact us for details…) 31

Success 1 – UK Police Force CRM System Web Services Corporate Gazetteer Crime Reporting Address Updates Web Services Crime Statistics NMIS Government Gateway CSV Files Force Command & Control System Crimes Reported Via 911 SQL ODBC Inbound Reality Crime System JReal Crime View JDBC Update Single View Policing 32 Email / SMS TCP/IP Sockets SMTP Email Server Personnel Uplift SQL ODBC Outbound Force Personnel System

Success 2 – • • 33 Largest UK building material supplier integrates with the Web Challenge ► Provide an online catalogue and ordering system Behaviour ► High performance ► High user count (8000 users!) ► Resilient Target System ► Web Browsers Interface ► HTML

Reality case study (wholesaler & retailer) Main stock hub, 50 gb database, 1500 users, also acts as main web server using Real. Web. Each branch machine handles between 1800 & 2300 processes (300 printers) and covers approx. 100 outlets each across the UK. Branches can operate autonomously from main hub. All machines are Fail. Safe databases and make extensive use of transaction boundaries 34 7 million updates per day per machine, peaking at 24 million

Real. Web • Browser URL Real. Web Servlet HTML Web Server Web Platform HTML • • Reality Environment 35 Web-Enable Existing Applications Retain Existing Business Rules Utilize Existing Skills Data. Basic Subroutines Addressable Via URLs HTML Pages Created From Data. Basic Dynamic Data Merging Store Images, HTML Pages and Javascript Functions In Reality

Success 3 – Publishing arm of world renowned UK University • Challenge ► Reduce error rate of picking and packing exam papers ► • • • 37 Integration with warehouse hand-held devices Behaviour ► Real-time ► Fast response ► Simple to implement Target System ► Handheld Wi. Fi Barcode readers Interface ► Web Services

Cambridge University Press Web Service Call CUP’s Reality System 38 Wifi Access Point Barcoded Exam Paper Handheld Device With Barcode Reader

Success 4 – Designbais • • 39 Goal ► Port to Reality Interface ► Calling Data. Basic routines from Front-end Server

Reality Active. X Connecter • • Reality Active X Client driver Reality Environment 40 • Call Data. Basic from Active. X capable environments Access Reality MV Data via Data. Basic Call Data. Basic from: ► VB. net ► C++ ► Delphi ► etc

Reality Key External Request Internal Request Calling Data. Basic 41 Peer to Peer

Reality Solves your integration issues. For more information visit the Northgate stand or www. northgate-is. com/reality. 42