1 / 38

MultiValue, Solving real world integration issues.

MultiValue, Solving real world integration issues. International Spectrum Conference 2008. Nick Kelly – Product Manager Mark Fuller – Support Manager. Who is Northgate?. You might remember….. Microdata McDonnell Douglas. ……..All part of Northgate’s history!.

cayala
Download Presentation

MultiValue, Solving real world integration issues.

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 Northgate’s 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. Force Command & Control System Single View Policing CRM System Crime Reporting Crimes Reported Via 911 Address Updates Email / SMS Corporate Gazetteer SMTP Email Server Reality Crime System Personnel Uplift Crime Statistics Crime View Update NMIS Government Gateway Force Personnel System Success 1 – UK Police Force

  7. Force Command & Control System Reality Crime System Crimes Reported Via 911 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 • Oracle • Interface • SQL (ODBC) into Reality

  8. ODBC Application e.g. MS Excel ODBC Driver Reality SQL Service SQL Catalog Reality Data SQL Manager 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. CRM System Crimes Reporting Reality Crime System 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. Reality Crime System Crime Statistics NMIS Government Gateway 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. Reality Environment Reality File 1,2,3 A,B,C O/S File ODBC DB 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. Reality Crime System Personnel Uplift Force Personnel System 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. Reality SQL View Local or Remote ODBC DB Table Stored and viewed as individual fields. Table SQL View Restrictions. No record locking No Indexes

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

  20. Corporate Gazetteer Reality Crime System Address Updates 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. Single View Policing Reality Crime System Crime View Update 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. Java Application, or Servlet JDBC Driver Reality SQL Service SQL Catalog Reality Data SQL Manager 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 Client Web Server JReal App JReal Servlet Reality Environment 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. SMTP Email Server Reality Crime System Email / SMS 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. Email server Any Other Application Reality Environment Reality Environment 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. Sockets Demo– (contact us for details…)

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

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

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

  32. Browser URL HTML RealWeb Servlet Web Server RealWeb Servlet Web Platform HTML Reality Environment 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

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

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

  35. Success 4 – Designbais • Goal • Port to Reality • Interface • Calling DataBasic routines from Front-end Server

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

  37. Reality Key External Request Internal Request Calling DataBasic Peer to Peer

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

More Related