Hi Jose,
This is just my opinion, but it sounds like that solution is a good one for you if it works. If you had access to the PLC program, I’d suggest interfacing directly with the SCADA system from the PLC software, or using the PLC’s OPC UA server without the pvipy “middleman”. However, given that you can’t do that, PVI ←> OPCUA ←> SCADA is a solution I’ve seen used before with success.
If you’re looking for a dedicated device to handle this communication, one option could be the X20 Edge 