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 RT Professional SQL Trend

5/15/2023 5:36 AM	Rate (0)
murat1290can Member Joined: 11/1/2019 Last visit: 12/19/2024 Posts: 1 Rating: (0)	Hello; I am using Wincc RT Professional and an OPC gets data from plc and logs them to SQL server. My Scada PC has acccess to that SQL server and i entered ODBC also can make changes with SQL tool. Are there any way to make historical trends with this SQL datas? I have seen that when i open that trend view there is a screen to see logged tags. Can I see the different SQL tags like this? it would be so easy for me. If I cant, how can i make historical trend view from different SQL? Thank you. Attachment sql1.png (308 Downloads)
	Last edited by: murat1290can at: 05/15/2023 05:38:51
Suggestion To thank Quote Answer

5/17/2023 8:57 AM	Rate (0)
serendipity0 Advanced Member Joined: 2/3/2022 Last visit: 4/23/2024 Posts: 304 Rating: (27)	Hi! In the data source section as it is indicated in the following link, you can select the tags from the files and that way be able to see the historical data. https://support.industry.siemens.com/cs/ww/en/view/109815056/58911064843 Br!

Suggestion To thank Quote Answer

5/17/2023 1:01 PM	Rate (0)
Murof Platinum Expert Joined: 8/3/2009 Last visit: 4/25/2025 Posts: 15355 Rating: (1895)	Hello murat1290can you usecase is not 100% clear. As I understand, your winCC Professional reads data from the SQL Server (Not WinCC Instance) and thsi you want to show on trend view? In Trend view you can show onlie values and values out of the Tag logging. But this tag logging values are logged by WinCC not from outside. But there is also a possibility to show a trend with external data. Have a look at this link to the WinCC V7 Manual (in WinCC Prof its quite the same): https://support.industry.siemens.com/cs/ww/en/view/109792585/95220468491 Perhaps it helps Bye Murof
	If this Information really helps, you could use the Rate function
Suggestion To thank Quote Answer