SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

WINCC AND SQLSERVER

1/31/2015 9:29 AM	Rate (0)
Elyas Experienced Member Joined: 1/7/2013 Last visit: 1/20/2025 Posts: 26 Rating: (0)	Greetings How can send data from the sql server tables on the remot computer to another computer that is wincc runtime on it? Simultaneously with the change data from sql server, wincc values also change in the other computer. These values are displayed in wincc runtime. I used the WINCC 7 and SQL Server 2005 and Ethernet Network Thank you

Suggestion To thank Quote Answer

2/2/2015 1:45 PM	Rate (0)
bg2492 Posts: 7298 Rating: (2188)	Hello Elyas, for sending the data cyclically fro SQL-Server to WinCC, you could use the option "WinCC/IndustrialDataBridge". http://w3.siemens.com/mcms/human-machine-interface/en/visualization-software/scada/wincc-options/wincc-industrial-data-bridge/Pages/Default.aspx Provider: SQL-Server Consumer: OPC Data Access Regards Georg Berghof
bg2492 Posts: 7298 Rating: (2188)
Suggestion To thank Quote Answer

2/9/2015 9:39 AM	Rate (0)
Elyas Experienced Member Joined: 1/7/2013 Last visit: 1/20/2025 Posts: 26 Rating: (0)	Thank you Please help me in this regard: How can the values of a table in sql server ، show in the WINCC? How can these values by pressing a button on the screen display wincc run time?

Suggestion To thank Quote Answer

2/9/2015 11:42 AM	Rate (0)
bg2492 Posts: 7298 Rating: (2188)	Hello Elyas, about what for tables do you speak ? If they are not belong to Taglogging or Alarmlogging, you could use the option Userarchive, what means, you can create Tables with your own structure in the WinCC as Userarchive. These tables with the data in them are stored in the RT-Database of the WinCC-project. You can display the data from the tables in a picture in WinCC-Graphics-Runtime in an UA-Table-OCX. Regards Georg Berghof
bg2492 Posts: 7298 Rating: (2188)
Suggestion To thank Quote Answer

2/10/2015 7:26 AM	Rate (0)
St3B0 Platinum Member Joined: 10/3/2010 Last visit: 12/18/2025 Posts: 1571 Rating: (196)	Elyas Thank you Please help me in this regard: How can the values of a table in sql server ، show in the WINCC? How can these values by pressing a button on the screen display wincc run time? instead of buying another option, you can also read/write SQL-data by writing scripts yourself searching this forum will give you some examples
	B r g d s , SIMATIC HMI in Online Support Forum
Suggestion To thank Quote Answer

2/14/2015 5:52 AM	Rate (0)
Elyas Experienced Member Joined: 1/7/2013 Last visit: 1/20/2025 Posts: 26 Rating: (0)	Thanks to a friend can You tell me for read/write SQL-data by writing scripts In WINCC? How can I establish a connection between sql server and user archive in wincc ?
	Last edited by: Elyas at: 2/14/2015 6:07:03 AM
Suggestion To thank Quote Answer

Share this page:

Share this page on...