# Core and additional SQL modules

**URL:** <https://forum.inductiveautomation.com/t/core-and-additional-sql-modules/53790>\
**Category:** Ignition\
**Tags:** vision, ignition81\
**Created:** [December 6, 2021, 11:25am UTC](https://forum.inductiveautomation.com/t/core-and-additional-sql-modules/53790 "2021-12-06T11:25:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Typical\_user](https://avatars.discourse-cdn.com/v4/letter/t/f1d935/32.png) [@Typical\_user](https://forum.inductiveautomation.com/u/Typical_user)\
**Post date:** [December 6, 2021, 11:25am UTC](https://forum.inductiveautomation.com/t/core-and-additional-sql-modules/53790/1 "2021-12-06T11:25:47Z")

</div>

Hello,

What can I do with built-in SQL database connectivity in ignition without paid add-ons such as “SQL Bridge Module” or “Tag Historian Module”?

I’d like to generate csv with alarm history and tag values. Is it possible to implement this functionality without buying additional SQL modules?

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [December 6, 2021, 11:30am UTC](https://forum.inductiveautomation.com/t/core-and-additional-sql-modules/53790/2 "2021-12-06T11:30:15Z")

</div>

> [@Typical\_user](#):
>
> I’d like to generate csv with alarm history and tag values. Is it possible to implement this functionality without buying additional SQL modules?

Yes it is possible without buying additional SQL modules though I wouldn't call the Tag Historian Module a SQL Module.

SQL Bridge Module grants the use of Transaction Groups.  
Tag Historian Module, obviously allows for storing historical data but also the use of the Power Chart.

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [December 6, 2021, 11:40am UTC](https://forum.inductiveautomation.com/t/core-and-additional-sql-modules/53790/3 "2021-12-06T11:40:55Z")

</div>

The transaction group can be replaced via scripting, e.g. system.tag.readblocking and system.db.runSFUpdateQuery

The historian would be much trickier to replace via scripting.

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [December 6, 2021, 12:24pm UTC](https://forum.inductiveautomation.com/t/core-and-additional-sql-modules/53790/4 "2021-12-06T12:24:09Z")

</div>

for the historian you would need to create your own ‘audit table’ in your db with triggers or something.  
for every tag write too. which means you will have to also send every tagwrite to a db.

---

<div class="post-metadata">

**Author:** ![Alan\_Cannon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alan_cannon/32/31171_2.png) [@Alan\_Cannon](https://forum.inductiveautomation.com/u/Alan_Cannon)\
**Post date:** [March 14, 2023, 7:00pm UTC](https://forum.inductiveautomation.com/t/core-and-additional-sql-modules/53790/5 "2023-03-14T19:00:26Z")

</div>

is there a Chart or document that shows the delineation of functions for the sql bridge. if i have "legacy database access" what would a system miss or be limited with by not having the Sql Bridge module.