SQLxConnect

App for writing data and collections to an external SQL database

With the in.hub SQLxConnect app, you can write siineos data (e.g., I/O signals, app data records, or alarm signals) directly to MySQL, PostgreSQL, or MSSQL databases without writing any code.

SQLxConnect transforms edge data into true IT data. This is because many systems in production and IT use SQL or require data in SQL structures, e.g.:

  • MES (planning, reporting, key performance indicators)
  • CAQ (quality data, inspection history)
  • CMMS (maintenance, repairs, fault reports)
  • ERP/PPS (production, material flow, feedback)
  • Energy management (analyses, documentation, reporting)

However, many edge devices typically deliver data via OPC UA and MQTT, which not every IT system can interpret. Integration projects cost time and additional money. With SQLxConnect, any data arriving in siineos® from other actuators, sensors, devices, or third-party systems can be written to an SQL database and processed there.