Linking ODK aggregate to Mysql Database

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.

Hi @bob,

Welcome to the forum,

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

https://docs.opendatakit.org/aggregate-deployment-planning/

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?

Hi Bob,
It's possible in the future if several ODK users vote for this:

So we will have relational data in MySQL/MariaDB, PostgreSQL, MS SQL server.
Best,

Hello @bob . Did you ever find a workaround for this

Bob, have you ever find a solution for this as yet? I could use it as well

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.