# Dynamically create data type instance with data coming from a SQL database

**URL:** <https://forum.inductiveautomation.com/t/dynamically-create-data-type-instance-with-data-coming-from-a-sql-database/55994>\
**Category:** Ignition\
**Created:** [February 10, 2022, 6:52pm UTC](https://forum.inductiveautomation.com/t/dynamically-create-data-type-instance-with-data-coming-from-a-sql-database/55994 "2022-02-10T18:52:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![a.beltran](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/a.beltran/32/18481_2.png) [@a.beltran](https://forum.inductiveautomation.com/u/a.beltran)\
**Post date:** [February 10, 2022, 6:52pm UTC](https://forum.inductiveautomation.com/t/dynamically-create-data-type-instance-with-data-coming-from-a-sql-database/55994/1 "2022-02-10T18:52:31Z")

</div>

Hello,

I have some troubles to create a multi instances or a new data type instance with data coming from a SQL database. What I have is a multiple names of conveyors coming from a database I built an UDT with parameters in there, but I’ll like to create those automatically with the name of the converyos in MySQL database.

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [February 10, 2022, 8:15pm UTC](https://forum.inductiveautomation.com/t/dynamically-create-data-type-instance-with-data-coming-from-a-sql-database/55994/2 "2022-02-10T20:15:16Z")

</div>

I assume you are just wanting to create a new UDT instance from data coming from a db query?

[system.tag.configure - Ignition User Manual 8.1 - Ignition Documentation (inductiveautomation.com)](https://docs.inductiveautomation.com/display/DOC81/system.tag.configure)

---

<div class="post-metadata">

**Author:** ![a.beltran](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/a.beltran/32/18481_2.png) [@a.beltran](https://forum.inductiveautomation.com/u/a.beltran)\
**Post date:** [February 11, 2022, 5:49pm UTC](https://forum.inductiveautomation.com/t/dynamically-create-data-type-instance-with-data-coming-from-a-sql-database/55994/3 "2022-02-11T17:49:07Z")

</div>

Thank you for your quick answer, Also what I would like to do is, use a template repeater and pass parameters through the reapeter to have those conveyors have functionality as green when running, status, etc those functions are working fine in the template, but I’d like to have those dynamically regarding the units I have in the database, any word of advice will be appreciate it.