# OEE using historian

**URL:** <https://forum.inductiveautomation.com/t/oee-using-historian/23940>\
**Category:** Ignition\
**Created:** [April 8, 2019, 9:32pm UTC](https://forum.inductiveautomation.com/t/oee-using-historian/23940 "2019-04-08T21:32:21Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![vrautomation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vrautomation/32/11155_2.png) [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\
**Post date:** [April 8, 2019, 9:32pm UTC](https://forum.inductiveautomation.com/t/oee-using-historian/23940/1 "2019-04-08T21:32:21Z")

</div>

Hi everyone 🙂

I succesfully create OEE projects using relational database. Tag event were pushing relational data in DB about operator, quantity, quality, downtime etc…

But does someone have done it using only historian data that are linked together only by time? In theory, everything is there…

Thanks!

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 8, 2019, 10:05pm UTC](https://forum.inductiveautomation.com/t/oee-using-historian/23940/2 "2019-04-08T22:05:25Z")

</div>

It is not terribly difficult if you know how to use lead/lag window functions in your database. And you have sufficient detail of both events and production schedules to yield the inner detail you are interested it.

---

<div class="post-metadata">

**Author:** ![vrautomation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vrautomation/32/11155_2.png) [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\
**Post date:** [April 9, 2019, 12:51pm UTC](https://forum.inductiveautomation.com/t/oee-using-historian/23940/3 "2019-04-09T12:51:30Z")

</div>

Thanks for the awnser.

But what if I have an OPC-DA connection to an external historian?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 9, 2019, 1:06pm UTC](https://forum.inductiveautomation.com/t/oee-using-historian/23940/4 "2019-04-09T13:06:28Z")

</div>

> [@vrautomation](#):
>
> an external historian?

I'd replace the external historian with a real database.

---

<div class="post-metadata">

**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\
**Post date:** [May 12, 2022, 2:11pm UTC](https://forum.inductiveautomation.com/t/oee-using-historian/23940/5 "2022-05-12T14:11:06Z")

</div>

@vrautomation  
did you switch to using historian?  
did you figure out tradeoffs?  
did you find examples, tutorials, or instructions on oee from historian?

---

<div class="post-metadata">

**Author:** ![vrautomation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vrautomation/32/11155_2.png) [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\
**Post date:** [May 12, 2022, 2:49pm UTC](https://forum.inductiveautomation.com/t/oee-using-historian/23940/6 "2022-05-12T14:49:55Z")

</div>

We finally switch to the Sepasoft modules.

However I still think the historian should be the main datasource. It would be more robust to have one gateway that act only as tag provider and historian driver. And a second gateway that run the Sepasoft module and the project.

---

<div class="post-metadata">

**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\
**Post date:** [May 12, 2022, 4:26pm UTC](https://forum.inductiveautomation.com/t/oee-using-historian/23940/7 "2022-05-12T16:26:22Z")

</div>

If you didn’t have sepasoft, what insight would you say?

---

<div class="post-metadata">

**Author:** ![vrautomation](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/vrautomation/32/11155_2.png) [@vrautomation](https://forum.inductiveautomation.com/u/vrautomation)\
**Post date:** [May 13, 2022, 9:04pm UTC](https://forum.inductiveautomation.com/t/oee-using-historian/23940/8 "2022-05-13T21:04:56Z")

</div>

We have a GE Plant Apps MES that get it’s data from a Pi historian. It is very robust because if the MES crash, the data is not lost and the MES can get himselft up to date later.

I think if there would be a way to replicate this in Ignition, it would be cool. However, for sure it’s gonna be more complicated.