Many, if not most, great systems are build around databases and structured data sets. It is quite powerful to store data from other instances (PLC's, sensors, meters, etc.) as structured data sets where you can utilize the data and keep history of it. This enables utilization of the data and can be used for a wide range of applications. Or even control your instances from a set of structured dataset such as getting the production order number in your factory and down into the machine.
Databases
Database which is a set of structured data have some specific language and set of queries that can be used. Most used language for queries to databases is SQL which comes in many variants.
SIA supports the following SQL languages and database Connectors:
| Database | Remarks |
|---|---|
| Microsoft SQL | |
| Azure SQL | |
| Oracle | Interface to Oracle databases using Oracle Call Interface |
| MySQL | |
| MariaDB | |
| InfluxDB | Using REST API Connector and InfluxDB API |
| Postgre SQL | |
| MongoDB* | |
| IBM DB2* | |
| SQLite* |
*Support for database on request