MobileDataNow Laptop

Use email, sms or instant messaging to
query database and webservice information

links inline

Technical Info

MobileDataNow is tested for and supported on Windows 2000, XP, Vista, Server 2003 and 2008.

Data Management

  • Connect to any new or legacy relational database system (DB2, Oracle, MS SQL Server, Sybase, MySQL etc) using ODBC or JDBC.
  • Connect to flat file single user databases (MS Access, Apache Derby, Berkeley DB, SQLite etc) using ODBC or JDBC.
  • Connect to simple and complex type SOAP web services using a WSDL url, dynamically invoking the web service without any coding.
  • Manage database connectivity centrally across one or more databases (User and Group level security).
  • Quickly create relevant views of your data.
  • Easy query builder: Create queries using natural language or write your own SQL statements.
  • Two types of data access, Named Users who require authentication to get access to data, or Public Messaging, for anyone to access data.
  • Retrieve, add or update existing data via queries.
  • Custom query values related to each user to let end-users retrieve data specific to them via generic queries.

Security

    User authentication. End-users are authenticated before queries are executed.
  • Group authentication. End-users are placed in to groups which have access permissions to certain data.
  • Full logging of queries for each user.
  • SSL and TLS support for email.
  • Configuration is managed locally behind the company firewall, only administrators can start services after configuration changes are made.
  • Users can be switched off or their permissions changed very quickly.
  • Optional password before query is sent.
  • Messaging controls to stop spamming by public users.

General

  • Query your data either by email, SMS text messaging or instant messaging. No dependencies on additional software.
  • Let users reply to messages for more information.
  • Reliable and stable with fail safe mechanisms.
  • Browser based configuration using the latest browser technology so it feels like a desktop application.
  • Upload and change the display language on the fly.
  • End users can use their phones which they are familiar with using.
  • Users can send 'help' and receive list of keywords, or 'help keyword' and get description of query

Messaging Protocols Supported

  • Email: IMAP and push-email. SSL and TLS. End-users can use any mail protocol (POP3, IMAP etc)
  • SMS: SMPP v3.4 for fast 2-way SMS messaging. GSM modems.
  • Instant Messaging: Yahoo, MSN, Jabber, GTalk, ICQ, AIM

Requirements

  • Make a server/computer available which has internet connectivity.
  • For connecting to databases, MobileDataNow already includes various database drivers but if your driver is not included, find a copy of the relevant JDBC driver from your database manufacturer or create an ODBC Data source in Windows.
  • Java version 6 or later installed. MobileDataNow also makes available a version with Java already included.
  • Connection to required messaging application/s:
    • Email: An email address/es for inbound messages is needed which uses IMAP (not POP3).
    • Instant messaging: An instant messaging account for inbound messages.
    • SMS: Either a GSM Modem (low volume, slow 6 sms/min, no internet connection needed) or an SMPP account at an SMS provider (high volume, fast 50 sms/sec, requires internet connectivity).


  • Components

    MobileDataNow contains the following components:
    1. MDN Server
    2. Tomcat Server
    3. Messaging Services


    1. MDN Server

    MDN Server is a non-graphical database server module. This is the application that communicates with your databases, handling remote data access, the RMI registry, notifications and messages and provides a common point of access to all data (including internal and external databases) for the other components in the MDN system. This component can optiontionally run on a separate database server.
    This module must be able to connect to the MDN configuration database using the supplied or 3rd party JDBC drivers.
    This module needs to connect to all databases that you wish to use data from, using the JDBC-ODBC bridge or 3rd party JDBC drivers.

    2. Tomcat Server

    The Tomcat server houses the graphical administration module and uses a flash based configuration tool inside a web browser. The browser uses http to communicate to the Tomcat server, which in turn communicates with the MDN Server to configure MDN.

    3. Messaging Services

    The other services handle the receipt and sending of messages from email, instant message or SMS.
    • MDN Mail Service: The Mail Service connects to your IMAP mail server and sends and receives email.
    • MDN Instant Messaging Service: The instant messaging service connects to various instant messaging services to send and receive instant messages.
    • MDN GSM Modem Service: The GSM Modem service connects to a GSM modem for sending and receiving SMS messages.
    • MDN SMPP Service: The SMPP service connects to an SMS provider for sending and receiving SMS messages at high speeds/volume.

    These messaging services can only be stopped and started by the server administrator.

How MobileDataNow Integrates into Existing Infrastructure

As middleware, MobileDataNow slots neatly in to an organizations existing infrastructure without any changes needing to be made. All configuration can be done behind the company firewall. The only services exposed are to the end user ie. email, instant messaging and sms, for which access would already be tightly controlled.

mobile data now integration diagram

Technical Component Diagram

mobile data now component diagram

MDN Configuration Database

This is where the configuration data to run MDN is stored. As supplied, this database is Apache Derby. You could specify that MDN use another database (say Oracle or SQL Server) for the local configuration. This may be preferable to some clients as this may be their internal database standard. MDN database issues are only supported on the default supplied databases.