OpenHAB DataLogger used to connect to OpenHAB RestAPI and store data to MS SQL server made due to missing support in OpenHAB for MSSQL.
Early stage, only support simple connectivity using MS SQL login user and an open OpenHAB RestAPI connection.
Default storing is set to 60 seconds.
Feel free to download, edit, make improvements to the code if you want.
Tested with MS SQL running on linux server, and running this program on Windows Server 2019.
Configure using
- IP of MSSQL server, port can be ommitted if it is default 1433.
- Database name of your OpenHAB database in MSSQL
- User and pw for user with access to your OpenHAB Database on MSSQL server.
- OpenHAB IP and Port to access OpenHAB RestAPI
To open items API web page, right click and click "Link"
Using a rolling logger to log errors that might occur.
Example of error in log: