# Querying from multiple different database

**URL:** <https://forum.inductiveautomation.com/t/querying-from-multiple-different-database/92190>\
**Category:** Ignition\
**Created:** [June 21, 2024, 3:54am UTC](https://forum.inductiveautomation.com/t/querying-from-multiple-different-database/92190 "2024-06-21T03:54:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mekiu\_Cu](https://avatars.discourse-cdn.com/v4/letter/m/cab0a1/32.png) [@Mekiu\_Cu](https://forum.inductiveautomation.com/u/Mekiu_Cu)\
**Post date:** [June 21, 2024, 3:54am UTC](https://forum.inductiveautomation.com/t/querying-from-multiple-different-database/92190/1 "2024-06-21T03:54:31Z")

</div>

I have 20 different MySQL databases that I am planning to write into a central database. Is it possible for Ignition to select, query and extract the data from any 1 of the 20 databases of my choice?

---

<div class="post-metadata">

**Author:** ![David\_Stone](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/david_stone/32/79749_2.png) [@David\_Stone](https://forum.inductiveautomation.com/u/David_Stone)\
**Post date:** [June 21, 2024, 4:36am UTC](https://forum.inductiveautomation.com/t/querying-from-multiple-different-database/92190/2 "2024-06-21T04:36:52Z")

</div>

Yes it is possible, you will need to write a python script to do individual queries to different databases. You would add 20 databases to ignition and make the python script extract the queried data and send it to other queries.

---

<div class="post-metadata">

**Author:** ![Mekiu\_Cu](https://avatars.discourse-cdn.com/v4/letter/m/cab0a1/32.png) [@Mekiu\_Cu](https://forum.inductiveautomation.com/u/Mekiu_Cu)\
**Post date:** [June 21, 2024, 5:07am UTC](https://forum.inductiveautomation.com/t/querying-from-multiple-different-database/92190/3 "2024-06-21T05:07:56Z")

</div>

Currently I am using ignition to pull data from the database. Will this same method work for multiple different database?

---

<div class="post-metadata">

**Author:** ![David\_Stone](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/david_stone/32/79749_2.png) [@David\_Stone](https://forum.inductiveautomation.com/u/David_Stone)\
**Post date:** [June 21, 2024, 5:24am UTC](https://forum.inductiveautomation.com/t/querying-from-multiple-different-database/92190/4 "2024-06-21T05:24:23Z")

</div>

What tables are you trying to combine and insert into a database?