Lookout

cancel
Showing results for 
Search instead for 
Did you mean: 

I need to know if Lookout 6.7.1 uses Microsoft SQL for it's Database.

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 

SCADA Programmer at the Coachella Valley Water District.
0 Kudos
Message 1 of 5
(2,283 Views)

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/ 

0 Kudos
Message 2 of 5
(2,217 Views)

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. 

SCADA Programmer at the Coachella Valley Water District.
0 Kudos
Message 3 of 5
(2,213 Views)

The defult password is computer ID. You can take the following link as a reference.

http://digital.ni.com/public.nsf/allkb/C51D6FD1B83CA31086257C990016B5DC

0 Kudos
Message 4 of 5
(2,209 Views)

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.

 

 

-----------------------------------------------------------------------
Forshock - Consult.Develop.Solve.
0 Kudos
Message 5 of 5
(2,061 Views)