Core and additional SQL modules

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?

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.

1 Like

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.

1 Like

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.