12-11-2017 03:54 PM
My IT Department is asking if the Lookout is using a SQL Database that they can backup using simple SQL Queries. What should I tell them?
Thanks
12-26-2017 01:22 AM
Hi, Citadel is based on Microsoft SQL Server 2008 R2 Express, it also has ODBC driver, so it can be accessed by other software, I believe the following link can be helpful.
Accessing Citadel 5 Data from Other Software
http://www.ni.com/white-paper/6668/en/
12-27-2017 03:26 PM
Thanks for the info. My IT guy says that in order for us to link to the SQL Database we need to know the SA Password. Do you know how I can find that?
Thanks.
12-27-2017 07:26 PM
The defult password is computer ID. You can take the following link as a reference.
http://digital.ni.com/public.nsf/allkb/C51D6FD1B83CA31086257C990016B5DC
02-28-2018 10:19 AM
The SQL server only stores Events and Alarms, all data is stored in the proprietary Citadel format.
That being said getting the data is relatively easy.
PS: I am not too far from you, Victorville. Also work with many districts in your area already: DWA, MSWD, etc.