I am looking to extract specific data from the Continuous Historian and dump it into MS Access on a regular (or request) basis. The scenario is this: A database in MS Access is set up for operators to enter manually recorded Chromatograph data during their shift; other Chromatographs are being historized in DVCH. The operations group would like to generate reports based off of the data in Access and DVCH. The developer would like for all of the data to be placed into MS Access so that they can manipulate it there. The eventual goal would be for them to be able to query any data in the DVCH to do whatever they want.
I realize that programmatic SQL access to the DVCH is not possible (and very difficult it seems for the DV ACH); also the developer does not want to involve Excel in any way.
My research has lead me to at least two possibilities:1. Use an OPC-ODBC driver to push the data to MS Access on a regular basis from DeltaV. 2. Use OPC-HDA to get at the data and pull it into MS Access on some schedule.
Option #1 is neat and I have been successful with it, but it is not the preferred solution because it requires more work than it seems is necessary just to get at historized data.
Option #2 or something similar is the route I would like to go, but I am getting stuck conceptually on how to use the OPC-HDA interface to extract the data. If I could use the ExcelReporter style functions in MS Access from VBA, I can visualize how that could work (Executing a data request and then inserting the data into a table).
Does anyone have any experience with this idea and making it work?
Thank you
In reply to Brian Atkinson:
In reply to dave_marshall:
Best Regards,
Rachelle McWright: Business Development Manager, Dynamic Simulation: U.S. Gulf Coast
In reply to Will Irwin:
In reply to Rachelle McWright:
In reply to Youssef.El-Bahtimy: