Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

SQL database and WinCC

Created by: Pandiani at: 11/8/2006 9:45 AM (10 Replies)

Rating (1)

Thanks 0

Result pages:: |; 1 | 2; |

11 Entries

Entries per page: 10 | all

11/8/2006 9:45 AM	Rate (0)
Pandiani Bronze Member Joined: 10/31/2005 Last visit: 9/4/2024 Posts: 366 Rating: (31)	Hello people, Please can someone suggest any good link with appropriate manual aboput winCC and its SQL datbase. I want to write values of few analog and binary variables (external tags) to SQL database, and then to make a coulpe SQL quries on that database. I'm beginerand never worked with WinCC's SQL before. I want to learnbasics. Do you know where to find manual where there is a small example (if such exist). Thank you

Suggestion To thank Quote Answer

11/8/2006 12:58 PM	Rate (0)
Nemo Posts: 3149 Rating: (171)	Hi, I think this issuehas been already discussed several times in the Forum. You should NEVER fumble in the WinCC database directly. Please use tools like WinCC IndustrialDataBridge or ConnectivityPack: http://support.automation.siemens.com/WW/view/en/22578952 nemo
Nemo Posts: 3149 Rating: (171)
Suggestion To thank Quote Answer

11/8/2006 3:10 PM	Rate (0)
Pandiani Bronze Member Joined: 10/31/2005 Last visit: 9/4/2024 Posts: 366 Rating: (31)	Thank you Nemo for the reply. I don't have any experience and need general informations about how process data can be shown on office network. i know that every installation of wincc include SQL server. I assume that SQL server is needed because after every time period marked data is written to database. I'm interested to learn how this data can be seen in office network. Does databridge or connectivity pack have needed capabilities to read data from SQL base and displayed them for example through internet explorer? I assume that user cannot acces and perform SQL queries on database directly, that would be very dangeruos, but insted have some software interface which enable reading, since writing is done by WinCC itself.

Suggestion To thank Quote Answer

11/8/2006 3:59 PM	Rate (0)
Nemo Posts: 3149 Rating: (171)	Hi if you just want to show some data Dat@monitor could bei an option for you as well: http://support.automation.siemens.com/WW/view/de/19300688 http://support.automation.siemens.com/WW/view/en/17626868 nemo
Nemo Posts: 3149 Rating: (171)
Suggestion To thank Quote Answer

11/8/2006 5:03 PM	Rate (0)
Danielle Posts: 1275 Rating: (123)	Take a look at /tf/WW/en/Posts/1487
Danielle Posts: 1275 Rating: (123)
Suggestion To thank Quote Answer

11/9/2006 7:44 AM	Rate (0)
Pandiani Bronze Member Joined: 10/31/2005 Last visit: 9/4/2024 Posts: 366 Rating: (31)	Thanks for your replies. Actually I'm doing a small research, something like a homework. I only have wincc 6.0 demo cd and don't have any other software such as connectivity pack or Industrial databridge. I just want to learn more about exporting process values from WinCC database (that is MS SQL database). I know that probably the easiest way is to use either WinCC/Dat@Monitor or WinCC/Connectivity Pack. I want to know if Dat@Monitor is used under web navigator, so that process values can be shown on web page from any location if user has appropriate user access rights and internet explorer. If this is true, does that means that computer on which is WinCC installed and which stores process data in database must be configured as Web Server? Also, does any other computer that is used to access data needs to be configured as Web Client or? Also, can you suggest documentation link about connectivity pack? I searched Siemes web page but didn't find manual in pdf where basics of connectivity pack is explained. Am I at the right track?

Suggestion To thank Quote Answer

11/9/2006 11:34 AM	Rate (1)
Danielle Posts: 1275 Rating: (123)	This is from WinCC help: WinCC/Dat@Monitor WebEdition The Dat@Monitor serves for display and evaluation of current process statuses and historical data on office PCs. For this purpose, you can use standard tools like Microsoft Internet Explorer or Excel. The Dat@Monitor is supplied from a Web Navigator server with current and historical process data. Apart from this, the access to a long-term archive server with Web server is also possible. For display purposes, you can use pictures from the WinCC project or configure special overview pictures. The Dat@Monitor will only have a mere display function - no intervention into the on-site process flow possible. The more important the evaluation opportunities: The user can make use of prefabricated templates for process analysis (e.g. reports, statistics) or compile online historical data according to individual criteria. Licensing is based on the server. Depending on the license selected, 3, 10, 25 or 50 clients can be active at the same time. These links may have some further information: https://support.automation.siemens.com/WW/skm/frameset.asp?url=%2FWW%2Fllisapi%2Edll%2F19300688%3Ffunc%3Dll%26objId%3D19300688%26objaction%3Dcsopen%26siteid%3Dcseus%26aktprim%3D0%26skm%3D1%26lang%3Den&Query=connectivity+pack&SearchArea=faqs&id=19300688&F11Marker=true&siteid=cseus&query2=&modelled=Connectivity+Pack&lang=en https://support.automation.siemens.com/WW/skm/frameset.asp?url=%2FWW%2Fllisapi%2Edll%2F22578952%3Ffunc%3Dll%26objId%3D22578952%26objaction%3Dcsopen%26siteid%3Dcseus%26aktprim%3D0%26skm%3D1%26lang%3Den&Query=connectivity+pack&SearchArea=faqs&id=22578952&F11Marker=true&siteid=cseus&query2=&modelled=Connectivity+Pack&lang=en Also... The WebNavigator server needs to have WinCC installed on it. The Web clients access the Web server, and all the processing is done in it. The Web clientmay beany computer accessing the internet, with a compatible version of WinCC Explorer. By accessing the Web Server's IP the user is prompted to a page to install the Web client option, which means that the computer doen't necessarily need to have the Web Client option installed on it to begin with. Is it clearer now? Best regards, Danielle
Danielle Posts: 1275 Rating: (123)	Last edited by: Danielle at: 11/9/2006 11:54 AM Last edited by: Danielle at: 11/9/2006 11:40 AM
Suggestion To thank Quote Answer

11/9/2006 4:28 PM	Rate (0)
Pandiani Bronze Member Joined: 10/31/2005 Last visit: 9/4/2024 Posts: 366 Rating: (31)	Thank you Danielle, it is much clearer now. I have also one question. Is Dat@Monitor separate application from Web Navigator? From what I read it appears so. I know that, graphical representations , for example, as well as data table exporting to various files can be done with Dat@Monitor and it's Dat@View.

Suggestion To thank Quote Answer

11/10/2006 9:13 AM	Rate (0)
Salma Gold Member Joined: 9/27/2005 Last visit: 11/27/2007 Posts: 1398 Rating: (151)	Yes they are separate applications. WebNavigator gives you full control graphics in IE. DataMonitor gives you read-only graphics in IE.

Suggestion To thank Quote Answer

11/10/2006 11:43 AM	Rate (0)
Danielle Posts: 1275 Rating: (123)	As Salma said, Dat@ Monitor provides viewing only, while Web Navigator allows the web user to control the plant as well. Therefore you must analyse the customer's needs to find out which one will fit better and while using Web Navigator be careful when setting user permissions and controls, since they will be affecting the plant remotely. [:)]
Danielle Posts: 1275 Rating: (123)
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on