Questions tagged [historian]

Historian (or an Operational Historian) refers to a database software application that logs or historizes time-based process data.

Historian is a type of licensed software provided by GE and Wonderware. It's a enterprise-wide data management software.

More information about GE Proficy Historian can be found here

More information about Wonderware Historian can be found here

More information about OSIsoft PI Historian can be found here

More information about HoneyWell PHD Historian can be found here

56 questions
13
votes
4 answers

How do I query raw data from a Proficy Historian?

How can I retrieve raw time-series data from a Proficy Historian/iHistorian? Ideally, I would ask for data for a particular tag between two dates.
Michael Haren
  • 97,268
  • 39
  • 159
  • 200
12
votes
2 answers

What is a Historian?

What is the function of a historian in terms of OPC and PLC?
Rob_IGS
  • 575
  • 3
  • 8
  • 17
9
votes
5 answers

AspenTech InfoPlus 21 - How to connect and query data

I will be given access to an AspenTech InfoPlus 21 endpoint, but the systems seems to be quite legacy and not very well (publicly) documented. I will need to query some data (i.e. explore what is in the database). I had a few questions regarding…
DaveTheAl
  • 1,471
  • 3
  • 24
  • 50
6
votes
4 answers

How do I find the history of transactions for an Asset in a blockchain implemented using hyperledger-composer?

I'm working on the latest rev of hyperledger-composer (V0.13) and have built a network with multiple roles, each of which can invoke selected transactions within the blockchain. I would now like to query the blockchain (?Historian?) for all…
Bob Dill
  • 938
  • 4
  • 12
5
votes
2 answers

How i can easily extract data from historian with python?

I am fairly new to Proficy Historian and Python. The purpose of my application is to start extracting data from Proficy. GE (Proficy) Historian is installed on a Virtual Machine Server A while my python is installed in an other VM Server B. Both…
And. D.
  • 51
  • 1
  • 3
4
votes
2 answers

Selecting a column with period in the column name SQL Server

I am linked to a Proficy Historian that allows periods in the column names. Because the data is stored in a non DBMS format I can not use openquery to get the data because there is no set schema to the tables. So I must use four part name syntax…
efbenson
  • 189
  • 1
  • 9
4
votes
1 answer

What historian databases are available currently?

I have a question related to the historian databases. Here is our requirement. We need a historian database that is capable of collecting data from equipment at the rate of 1000 updates / sec on an average. And there will be one equipment for each…
AnswerSeeker
  • 173
  • 2
  • 14
3
votes
1 answer

GE Historian Simulation

I have been trying to simulate values in Historian without great success. I'm very new to both the environment and VBscript itself. I'm trying to simulate simple 1's and 0's. My goal is to make it run for 1-2 minutes, returning 1's. Then going down…
Kalle
  • 123
  • 2
  • 10
3
votes
2 answers

How to query data from an AspenTech IP21 Historian?

Old subject, combined with new tools: What would be the best/appropriate way to query data for a web application from an AspenTech IP21 (InfoPlus.21) data historian? In the past, I've used some pretty awful queries via the Aspen SqlPlus ODBC driver,…
reallyJim
  • 1,336
  • 2
  • 15
  • 28
2
votes
1 answer

How to query data from txt file into AspenTech IP21 Historian?

I have process data in this format in a txt file. testTag testTag2 10 18 6 15 7 15 9 19 Please help me to build a SQLPlus script so that after every 5 seconds one of these values orderly should update IP_INPUT_VALUE field of testTag &…
iskbaloch
  • 167
  • 8
2
votes
1 answer

Docker : Battery historian - Pull access denied or require docker login

I am following https://github.com/google/battery-historian I am trying to execute following commands on my Mac : $ docker run -p 5665:9999 gcr.io/android-battery-historian/stable:3.0 --port 9999 But I am getting following error : Unable to find…
AnswerDroid
  • 1,825
  • 2
  • 30
  • 50
2
votes
1 answer

How can I delete data from tags

I would like to delete data from chosen tag by time in Proficy Historian 5.5. Can this be done using C# IHUAPI.cs?
gowno20
  • 23
  • 3
2
votes
1 answer

Query [large] data records from Proficy Historian?

I'm using the Proficy Historian SDK with python27. I can create a data record object and add the query criteria attributes (sample type, start time, end time, sample interval - in milliseconds) and use datarecord.QueryRecordset() to execute a query.…
1
vote
1 answer

Some datetime filters on Wonderware Historian queries returns no data

I'm querying to Wonderware Historian Database from SQL Server Management Studio and found that sometimes I don't get values, depending on the datetime filters I've set, even using Full retrieval mode. I can get the values for the first ten days of…
lluisma
  • 21
  • 5
1
vote
1 answer

Historian retrieve data

I have an Excel worksheet that I have the data pulled from a Historian database for emission tags in a Wonderware server. I need to know how i can write the SQL query that uploads data between two date ranges.starte date end date. I have collected…
Jeannie
  • 11
  • 2
1
2 3 4