I just happened to write up a document about this yesterday: Using OSI PI JDBC with Ignition
So in my testing, I kept it simple and had Ignition on the same machine as PI, but honestly, I don’t think you really need to worry about the dll. I think the installer for the JDBC driver will make sure it’s somewhere accessible, like “system32”.
The only other thing about using PI, as mention in that document: values returned as variants will result in “Unknown Type 2000” errors. We’ve tweaked 7.5.9 (and 7.6.1) to avoid this error in many cases, but there are still some places that can’t deal with the variant. The work around is simply to cast your value columns in the query (e.g. “SELECT cast(value as Float32) …”)
Let me know how it goes,