It's possible to access PHD data via a simple SQL query within SQL Server (I say simple as at the time of writing, joins cannot be done, discussed here). In essence if you are retrieving live well data, say every 5 seconds, then you can query that live data using SQL either from within SQL Server or from an application using a stored procedure or inline code etc.

To do this you need to install the Honeywell Uniformance PHD software client tools/desktop components (which comes on the same disk as the server software). Once you have done this, a new data provider will be listed when extracting data from capable applications. It should read like "Uniformace PHD OLE/DB Provider".   Create a new SQL Server Linked Server (more info here), and with the Other data source radio button selected, select "Uniformace PHD OLE/DB Provider" as the provider. The Product...