S7-1200 and database

[Ahmed Najeeb]

HELLO , i am automating production plant using s7-1200 (TIA portal v13) and wincc comfort advanced the function and the linking with SCADA system is going well , what i need to ask for i want to creat a database and extract data of my PLC to be saved and called to print or reporting upon the operator request , so how to do that . i really need help i have been searching and trying for a long time with no progress .. thanks in advance

 

[mk42]

HELLO , i am automating production plant using s7-1200 (TIA portal v13) and wincc comfort advanced the function and the linking with SCADA system is going well , what i need to ask for i want to creat a database and extract data of my PLC to be saved and called to print or reporting upon the operator request , so how to do that . i really need help i have been searching and trying for a long time with no progress .. thanks in advance

WinCC comfort & advance have some data logging and reporting capability, but if you have a SCADA system already, it probably makes sense to do any DB/SQL there.

 

[gclshortt]

https://support.industry.siemens.com/cs/document/61883659/how-do-you-access-an-sql-database-in-wincc-runtime-advanced-using-a-script?dti=0&lc=en-WW

https://support.industry.siemens.com/cs/document/57132412/tips-and-tricks-for-creating-scripts-in-wincc-(tia-portal)?dti=0&lc=en-WW

You can use VB Scripting to do this. The above links should help you out.

file:///C:/Users/Garry/Downloads/gs_wincc_v12_comfort_advanced_options_enUS_en-US.pdf
This is a getting started guide.

Regards,

 

[keithkyll]

Garry,
The last link is to your hard drive.

 

[gclshortt]

https://support.industry.siemens.com/cs/attachments/72928098/gs_wincc_v12_comfort_advanced_options_enUS_en-US.pdf?download=true
This is a getting started guide.

Thanks Keith

Regards,