| View previous topic :: View next topic |
| Author |
Message |
MirceaCristian
Junior
Joined: 03 Dec 2019
Posts: 1
|
 Posted: 03/12/2019 10:32 Post subject: Tia 15.1 WinCC Redundant Servers connect to external SQL srv |
 |
|
Hello everyone. I have to do a SCADA project that has the fallowing configuration (see attachment).
We will use TIA 15.1 SP3 Professional.
The client insist on saving all the data into an external SQL Server that will run SQL Server 2016 so in the future other software can pull from the SQL Database information.
For a small project i would have used the example from this post : https://support.industry.siemens.com/tf/ww/en/posts/how-do-you-access-an-sql-server-in-wincc-professional-v15-via-the-ms-ole-db-provider/201859?page=0&pageSize=10 , but i estimate that i will have to save around ~600 tags every minute.
1. Is there a magical way i can change the default SQL that Wincc saves it's data to the external SQL Server ???
2.If i use WinCC 7.5 can i solve the problem from question 1?
3.If the answer for question 1 and 2 is no, will saving 600 tags every minute in the external SQL server will be possible by script ? I mean can the wincc server handle it ?
4. If i save data by script will both of the WinCC servers will write in the external SQL server or just the master wincc server will and when he is down the standby wincc server will ? Can a redundancy be done with the external SQL server?
5.How do i save alarms ? How do i show trends ? in the external SQL server.
6. If i don't use the external SQL server, and i chose to use the "internal" SQL from my Wincc server can i make this an open database so other software can pull from it ???
I know there are a lot of questions but please please share your knowledge. Even an opinion is good. I'm in the dark here .
Thanks in advance! |
|
| Back to top |
|
 |
dmz
Junior
Joined: 22 Jan 2018
Posts: 4
Location: Poland
|
| Posted: 05/12/2019 15:53 Post subject: |
|
|
Use WinCC 7.5 with Industrial Data Bridge
WinCC servers (active and standby) can write on SQL Server
For Alarms and Trends you can explore WinCC Help
You can use a VM with both servers and save Hardware spendings |
|
| Back to top |
|
|
karkalete
Junior 2
Joined: 20 Nov 2016
Posts: 25
|
| Posted: 06/12/2019 09:44 Post subject: How do you access an SQL database in WinCC Runtime Advanced |
|
|
How do you access an SQL database in WinCC Runtime Advanced using a script?
https://support.industry.siemens.com/cs/document/61883659/how-do-you-access-an-sql-database-in-wincc-runtime-advanced-using-a-script |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
