We are in a proposal stage and need some suggestion on transferring data from Clear SCADA to OSI PI.
which will be the best mode of transfer ? .
Do we have any standard interface for this.
based on what I read in this datasheet:
the system provides an OPC server, so the PI Interface for OPC DA should work.
Please confirm with your vendor that it does indeed support OPC.
Thank you clint,
I will confirm whether the clear scada they have is opc complaint. If it is required to histroical data is it possible with OPC.
Like it need to transfer a last 1yr data from scada to PI.
Pls give your comments.
Your post has been a while back, but I'm wondering if you've implemented the OPC link. We've have implemented an OPC interface through the ClearSCADA OPC client, which is installed and configured on the PI server. Unfortunatelly, this setup has become a server hog on the ClearSCADA server. The interface keeps opening TCP connections on the ClearSCADA server without closing them so after a few hours the ClearSCADA server grinds to a halt. How did you get on with this?
There is an ODBC/SQL driver available for ClearSCADA, you can just do a SQL query to get the data in one shot (using any SQL utility), create a CSV file with the data. Then use Universal File Loader (UFL) to import the data into PI. You will have to set up UFL, but it is not that hard. If you have a lot of tags, I would do it in batches, maybe several thousand at a time. You will have to experiment to see what works best.
Retrieving data ...