# SQL bridge and tag historian module

**URL:** <https://forum.inductiveautomation.com/t/sql-bridge-and-tag-historian-module/92438>\
**Category:** Ignition\
**Tags:** scripting, perspective\
**Created:** [June 27, 2024, 6:22am UTC](https://forum.inductiveautomation.com/t/sql-bridge-and-tag-historian-module/92438 "2024-06-27T06:22:02Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Elias\_Ghadbane](https://avatars.discourse-cdn.com/v4/letter/e/e68b1a/32.png) [@Elias\_Ghadbane](https://forum.inductiveautomation.com/u/Elias_Ghadbane)\
**Post date:** [June 27, 2024, 6:22am UTC](https://forum.inductiveautomation.com/t/sql-bridge-and-tag-historian-module/92438/1 "2024-06-27T06:22:02Z")

</div>

hello everyone,  
when I buy the SQL bridge module, i can use the transaction and the named query? And no need for the tag historian module if I have knowledge in SQL to call a querry to binding a chart component for example right?

---

<div class="post-metadata">

**Author:** ![Hayden\_Watson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/hayden_watson/32/48792_2.png) [@Hayden\_Watson](https://forum.inductiveautomation.com/u/Hayden_Watson)\
**Post date:** [June 27, 2024, 6:33am UTC](https://forum.inductiveautomation.com/t/sql-bridge-and-tag-historian-module/92438/2 "2024-06-27T06:33:06Z")

</div>

SQL Bridge module is only for the transaction groups. Named queries are a standard feature.

Tag historian module has some advantages for configuring history on many tags very quickly and handling all of the partitioning for you, plus I think Ignition Edge sync requires it.

But yes, you can do most of it with just transaction groups. And using a named query to read data for your trending.

---

<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:** [June 27, 2024, 11:53am UTC](https://forum.inductiveautomation.com/t/sql-bridge-and-tag-historian-module/92438/3 "2024-06-27T11:53:49Z")

</div>

Note that you won't be able to use Perspective's PowerChart component without the historian.

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [June 27, 2024, 12:46pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-and-tag-historian-module/92438/4 "2024-06-27T12:46:21Z")

</div>

So event if the tables are there, power chart won't load in the data? (are the functions disabled due to no licence?)

Actually, that's what the read only tag historian licence is for. Well, to read from a licensed tag historian really, but if you _really_ wanted to script your own to mimic IA's, you could use that potentially... Good luck to those who inherit the system though!!

---

<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:** [June 27, 2024, 12:52pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-and-tag-historian-module/92438/5 "2024-06-27T12:52:01Z")

</div>

The Perspective PowerChart does its own queries via a history provider, and history providers depend on the historian module. PowerChart cannot accept custom datasets or series.

---

<div class="post-metadata">

**Author:** ![Elias\_Ghadbane](https://avatars.discourse-cdn.com/v4/letter/e/e68b1a/32.png) [@Elias\_Ghadbane](https://forum.inductiveautomation.com/u/Elias_Ghadbane)\
**Post date:** [June 27, 2024, 1:06pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-and-tag-historian-module/92438/6 "2024-06-27T13:06:07Z")

</div>

yes you are right but what the difference between power table component and use to combine table and chart component to poll trends from my table transaction in the database?

---

<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:** [June 27, 2024, 1:10pm UTC](https://forum.inductiveautomation.com/t/sql-bridge-and-tag-historian-module/92438/7 "2024-06-27T13:10:20Z")

</div>

> [@Elias\_Ghadbane](#):
>
> what the difference between power table component and combine table and chart component and poll from my table transaction ?

A lot of programming overhead, and your own solution for a tag browser.

Do able? Yes. Straight forward and trivial? No.

You might check out other third party charting modules, which provide more comprehensive charting solutions than the standard Timeseries and XY Chart components.