M2M Control 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, Postgres). 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 can 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)


Supported Databases:  


                   

 

 

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

 

System requirements:

  • Pentium-class 2 GHz or better
  • Windows 8/Windows 7/Vista/2003 Server/2008 Server/2010 Server.
  • Minimum 2 GB MB RAM
  • Minimum 5 GB available space on hard disk.
  • permanent internet connection with fixexd IP adress

  • Microsoft SQL Server (2008) or
    MySQL (Version 5.x) or
    Postgres SQL Database

 

No downloads

No accessories