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,