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

Table View to SQL, WinCC v15 Pro

3/13/2019 2:50 PM	Rate (0)
Sparisse Regular Member Joined: 1/6/2015 Last visit: 4/7/2025 Posts: 2 Rating: (0)	Is it possible to read from an SQL DB table and populate that data into Table View graphic on the WinCC v15 Pro? Assume, that I would be doing this through scripting in VB.

Suggestion To thank Quote Answer

3/20/2019 4:31 PM	Rate (1)
Murof Platinum Expert Joined: 8/3/2009 Last visit: 4/17/2025 Posts: 15311 Rating: (1894)	Hello Sparisse in this FAQ it is shown how to connect to a SQL Server Database: https://support.industry.siemens.com/cs/ww/en/view/61883659 It also worked in WinCC Professional. To display the Data in the WinCC you need a Datagrid Control or you use the recipe System (UserArchive) for this Topic. Bye Murof
	Last edited by: Murof at: 3/20/2019 4:31:16 PM If this Information really helps, you could use the Rate function
Suggestion To thank Quote Answer

11/20/2019 12:43 PM	Rate (0)
farnazbhmni Posts: 7 Rating: (0)	I've checked but it doesn't work in WinCC pro. because there is no place to insert DSN name(ODBC)! do you know the solution? Murof Hello Sparisse in this FAQ it is shown how to connect to a SQL Server Database: https://support.industry.siemens.com/cs/ww/en/view/61883659 It also worked in WinCC Professional. To display the Data in the WinCC you need a Datagrid Control or you use the recipe System (UserArchive) for this Topic. Bye Murof
farnazbhmni Posts: 7 Rating: (0)
Suggestion To thank Quote Answer

11/22/2019 3:13 PM	Rate (0)
Murof Platinum Expert Joined: 8/3/2009 Last visit: 4/17/2025 Posts: 15311 Rating: (1894)	Hello Of course it works also in WInCC Prof. The example for WinCC Advanced uses a Start Parameter for the Script where the DSN Name is set. So have alook in the documentation of the FAQ on Page 7 (for example) You can also use the String directly in the Script and not with Script Parameter. Bye Murof
	Last edited by: Murof at: 11/22/2019 15:14:15 If this Information really helps, you could use the Rate function
Suggestion To thank Quote Answer

Share this page:

Share this page on...