eScada can read and write data on the major database engines: SQLite, MySQL and Firebird connectors are included, Microsoft SQL Server is supported, and on Windows the OleDB connector opens the door to Oracle and many other engines available on the market.
At the heart of the integration is the SqlCommand object: any SQL command, parametrised with live tag values, can be executed on event or on demand, synchronously or asynchronously, and the returned dataset is written back into project tags, ready to be displayed on the pages or processed by the application logic.
This means the HMI solution can do a bit of everything with your data: record production results and quality data batch by batch, read work orders prepared by company systems, feed reports and analysis tools, or exchange information with other applications through a shared database. Execution times, error counters and error descriptions are exposed for every command, making the integration robust enough for continuous production use.
Microsoft SQL Server is supported on both operating systems, Linux and MS Windows.