Integrated nodes, such as programmable logic controllers, computer program products, computer readable media, and computer implemented methods are provided for process automation and subsystem communications, allowing a remote host to interface with a plurality of remote and in-plant subsystems and services using a wired or wireless network interface and having a database server and a protocol translator or translation server to convert and manipulate various industrial interfaces and protocols. Embodiments of the integrated node time-synchronize the plurality of remote subsystems, acquire and archive time-stamped process data, report exceptions therein to the remote host, and extract and transmit time-stamped process data to the remote host.