0

Is it possible to connect ComfortClick to SQL?

Sigurpáll Sindrason 3 days ago in bOS Configurator updated by Jürgen Jürgenson 1 day ago 1

Hi,

Would it be possible to connect Data Logs or Analog Logs to a SQL for storing? Or automatically export/backup Data Logs and Analog Logs in SQL format.

I know it is possible manually. I'd need it done automatically


Regard.

In windows servers this should also work: https://support.comfortclick.com/communities/4/topics/11059-backup-server You could only export the data folder or you can make a command for each .db file. Or make a script that connects them do your SQL. 

You can find out the logs .db location from the logs Info tab. bOS data folder is stored here: C:\Windows\System32\config\systemprofile\AppData\Roaming\BOS\BOSServer\Building\Data

Image 5383