PeakHMI has support for external databases via ODBC (Open DataBase Connectivity). This allows any database that supports ODBC to be used for importing and exporting data. All the databases we evaluated provide ODBC drivers, including Excel which is not a database.
The table format was fixed to provide for maximum speed. While that goal was met it was not very friendly for recipe support or other ad hoc access requirements.
We added a new 'port' which allows for reading and writing to any table's row and field, on demand. The port can be configured to read/write data to the database continuously or under script control. The data to access in the database is also under script control. Reading and writing are separate and under script control.
While the fixed access type continues to exist the flexible access type might be more suitable for some applications.
Testing on the analog board is in progress. The target list price is $400.00, shipping included.
Work on the report generation unit for PeakHMI is in progress.