I have surveys on ODK Aggregate and want to access the resultant information as tables in a database hosted via MySQL Server. How can i link ODK Aggregate to MySQL so that every time a new entry is added to the spreadsheets in ODK Aggregate it shows up in a MySQL database?.
I am using Mysql database,running windows 10 OS on Lenovo T480 laptop.
I find your question a bit unclear, ODK aggregate is already using relation database as backend. I encourage you to check out the doc to understand more on the deployment
I have surveys on ODK Aggregate and want to access the resultant information as tables in a database hosted via MySQL Server. How can i link ODK Aggregate to MySQL so that every time a new entry is added to the spreadsheets in ODK Aggregate it shows up in a MySQL database?
Please note that Aggregate is no longer being supported. Central is now the ODK server. The post below has for more details about the end-of-life for Aggregate.