We have a client who is activiely running in thier plant using OSI PI, we wish to install Goldsim - simulation software and woud like to harvest the OSI PI plant data in real time - question is - Can we conenct directly to OSI PI using the Goldsim import tool. Goldsim can read data from any ODBC compliant database directly. Or do we need to install and setup an SQL Staging database between the 2?
You would simply need to install the PI ODBC driver on the node from which the connection will be made. Newer versions of the PI ODBC driver connects to the PISQLDAS so you would need that layer. There is no need to go through a SQL Server.