We also have same requirement and planning to create a linked server on the PHD and then use TableDR to link data from PHD into AF.
So far, we have created a linked server and able to access data using SQL queries (OPENQUERY) in the SQL Management studio. yet to link the data to AF attributes and may foresee some challenges in passing time context.
will keep you posted on the updates.
2 of 2 people found this helpful
Generally, this is what you would look at using a COM Connector for - there is one for PHD. See the product detail page here. If you're not familiar with this technology, you create PI tags of a special point class that are then mapped to points in a foreign data source such as PHD. This allows standard PI client tools to access the foreign data as if it were natively stored in PI. Even though you aren't bringing the data into PI, the COM Connector tags will still count against your licensed point count. But it could be a reasonable solution. I've used these COM Connectors previously, and found them to be a good option.
Thanks John, that method does appear to be what we are looking for.
I'll proceed down that path and see how far we get!