M2M SQL Connector

The M2M SQL Connector is a host based service which allows our M2M Control telemetry units to communicate directly with SQL databases (MS SQL Server, MySQL). Any data or data logs from remote units can be stored in SQL databases using GPRS based networks.

This solution has the advantage that the remote units exchange their data directly with SQL databases without any individual programming or software in between. The M2M SQL Connector constitutes an open interface for any remote application.
 

Metering data, temperatures or any other measured data can be stored in a hosted based SQL database. Data ca be stored also in the internal data logger and transferred at predefined times.

Advantages:

• direct communication with SQL database
• no limits for the SQL statements
• scalable (multi user / multi databases)

Characteristics:

• runs as Windows Service
• Microsoft SQL Server or MySQL Databases
• supports the M2M Control Gateways
• multiple databases can be used
• secure transactions
• optional encryption 

System requirements:

• Pentium 500 or better
• Minimum 1024 MB RAM
• Minimum 5 GB free space on hard disk
• Windows 2000/XP
• Network interface
  
  
• Microsoft SQL Server (2008) oder
  MySQL (Version 5.x)