Advanced

Datahantering från PLC till SQL-databas

Bergwall, Fredrik (2016)
Computer Science and Engineering (BSc)
Abstract
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... (More)
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. (Less)
Please use this url to cite or link to this publication:
author
Bergwall, Fredrik
organization
year
type
M2 - Bachelor Degree
subject
keywords
plc, sql-databas, opc-server, cip, webbgränssnitt
language
Swedish
id
8878507
alternative location
https://portal.ch.lu.se/Campus.NET/Services/Publication/Export.aspx?id=2956&type=doc
date added to LUP
2016-06-08 04:09:28
date last changed
2016-06-08 04:09:28
@misc{8878507,
  abstract     = {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.},
  author       = {Bergwall, Fredrik},
  keyword      = {plc,sql-databas,opc-server,cip,webbgränssnitt},
  language     = {swe},
  note         = {Student Paper},
  title        = {Datahantering från PLC till SQL-databas},
  year         = {2016},
}