Jan 2018 - Mar 2018
Vertech
Vopak
Chemicals
This was an IIoT proof of concept for Vopak that would eventually be scaled up. We wanted to obtain raw data from various site-level devices at multiple sites and sent the data up to a local Ignition SCADA system via MQTT edge devices. The local Ignition SCADA systems would also transmit by MQTT up to a central enterprise Ignition SCADA system (theoretically, this could receive MQTT messages from the individual devices, but the goal was to avoid overworking the MQTT server/distributor). The central enterprise Ignition SCADA would then historize data from these MQTT signals to a central historian, in this case, in MySQL. An API was written in Ignition to allow external engines in Microsoft Azure to retrieve data from the historian via SQL query and GET requests. This data could then be transported into a data lake or any other analytics engine.
Python, MySQL, MQTT, Ignition SCADA, API