Roboticsware Support

The following databases are supported by the FA-Panel action/control function.(The action allows you to select a CSV file as the data store, so you can operate without installing a database.)

Feature		SQL Server	Oracle	MySQL	PostgreSQL
Action	Historical data server(ODBC) (Historical data acquisition)	○	○	○	○
	Logger(ODBC) (Logging)	○	○	○	○
	Batch transfer(ODBC -> tag) (Write to tag from DB)	○	○	○	○
	Batch transfer(Tag -> ODBC) (Write from tag to DB)	○	○	○	○
	Execute SQL(ODBC) (Issue the SQL command.)	○	○	○	○
	Summary(ODBC) (Logging + Aggregation)	○	○	○	○
	Alarm server(ODBC) (Alarm monitor)	○	○	○	○
Controls	Remote Query Database Control (Query execution from "Panel Browser")	○	○	○	○
	Direct Query Database Control (Query execution from "Panel Browser")	○	○	○	○

*)This is the latest version of Ver6.
The versions supported by each database are as follows

DB	Support Version
SQL Server	2008～2019
Oracle	9i/10g/11g/12c
MySQL	5.6/5.7
PostgreSQL	9/10 *)The ODBC driver for PostgreSQL must be Ver. 9.6.410 or later.