SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Dashboard Automation
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Villanuev
Constraint Violating Yak Guru

440 Posts

Posted - 05/22/2014 :  22:14:25  Show Profile  Reply with Quote
Hi,

I have a project that assign to me to do an automation of production Dashboard.
This dashboard will be installed in 10 different lines and the result will be displayed or show
to 32" LCD monitor. THe result will be a real time or maybe delayed fo a few minutes.


In production, it composed of 10 lines, In every lines will be monitored how the production output is being done,
so that in case there will be a deficit or gap they can heads up the operator to speed up the line output.

1. The data is coming from SQL Database.
2. The Dashboard composed of 3 to 5 pages with different process from quality, output, performance.
3. It should be scrolled down. can setup the timer to scroll down the pages to be displayed.
4. This will be installed in 10 different lines.
5. The data displayed in the Dashboard is realtime or it can be setup the extraction using timer.

My Question is what particular software/application should be used to create this dashboard?
Will be this work in SSRS? Any idea guys? Thank you very much.


Jov...

tkizer
Almighty SQL Goddess

USA
36674 Posts

Posted - 05/23/2014 :  11:33:48  Show Profile  Visit tkizer's Homepage  Reply with Quote
At my previous company, the NOC used Sitescope for things like this.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Villanuev
Constraint Violating Yak Guru

440 Posts

Posted - 05/25/2014 :  21:43:02  Show Profile  Reply with Quote
Hi tkizer,

Can you give me an overview how this Sitescope perform.
How can i pull the data in SQL server using Sitescope?
Is this compatible in MS SQL? Maybe this is a third party software to deploy and operate the dashboard in LCD monitor.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36674 Posts

Posted - 05/26/2014 :  20:04:15  Show Profile  Visit tkizer's Homepage  Reply with Quote
I can't provide even an overview of it as I had no interaction with it. The NOC completely handled it. Yes it supports MS SQL Server as well as many other technologies.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Villanuev
Constraint Violating Yak Guru

440 Posts

Posted - 05/26/2014 :  21:57:14  Show Profile  Reply with Quote
btw, what is NOC?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36674 Posts

Posted - 05/26/2014 :  22:05:16  Show Profile  Visit tkizer's Homepage  Reply with Quote
NOC=Network Operations Center

I am summarizing and from only a DBA's point-of-view...It's a group within IT that monitors the production environment 24x7. They use various monitoring tools, such as Sitescope, to monitor production, check for issues and alert as needed.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Villanuev
Constraint Violating Yak Guru

440 Posts

Posted - 05/29/2014 :  00:49:58  Show Profile  Reply with Quote
Hi tkizer,

I got an info that it can be done in SSRS. i have to build it in SSRS to create the reports. use the web browser to displayed in LCD monitor. to open the ssrs link they said to use a script to open the ssrs link and also the scheduled on how to displayed it in web browser.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000