Connecting to Kobo via SQL

Hi there,

I was hoping to connect to the Kobo platform to pull data based on SQL queries. Is this possible? I searched for this question but didn’t see anything directly.

Thanks very much,

Brett,

Yes, it is possible to pull the data using SQL queries. We recently worked on a project where we use BIRT to create report which pulled data from Kobo platform. For your reference: https://groups.google.com/forum/#!searchin/kobo-users/BIRT|sort:relevance/kobo-users/8i43IWAiPtY/7foR8umqBgAJ

Hth

Kurund

···

On Tuesday, October 4, 2016 at 6:46:57 PM UTC+5:30, Brett Collins wrote:

Hi there,

I was hoping to connect to the Kobo platform to pull data based on SQL queries. Is this possible? I searched for this question but didn’t see anything directly.

Thanks very much,

Yes, Brett- its possible using Koko Api ( https://kc.kobotoolbox.org/api/v1/). I used a php script to read kobo data from kobo api in Json format and then update/upload the data into own MySQL database. so that to manage as you want. http://epms.shangrilamap.com/

···

On Tuesday, October 4, 2016 at 7:01:57 PM UTC+5:45, Brett Collins wrote:

Hi there,

I was hoping to connect to the Kobo platform to pull data based on SQL queries. Is this possible? I searched for this question but didn’t see anything directly.

Thanks very much,