MultiValue, Solving real world integration issues'

1
MultiValue, Solving real world integration
issues.

• International Spectrum Conference 2008

Nick Kelly Product ManagerMark Fuller
Support Manager
2
Who is Northgate?

• You might remember..
• Microdata
• McDonnell Douglas

..All part of
Northgates history!
3
About Northgate

• 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

4
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
• All Using Northgate's Reality.

5
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

6
Success 1 UK Police Force
7
Success 1 Command Control

• Goal of the interface
• Pass reported crimes from CC to the Crime system
• Issue Crime numbers to CC
• Behaviour
• Real-time
• Fault-tolerant
• Target System
• Oracle
• Interface
• SQL (ODBC) into Reality

8
ODBC / SQL Support

• 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

9
SQL Demo (contact us for details)
10
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
• Target System
• Third Party Application
• Interface
• Web Services

11
Web Services

• With Reality see how easy it is to expose
  DataBasic 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
• Platform independent

12
Web Services Demo (contact us for details)
13
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

14
External File Integration

• Transparently Integrate with external Data stores
• Tables in local or remote relational Databases
• Oracle, SQLserver, MySQL, etc.
• CSV, Tab Separated, etc.

15
CSV Demo (contact us for details)
16
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
• SQL ODBC from Reality

17
SQL-View

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

18
SQL View
Restrictions. No record locking No Indexes
19
SQL View Demo (contact us for details)
20
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

21
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

22
XML Parser Demo (contact us for details)
23
Success 1 SVP

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

24
JDBC / SQL Support

• Utilize Relational Applications
• Application DBMS Portability
• Transparent SQL/MV Mapping
• Read, Write, Update
• Excellent Performance
• Successful implementations of Reality as a
  relational database

25
JReal

• 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 DataBasic Subroutines from Java
• Access Reality MV Data

26
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 DataBasic

27
TCP/IP Sockets

• Communicate with other applications
• Allows DataBasic programs to interact with
  non-Reality programs via high performance Sockets
• Locally, remotely, intranet, Internet

28
TCP/IP Sockets

• What is a socket?
• Location on a network or local machine
• Addressed as TCP/IP port, for example
  196.168.1.41, Server2, Localhost343
• How do you use a Socket
• One program listens and waits
• One or more Connects
• Pass data between programs
• Either Side can disconnect

29
Sockets, Reality listening
30
Sockets, Reality Calling
31
Sockets Demo (contact us for details)
32
Success 1 UK Police Force
33
Success 2 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

34
Reality case study (wholesaler retailer)
Main stock hub, 50gb database, 1500 users, also
acts as main web server using RealWeb.
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 FailSafe databases and make
extensive use of transaction boundaries
7 million updates per day per machine, peaking at
24 million
35
RealWeb

• Web-Enable Existing Applications
• Retain Existing Business Rules
• Utilize Existing Skills
• DataBasic Subroutines
• Addressable Via URLs
• HTML Pages Created From DataBasic
• Dynamic Data Merging
• Store Images, HTML Pages and Javascript Functions
  In Reality

36
RealWeb Demo (contact us for details)
37
Success 3 Publishing arm of world renowned UK
University

• Challenge
• Reduce error rate of picking and packing exam
  papers
• Integration with warehouse hand-held devices
• Behaviour
• Real-time
• Fast response
• Simple to implement
• Target System
• Handheld WiFi Barcode readers
• Interface
• Web Services

38
Cambridge University Press
39
Success 4 Designbais

• Goal
• Port to Reality
• Interface
• Calling DataBasic routines from Front-end Server

40
Reality ActiveX Connecter

• Call DataBasic from ActiveX capable environments
• Access Reality MV Data via DataBasic
• Call DataBasic from
• VB
• VB.net
• C
• Delphi
• etc

41
Reality
Key
External Request
Internal Request
Calling DataBasic
Peer to Peer
42
Reality Solves your integration issues.
For more information visit the www.northgate-is.co
m/reality.