what are the requirements for me to be able to read pi data from other third party servers?
If you're trying to transfer PI data to a third -party vendor's server, the third-party vendor will probably have the best information. Could you provide more information what you're trying to accomplish? Perhaps we can help you come up with a good solution for your use case.
The basic requirements are that you have access to the PI Data Archive via either a mapping to your Windows account (or group you are part of) (recommended solution), a PI Trust specific to the Server IP and the application name or a PI Login (not recommended).
If you want access to the AF Server, then you will need to have a mapping to your Windows account (or group you are part of).
Of course, port 5450 needs to be opened to the PI Data Archive and 5457 to the AF Server.
How are you looking to read the PI Data? Is it using a custom application, a third party application or one of OSIsoft's application?
We'll need a little more detail on what you are trying to do to better assist you.
Thank you, Sebastien
To answer your question from a protocol standpoint, here's an overview of our Developer Technologies.
We have tools that expose the PI server as a SQL server and therefore can be queried using SQL programming:
PI OLEDB Enterprise - Overview ; PI OLEDB Provider - Overview ; PI JDBC Driver - Overview ; PI ODBC Driver - Overview
We have another that exposes the PI server via a REST Api (PI Web API - Overview )
We have a tool that exposes the PI server as an OPC server (PI OPC DA HDA Server - Overview)
We have the PI System's native language (PI AF SDK - Overview) which is a .NET assembly that can be referenced in your custom project.
And we also have a set of Powershell cmdlets that you can use in a Powershell script (PowerShell Tools for the PI System)
thanks a lot for the help. after installing the PI OPC DA Server do i need special configuration on the third party machine?
You should read through the user guide to get a feel for the installation process: PI OPC DA Server 2015 R2 User Guide
The main task is configuring DCOM security, which we have another guide for: DCOM Configuration Guide
Aside from that, it should be straight forward, but if you run into any issues feel free to contact us.
I have installed the PI Opc da server but matrikon cannot still see it. The machine i am trying to get the read is outside the network, any more thing can be done at this stage? I tried pidatalink and works fine, i can get the reading in excel.
I would encourage you to contact tech support so that we can have a remote session with you to troubleshoot the configuration. That may prove difficult to do over forum.
Hi thanks for all the support. Is there a way PI can create cfx files?
You'll also need a PI Data Access licence, which is an additional cost to your standard PI System licence. This is required for your PI Data Archive to connect to non-OSIsoft products.
If you're wanting to connect to a third-party database, OLEDB is a good fit. If you're wanting your PI data to be used in web applications, the PI Web API works well. If you want your PI Data to be used in non-Windows applications (i.e. Unix/Linux/iOS/etc) then OPC UA might be worth investigating.
please help me with this error, do you know what is that?
i have done the DCOM setting but still not connect. please send me your number so that i can call.
I haven't seen that error before and a quick search of our call history doesn't produce anything.
I don't handle tech support cases directly, so you will want to call into our main techsupport line (https://my.osisoft.com/) and initiate a case with the engineer answering the phone.
How can i generate date and time tag in PI ? Can we have just a tag that the value is date/time?
You can set the Point Type to "Timestamp" to have it store values that are timestamps.
on the instrument tag i put timestamp is that what you mean? can you send a screenshot showing how to create that tag in Excel?
My example tag is just a very simple tag of that point type. It's not configured to get data from any source, as that question would then become interface specific I would imagine. For example, if you had a Timestamp value item on your OPC server, then you would enter the OPC itemID into the instrument tag for the PI OPC Interface tag configuration.
But how to set what I was referring in PI Builder in Excel would be this:
For the instrument tag, you'd have to match the data source accordingly to the documentation for the specific interface you're using.
Why not just PI Cloud Connect the data between PI Systems? That's what it is there for.
Retrieving data ...