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?
In reply to Brian Atkinson:
In reply to dave_marshall:
Rachelle McWright | Community Manager, Emerson Exchange 365
Share. Learn. Network.
In reply to Will Irwin:
In reply to Rachelle McWright:
In reply to Youssef.El-Bahtimy:
This is the official online community site of the Emerson Global Users Exchange, a forum for the free exchange of non-proprietary information among the global user community of all Emerson Automation Solution's products and services. Our goal is to improve the efficiency and use of automation systems and solutions employed at members’ facilities by sharing our knowledge, experiences, and application information.
User Groups |
World Areas |
Community Guidelines |
Legal Information |
Contact Community Manager
Website translation provided by
© 2015-2020 Emerson Global Users Exchange. All rights reserved.