Datahantering från PLC till SQL-databas
(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:
http://lup.lub.lu.se/student-papers/record/8878507
- author
- Bergwall, Fredrik
- organization
- year
- 2016
- type
- M2 - Bachelor Degree
- subject
- keywords
- plc, sql-databas, opc-server, cip, webbgränssnitt
- language
- Swedish
- id
- 8878507
- date added to LUP
- 2016-06-08 04:09:28
- date last changed
- 2018-10-18 10:33:11
@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}},
language = {{swe}},
note = {{Student Paper}},
title = {{Datahantering från PLC till SQL-databas}},
year = {{2016}},
}