+- Logic Machine Forum (https://forum.logicmachine.net)
+-- Forum: LogicMachine eco-system (https://forum.logicmachine.net/forumdisplay.php?fid=1)
+--- Forum: Scripting (https://forum.logicmachine.net/forumdisplay.php?fid=8)
+--- Thread: MS SQL database table reading (/showthread.php?tid=3943)
MS SQL database table reading - AlexLV - 22.03.2022
Hello,
is possible to read information from MS SQL Database?
Task - control ventilation when specified workers located at site. This data is in Access system SQL server specific table.
Can we do such reading somehow - export tables or part of it to KNX groups? Ventilation machine already integrated to system and it possible control from SL device.
BR,
Alexander
RE: MS SQL database table reading - admin - 22.03.2022
Direct connection to MS SQL server is not possible. There is Web Services API in SQL Server which can be used to interact with the server using HTTP calls but it requires some additional programming to make it work.
RE: MS SQL database table reading - AlexLV - 22.03.2022
OK,
thank you for showing road to be checked
Alexander