I want to push the values of my AF attributes to a SQL DB table.
What is the best way to do this?
As per my understanding, There are two options.
1. Use PI SQL DAS (RTQP). For this you should have PI Server 2018 and above. You need to install PI SQL DAS (RTQP) on you AF server.
2. If the PI System’s version is below 2018, you can go with PI OLEDB Enterprise. You need to install this on your destination SQL server and create a link server connect to PI AF.
If you would like to understand in detail about the PI SQL framework, there is one online training in learning.osisoft.com
Thanks & Regards
+ PI Business Integrator with Target (SQL Server) - Create Asset View
+ AF SDK and PI Web API (Developer framework)
The technical options are already listed. Selecting the right option depends on how / what you need to do, how much data you need to send to SQL how often. Any details available on what you try to achieve?
There is nothing in pipeline where I wanted to use it. But as I have linked tables where I get SQL data into AF tables, I was trying to understand how does the reverse works.
I think have got the topics I need to go through to understand the same.
Thank you all for your advices.
Some other options are also listed here:
Connect a BD to PI?
Retrieving data ...