Access to database using Google App Engine

Good day to all!

I'm pretty new on ODK, I started using this amazing app last year - setup
my own host server using Apache and MySQL.

On my new project, I tried using Google App Engine and it found quiet
convenient as compared to managing server. But as practiced before I was
able to access ODK Tables in MySQL since I also have worksheets/dashboard
getting data directly to MySQL databases using ODBC connection.

My question is, is there a way I can connect directly to the database if my
ODK is being deployed to Google App Engine? It is very convenient for me to
design a dynamic worksheets that continuously refreshes data from ODK.

Hoping to get responses and ideas from the experts here, on how can I
manage my data using direct connection.

Thank you so much!!
Jonathan

Hi Jonathan,

Welcome to the ODK community!

Google App Engine does not give you easy access to the underlying
database. And even if it did, I'm not sure it'd work with OBDC because
the data store is a proprietary NoSQL DB (no JOINs!)

If you need this functionality, I'd recommend you use a VPS (e.g., AWS
EC2/RDS, Google Compute Engine, Digital Ocean) which enable you to run
a Tomcat/MySQL container in the cloud.

Alternatively, you can send data from Aggregate to other services
(e.g., Google Spreadsheets) and do your reporting there.
https://opendatakit.org/use/aggregate/data-transfer/ describes some of
the other data transfer options.

Hope that helps,

Yaw

··· On Mon, May 8, 2017 at 12:32 AM, Jonathan Masalonga wrote: > Good day to all! > > I'm pretty new on ODK, I started using this amazing app last year - setup my > own host server using Apache and MySQL. > > On my new project, I tried using Google App Engine and it found quiet > convenient as compared to managing server. But as practiced before I was > able to access ODK Tables in MySQL since I also have worksheets/dashboard > getting data directly to MySQL databases using ODBC connection. > > My question is, is there a way I can connect directly to the database if my > ODK is being deployed to Google App Engine? It is very convenient for me to > design a dynamic worksheets that continuously refreshes data from ODK. > > Hoping to get responses and ideas from the experts here, on how can I manage > my data using direct connection. > > Thank you so much!! > Jonathan > > -- > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "ODK Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to opendatakit+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout.

Hi Yaw!!

Thank you so much for this infromation this is very helpful!

Now I think I need to migrate to VPS to harvest my data from the backend.

··· On Sunday, May 14, 2017 at 9:45:03 PM UTC+8, Yaw Anokwa wrote: > > Hi Jonathan, > > Welcome to the ODK community! > > Google App Engine does not give you easy access to the ui Ya!nderlying > database. And even if it did, I'm not sure it'd work with OBDC because > the data store is a proprietary NoSQL DB (no JOINs!) > > If you need this functionality, I'd recommend you use a VPS (e.g., AWS > EC2/RDS, Google Compute Engine, Digital Ocean) which enable you to run > a Tomcat/MySQL container in the cloud. > > Alternatively, you can send data from Aggregate to other services > (e.g., Google Spreadsheets) and do your reporting there. > https://opendatakit.org/use/aggregate/data-transfer/ describes some of > the other data transfer options. > > Hope that helps, > > Yaw > > On Mon, May 8, 2017 at 12:32 AM, Jonathan Masalonga <jonathan....@gmail.com > wrote: > > Good day to all! > > > > I'm pretty new on ODK, I started using this amazing app last year - > setup my > > own host server using Apache and MySQL. > > > > On my new project, I tried using Google App Engine and it found quiet > > convenient as compared to managing server. But as practiced before I was > > able to access ODK Tables in MySQL since I also have > worksheets/dashboard > > getting data directly to MySQL databases using ODBC connection. > > > > My question is, is there a way I can connect directly to the database if > my > > ODK is being deployed to Google App Engine? It is very convenient for me > to > > design a dynamic worksheets that continuously refreshes data from ODK. > > > > Hoping to get responses and ideas from the experts here, on how can I > manage > > my data using direct connection. > > > > Thank you so much!! > > Jonathan > > > > -- > > -- > > Post: opend...@googlegroups.com > > Unsubscribe: opendatakit...@googlegroups.com > > Options: http://groups.google.com/group/opendatakit?hl=en > > > > --- > > You received this message because you are subscribed to the Google > Groups > > "ODK Community" group. > > To unsubscribe from this group and stop receiving emails from it, send > an > > email to opendatakit...@googlegroups.com . > > For more options, visit https://groups.google.com/d/optout. >

Jonathan,

Glad I could help! And if you want to migrate the data, I find ODK
Briefcase (https://opendatakit.org/use/briefcase) is the easiest way.

Yaw

··· On Mon, May 15, 2017 at 12:42 AM, Jonathan Masalonga wrote: > Hi Yaw!! > > Thank you so much for this infromation this is very helpful! > > Now I think I need to migrate to VPS to harvest my data from the backend. > > > On Sunday, May 14, 2017 at 9:45:03 PM UTC+8, Yaw Anokwa wrote: >> >> Hi Jonathan, >> >> Welcome to the ODK community! >> >> Google App Engine does not give you easy access to the ui Ya!nderlying >> database. And even if it did, I'm not sure it'd work with OBDC because >> the data store is a proprietary NoSQL DB (no JOINs!) >> >> If you need this functionality, I'd recommend you use a VPS (e.g., AWS >> EC2/RDS, Google Compute Engine, Digital Ocean) which enable you to run >> a Tomcat/MySQL container in the cloud. >> >> Alternatively, you can send data from Aggregate to other services >> (e.g., Google Spreadsheets) and do your reporting there. >> https://opendatakit.org/use/aggregate/data-transfer/ describes some of >> the other data transfer options. >> >> Hope that helps, >> >> Yaw >> >> On Mon, May 8, 2017 at 12:32 AM, Jonathan Masalonga wrote: >> > Good day to all! >> > >> > I'm pretty new on ODK, I started using this amazing app last year - >> > setup my >> > own host server using Apache and MySQL. >> > >> > On my new project, I tried using Google App Engine and it found quiet >> > convenient as compared to managing server. But as practiced before I was >> > able to access ODK Tables in MySQL since I also have >> > worksheets/dashboard >> > getting data directly to MySQL databases using ODBC connection. >> > >> > My question is, is there a way I can connect directly to the database if >> > my >> > ODK is being deployed to Google App Engine? It is very convenient for me >> > to >> > design a dynamic worksheets that continuously refreshes data from ODK. >> > >> > Hoping to get responses and ideas from the experts here, on how can I >> > manage >> > my data using direct connection. >> > >> > Thank you so much!! >> > Jonathan >> > >> > -- >> > -- >> > Post: opend...@googlegroups.com >> > Unsubscribe: opendatakit...@googlegroups.com >> > Options: http://groups.google.com/group/opendatakit?hl=en >> > >> > --- >> > You received this message because you are subscribed to the Google >> > Groups >> > "ODK Community" group. >> > To unsubscribe from this group and stop receiving emails from it, send >> > an >> > email to opendatakit...@googlegroups.com. >> > For more options, visit https://groups.google.com/d/optout. > > -- > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "ODK Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to opendatakit+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout.

Thank you so much Yaw! I will do that! thank you again for the help!!

··· On Mon, May 15, 2017 at 9:43 PM, Yaw Anokwa wrote:

Jonathan,

Glad I could help! And if you want to migrate the data, I find ODK
Briefcase (https://opendatakit.org/use/briefcase) is the easiest way.

Yaw

On Mon, May 15, 2017 at 12:42 AM, Jonathan Masalonga jonathan.masalonga@gmail.com wrote:

Hi Yaw!!

Thank you so much for this infromation this is very helpful!

Now I think I need to migrate to VPS to harvest my data from the backend.

On Sunday, May 14, 2017 at 9:45:03 PM UTC+8, Yaw Anokwa wrote:

Hi Jonathan,

Welcome to the ODK community!

Google App Engine does not give you easy access to the ui Ya!nderlying
database. And even if it did, I'm not sure it'd work with OBDC because
the data store is a proprietary NoSQL DB (no JOINs!)

If you need this functionality, I'd recommend you use a VPS (e.g., AWS
EC2/RDS, Google Compute Engine, Digital Ocean) which enable you to run
a Tomcat/MySQL container in the cloud.

Alternatively, you can send data from Aggregate to other services
(e.g., Google Spreadsheets) and do your reporting there.
https://opendatakit.org/use/aggregate/data-transfer/ describes some of
the other data transfer options.

Hope that helps,

Yaw

On Mon, May 8, 2017 at 12:32 AM, Jonathan Masalonga jonathan....@gmail.com wrote:

Good day to all!

I'm pretty new on ODK, I started using this amazing app last year -
setup my
own host server using Apache and MySQL.

On my new project, I tried using Google App Engine and it found quiet
convenient as compared to managing server. But as practiced before I
was

able to access ODK Tables in MySQL since I also have
worksheets/dashboard
getting data directly to MySQL databases using ODBC connection.

My question is, is there a way I can connect directly to the database
if

my
ODK is being deployed to Google App Engine? It is very convenient for
me

to
design a dynamic worksheets that continuously refreshes data from ODK.

Hoping to get responses and ideas from the experts here, on how can I
manage
my data using direct connection.

Thank you so much!!
Jonathan

--

Post: opend...@googlegroups.com
Unsubscribe: opendatakit...@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google
Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send
an
email to opendatakit...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en


You received this message because you are subscribed to a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/
topic/opendatakit/4f7Uqt-kVt8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.