S7-1200 and database

Ahmed Najeeb · Feb 8, 2016

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 · Feb 8, 2016

Ahmed Najeeb said:
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 · Feb 8, 2016

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 · Feb 8, 2016

Garry,
The last link is to your hard drive.

gclshortt · Feb 8, 2016

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,

S7-1200 and database

Ahmed Najeeb

Member

mk42

Lifetime Supporting Member

gclshortt

Member

keithkyll

Member

gclshortt

Member

Similar Topics