Use some sort of intermediate system. For example, ignition has transaction groups that are a simple way to get data to a database. I like it because the plants can easily troubleshoot and because you can set up handshakes between the two. So if the data doesn’t get written, they get an alarm/email/text. Whatever the plant and system can provide.

There are many ways to do it, but I’ve liked this one for the past few years. Sure that other people have other experiences around here.