# Accessing mySQL query data via OPC

**URL:** <https://forum.inductiveautomation.com/t/accessing-mysql-query-data-via-opc/3317>\
**Category:** Archived Topics\
**Created:** [September 21, 2011, 10:39pm UTC](https://forum.inductiveautomation.com/t/accessing-mysql-query-data-via-opc/3317 "2011-09-21T22:39:32Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![erikburns](https://avatars.discourse-cdn.com/v4/letter/e/e5b9ba/32.png) [@erikburns](https://forum.inductiveautomation.com/u/erikburns)\
**Post date:** [September 21, 2011, 10:39pm UTC](https://forum.inductiveautomation.com/t/accessing-mysql-query-data-via-opc/3317/1 "2011-09-21T22:39:32Z")

</div>

I am interested in connecting Win911 to a query in mySQL to get alarm data. (I am populating a table with data and querying the last row). Can anyone help me configure my OPC to connect to my database? I also have OpenOffice installed.

Thanks!

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [September 22, 2011, 11:41pm UTC](https://forum.inductiveautomation.com/t/accessing-mysql-query-data-via-opc/3317/2 "2011-09-22T23:41:33Z")

</div>

Win911 doesn’t have any sort of database connector?

If you want to access database data through OPC you might look at the KepServerEX [ODBC client driver](http://www.kepware.com/Spec_Sheets/ODBC_Client_Driver.asp)

---

<div class="post-metadata">

**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\
**Post date:** [September 24, 2011, 5:16pm UTC](https://forum.inductiveautomation.com/t/accessing-mysql-query-data-via-opc/3317/3 "2011-09-24T17:16:25Z")

</div>

I use win911 with the kepware odbc connector and it works well. I basically just have a transaction group that moves values into a table, I then push those values out via opc.

Its definitely not the best way to do things though. you cant tie the high and low alarm setpoints from ignition into win911’s high and low setpoints so you either have to have push the analog value out and then have separate setpoints in win911 or look at the .alertactive of a tag which means you cant put the value in the message. you definitely lose alot of the functionality that you have using wonderware and win911 together when you try and use win911 with ignition. plus the odbc to opc driver isnt cheap.

Ive basically just decided to use win911 for voice callout, and then let ignition handle email and text’s. It would be nice if Ignition would have some of the features that win911 has like alert escalation and the ability not to send alerts to someone during certain time periods.

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [September 26, 2011, 5:26pm UTC](https://forum.inductiveautomation.com/t/accessing-mysql-query-data-via-opc/3317/4 "2011-09-26T17:26:16Z")

</div>

> [@diat150](#):
>
> It would be nice if Ignition would have some of the features that win911 has like alert escalation and the ability not to send alerts to someone during certain time periods.

These features are on our roadmap.

---

<div class="post-metadata">

**Author:** ![DaneOverfield](https://avatars.discourse-cdn.com/v4/letter/d/71c47a/32.png) [@DaneOverfield](https://forum.inductiveautomation.com/u/DaneOverfield)\
**Post date:** [January 5, 2012, 8:30pm UTC](https://forum.inductiveautomation.com/t/accessing-mysql-query-data-via-opc/3317/5 "2012-01-05T20:30:35Z")

</div>

You can access mySQL tables using TopView SQL from Exele ([exele.com](http://exele.com)).  
It provides everything you will need for notification and escalation.

[http://www.exele.com/Products/TopView/topview\_about.htm](http://www.exele.com/Products/TopView/topview_about.htm)

---

<div class="post-metadata">

**Author:** ![DaneOverfield](https://avatars.discourse-cdn.com/v4/letter/d/71c47a/32.png) [@DaneOverfield](https://forum.inductiveautomation.com/u/DaneOverfield)\
**Post date:** [February 17, 2012, 1:02pm UTC](https://forum.inductiveautomation.com/t/accessing-mysql-query-data-via-opc/3317/6 "2012-02-17T13:02:43Z")

</div>

We have added some details of integrating TopView SQL to Ignition.  
[exele.com/Products/TopView/s … /index.htm](http://www.exele.com/Products/TopView/solutions/ignition/index.htm)