Export collected data to relational database

[javib94]

I have collected data with a Form that has a “Repeat group” in it, it’s like a one-many relationship. Now there is a new requeriment to export the data to a relational database (any), how can I do this properly? and without having to prepare manually a table with all the fields that the form has, is there an automated way to do this?

[Kal_Lam]

@javib94, FYR:

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.

[javib94]

As I understand, REST services send data when is created, the problem is that I’m not receiving answers any more, I need to export saved data to relational database.

[Kal_Lam]

@javib94, maybe try this approach that has been discussed previously:

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.