Skip to content

Getting Data From the openHistorian

Jump to bottom
Stephen Jenks edited this page Oct 11, 2016 · 8 revisions

If you've ever wanted to stream data from the openHistorian into the openPDC, now you can. Just follow the steps below.

Prerequisites:

  • Software to modify a database.
  • The openHistorian version 2.0.392 or newer.

Procedure

  1. Run the openHistorian configuration setup utility.
  2. Select "I want to use an existing configuration."
  • Select "Database".
  • Select "I want to use the database as-is".
  • Choose your database type.
  • Select the location of your database.
  • Check all available boxes.
  • Finish
  • Copy these files from the openHistorian install folder to the openPDC install folder:
    • crypto.dll
    • GSF.Historian.dll
    • GSF.SortedTreeStore.dll
    • HistorianAdapters.dll
    • openHistorian.Adapters.dll
    • openHistorianCore.dll
  • In the openHistorian Manager:
    • Go to Inputs > Browse Input Devices.
    • Select the input you want.
    • Change the protocol to "Virtual Device"
    • Click Save.
  • Copy the openHistorian database.
  • Start the openPDC Configuration Setup Utility and follow the same procedure as step 1, linking to the copy of the openHistorian database.
  • In the openPDC Manager:
    1. Go to System > Manage Nodes.
    • Under settings subtract 10 from each port.
    • Save.
    • Go to Inputs > Manage Custom Inputs.
      • Name your custom input.
      • Use any type.
      • Use this connection string: InstanceName=PPA; AutoRepeat=True; OutputMeasurements=FILTER ActiveMeasurements WHERE Internal <> 0; SimulateTimestamp=True; StartTimeConstraint=2016-09-01 00:00:00.000; StopTimeConstraint=2016-09-03 00:00:00.000; PublicationInterval=33333; ProcessInterval=33
      • Save.
  • Close the openPDC Manager and stop the openPDC Service.
  • In your database editor:
    1. Find the CustomInputAdapter table.
    • Find the custom input adapter created in step 6.
    • Change the TypeName to: openHistorian.Adapters.LocalInputAdapter
    • Change the AssemblyName to: openHistorian.Adapters.dll
  • Restart the openPDC service and openPDC Manager.
  • In the openPDC Manager:
    1. Go to Inputs > Manage Custom Inputs.
    • Select the input we just made/modified.
    • Click Initialize.
    • Go to Monitoring > Monitor Device Outputs.
  • Device outputs should appear.
Clone this wiki locally