Querying from multiple different database

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?

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.

1 Like

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

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