# Implementation of easy chart without use of historian tag or sql bridge ignition

**URL:** <https://forum.inductiveautomation.com/t/implementation-of-easy-chart-without-use-of-historian-tag-or-sql-bridge-ignition/67006>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [November 29, 2022, 12:30am UTC](https://forum.inductiveautomation.com/t/implementation-of-easy-chart-without-use-of-historian-tag-or-sql-bridge-ignition/67006 "2022-11-29T00:30:38Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![JORGE\_JAIMES](https://avatars.discourse-cdn.com/v4/letter/j/d07c76/32.png) [@JORGE\_JAIMES](https://forum.inductiveautomation.com/u/JORGE_JAIMES)\
**Post date:** [November 29, 2022, 12:30am UTC](https://forum.inductiveautomation.com/t/implementation-of-easy-chart-without-use-of-historian-tag-or-sql-bridge-ignition/67006/1 "2022-11-29T00:30:38Z")

</div>

Hi. I'm trying to do a trend with Easy chart at Vision but I dont have access to use the SQL bridge and Tag Historian Modules. There is some way to graph without these modules?  
Also I have reporting module license and I need to know if SQL bridge and Tag Historian Modules are necessary.  
Thanks for your helpfull.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [November 29, 2022, 12:39am UTC](https://forum.inductiveautomation.com/t/implementation-of-easy-chart-without-use-of-historian-tag-or-sql-bridge-ignition/67006/2 "2022-11-29T00:39:06Z")

</div>

You can use database and calculated pens on the easy chart without a historian license; your DB table will just have to be in a fairly straightforward format to be interpreted correctly by the component. For more control, you can "roll your own" easy chart using the 'classic' chart component and your own date range component. Then you can use whatever means (scripting, expressions, etc) to generate the datasets to back your charts.

SQL Bridge and Tag Historian are _not_ required for charts in Reporting. Tag history queries won't work from reporting without the module, but you are still able to issue basic SQL queries.

SQL Bridge, despite the somewhat misleading name, _only_ provides (and/or restricts) the use of transaction groups. All other SQL functionality is in the base platform (named queries, the `system.db` scripting functions, etc). Limitations apply on Edge.

---

<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:** [November 29, 2022, 1:57am UTC](https://forum.inductiveautomation.com/t/implementation-of-easy-chart-without-use-of-historian-tag-or-sql-bridge-ignition/67006/3 "2022-11-29T01:57:42Z")

</div>

> [@JORGE\_JAIMES](#):
>
> There is some way to graph without these modules?

As Paul notes, EasyChart can use "DB pens" to plot from generic SQL tables.

The other half of the equation is **storing** tag values into your DB. With neither the Tag History module nor SQL Bridge module, you will need to script the storage of data. Tag events and timer events are the typical entry points.

---

<div class="post-metadata">

**Author:** ![JORGE\_JAIMES](https://avatars.discourse-cdn.com/v4/letter/j/d07c76/32.png) [@JORGE\_JAIMES](https://forum.inductiveautomation.com/u/JORGE_JAIMES)\
**Post date:** [November 29, 2022, 2:01am UTC](https://forum.inductiveautomation.com/t/implementation-of-easy-chart-without-use-of-historian-tag-or-sql-bridge-ignition/67006/4 "2022-11-29T02:01:39Z")

</div>

Thanks for your help. I am looking for information about it in forums to be able to implement the solution that you indicate. I have a question when you refer to the simple arrangement in the Database for reading the tags in Ignition. Is there a document where I can consult on the subject?

---

<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:** [November 29, 2022, 1:21pm UTC](https://forum.inductiveautomation.com/t/implementation-of-easy-chart-without-use-of-historian-tag-or-sql-bridge-ignition/67006/5 "2022-11-29T13:21:25Z")

</div>

There's not much in the forums, and I know of no document, where trending is done entirely with DB pens on an EasyChart and all DB inserts are manual.

You will need to learn how to use the `system.tag.*`, `system.db.*`, and possibly `system.opc.*` scripting functions to replace what the modules do.

---

<div class="post-metadata">

**Author:** ![JORGE\_JAIMES](https://avatars.discourse-cdn.com/v4/letter/j/d07c76/32.png) [@JORGE\_JAIMES](https://forum.inductiveautomation.com/u/JORGE_JAIMES)\
**Post date:** [November 29, 2022, 2:10pm UTC](https://forum.inductiveautomation.com/t/implementation-of-easy-chart-without-use-of-historian-tag-or-sql-bridge-ignition/67006/6 "2022-11-29T14:10:34Z")

</div>

Is it necessary to purchase the SQL Bridge module if I have a Tag Historian?  
I say this because when enabling the historical mode of a tag, it asks me to refer to a storage base. That being the case, wouldn't the SQL bridge be included?

 ![ignition](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/4/8480cf8b1b4d867087d0a352968839c870ed1cc6.png)

---

<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:** [November 29, 2022, 2:15pm UTC](https://forum.inductiveautomation.com/t/implementation-of-easy-chart-without-use-of-historian-tag-or-sql-bridge-ignition/67006/7 "2022-11-29T14:15:28Z")

</div>

No, you do not need SQL bridge to use the Tag Historian.

SQL Bridge is for Transaction Groups.

You will need to configure a Historical Provider in your Gateway. Generally, if you add a Database connection, it will be automatically added as a Historical Provider for you.
