# Microsoft SQL Server historical data logging using ignition

**URL:** <https://forum.inductiveautomation.com/t/microsoft-sql-server-historical-data-logging-using-ignition/5874>\
**Category:** Archived Topics\
**Created:** [February 14, 2013, 9:48pm UTC](https://forum.inductiveautomation.com/t/microsoft-sql-server-historical-data-logging-using-ignition/5874 "2013-02-14T21:48:23Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![DWeber](https://avatars.discourse-cdn.com/v4/letter/d/f07891/32.png) [@DWeber](https://forum.inductiveautomation.com/u/DWeber)\
**Post date:** [February 14, 2013, 9:48pm UTC](https://forum.inductiveautomation.com/t/microsoft-sql-server-historical-data-logging-using-ignition/5874/1 "2013-02-14T21:48:23Z")

</div>

I have a read only connection to Microsoft SQL Server database. We are currently only using the data by displaying it in a table in our ignition project. We are currently using MySQL for our main database and it can not make a connection to SQL Server. How can i create historical data with the information i have? I would like to create some charts and trend the data but can not since i cant store or create history for any of the values.

---

<div class="post-metadata">

**Author:** ![gnguyen](https://avatars.discourse-cdn.com/v4/letter/g/41988e/32.png) [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\
**Post date:** [February 15, 2013, 6:49am UTC](https://forum.inductiveautomation.com/t/microsoft-sql-server-historical-data-logging-using-ignition/5874/2 "2013-02-15T06:49:40Z")

</div>

Hi,

Can you be more precise… you want to chart data coming from SQL Server and/or MySQL in the same Ignition project ? If, so, yes you can.  
Give more information and one could give you the right direction to go 😉

---

<div class="post-metadata">

**Author:** ![DWeber](https://avatars.discourse-cdn.com/v4/letter/d/f07891/32.png) [@DWeber](https://forum.inductiveautomation.com/u/DWeber)\
**Post date:** [February 15, 2013, 12:58pm UTC](https://forum.inductiveautomation.com/t/microsoft-sql-server-historical-data-logging-using-ignition/5874/3 "2013-02-15T12:58:36Z")

</div>

The data we are receiving from SQL server is real time data that we want to store so that we can log it as historical values.

---

<div class="post-metadata">

**Author:** ![gnguyen](https://avatars.discourse-cdn.com/v4/letter/g/41988e/32.png) [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\
**Post date:** [February 15, 2013, 4:31pm UTC](https://forum.inductiveautomation.com/t/microsoft-sql-server-historical-data-logging-using-ignition/5874/4 "2013-02-15T16:31:56Z")

</div>

Well, so you could create Query Tag and then add history property for this sqltag. If you have plenty of, then create an udt and instanciate as much as you want.