Getting Data From the openHistorian

Stephen Jenks edited this page Nov 30, 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.SortedTreeStore.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.
    • Go to Outputs > Historian Instances
    • Make sure that in the connection string, the ArchiveDirectory and WorkingDirectory point to your archive file location.
  • Copy the openHistorian database and rename it to openPDC.
  • Start the openPDC Configuration Setup Utility and follow the same procedure as step 1, linking to the copy of the openHistorian database which you renamed to openPDC in the previous step.
  • 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 replacing the values for StartTimeConstraint and StopTimeConstraint with the start and end times of the data you have.
      • Save.
  • Close the openPDC Manager and stop the openPDC Service.
  • In your database editor:
    1. Open the openPDC database file.
    • 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.
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.