1. What is the general goal of the feature? With a connector for OData sources, ODK Central could be configured as a data source in Google Data Studio (GDS). GDS seems similar to Tableau and MS Power BI. https://datastudio.withgoogle.com/ - apparently free (for now) and available (until Google kil…

Thanks to @Florian_May for suggesting this integration and congrats to @hugh_sun , @PieterBenjamin and the rest of the UW Impact++ team that made this a reality in partnership with Team ODK. You can find out more here . Please post a support issue if you have any issues or questions about using the c…

I'll try! GDS allows users to configure data sources, and access and analyze data from these sources. I wish ODK Central could be used as data source, and the following facts indicate it might be possible: ODK Central has a (somewhat standard compliant) OData API. GDS however doesn't have a "con…

Resources for anyone willing to give this a shot: Tools: https://developers.google.com/datastudio/connector/get-started Target: The ODK Central API docs https://odkcentral.docs.apiary.io/ Test: Use the ODK Central Sandbox for testing, ask here or create an "Account request" (Disclaimer: I'm not …

Hi @Florian_May . Thinking of picking this up - is it still open/in need of dev work? I notice it's tagged with pr-welcome, is there a place you had in mind to add the connector?

Hi @PieterBenjamin ! If you have time, feel free to have a go! I put this idea here in the hope that someone would find time. I'd be happy to test and share any lessons implemented in ruODK if that helps.

I'm desperately looking for an automated (e.g. API-driven) way to get ODK submission data from ODK Central into Google Data Studio, or even into Google Sheets (using only Enketo). If you are taking this up, I'd be keen to test out the solution! Thanks!

Thanks for letting me know! Working on it with a few devs here .

Great work, and thanks for taking this up! Minor feedback: Logo / branding - see https://getodk.org/legal/brand.html - can't use ODK logo unless ODK core package, but great wording IMHO in the README, makes attribution and relationship to ODK clear. validate_credentials sends an authenticated req…

Also, we are moving to a token based method, instead of use base64 encoding scheme of username and password. Now I can tokens, but how do I verify that the token I have is not expired, is there a URL that I can send a token to and get whether that token has expired or not? Thanks!

You can find the auth API in the ODK Central API docs (see my links above). Leading question: Is there an endpoint in the token auth that would work to verify authentication on any ODK Central instance, independent of specific (or any) projects being present?

Happy to announce that our connector seems to be working and is ready for testing at https://github.com/UDub-Impact/OData-Connector . @Florian_May @cbg would either of you be willing to do some preliminary user testing? We were not able to get repeats working but other than that the connector should …

ODK Forum

Create an OData connector to use ODK Central as data source in Google Data Studio

Ideas

pr-welcome, odk-central

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled

Looking for a better way? Try ODK Cloud, the official managed hosting service from the creators of ODK.