Datahantering från PLC till SQL-databas

Sammanfattning: This bachelor thesis was executed at Mårtensson Consulting in Kristianstad. The thesis aimed at investigating how information from a PLC can be transferred to an SQL-database. The project was done with the intention of implementing it at one of Mårtensson Consulting’s clients. This influenced the choice of for instance PLC and software. The information that was to be logged came from a Clean In Place (CIP) process. The execution of the thesis was done by studying the existing code for the CIP-facility and then connecting the PLC to an OPC-server. The OPC-server was then connected with an SQL-database. The information gathered from the SQL-database was presented via a web interface. The results are that it is possible to transfer information from a PLC to an SQL-database. In order to present the information in a comprehensive manner for Mårtensson Consulting’s client a web interface was created.