Connect kobo and mySQL database

[agotossou]

I have a form with about 900 variables, I want to connect this to mySQL database and get the data instantaneously in the database once there is a submission.
How can this be done?

[Kal_Lam]

@agotossou, kindly be informed that the system does not have an inbuilt feature for this but you could obviously do the same through the REST Services by following our support article REST Services.

This post discussed previously should also help you get an idea of how it can be done:

Exporting data to Database

Also possible to use Kobo’s REST services and publish the data as JSON to an iPaaS (like OpenFn) which then converts the submissions to the desired format and loads them into your DB—we commonly integrate Kobo with DBs such as Postgres, MSSql, and MySql, each using a different adaptor on the platform.