I just initiated data collection for a project and since their requirement is to connect their data with Tableau, I am submitting data to Google sheets. The good thing about Google sheets, it updates the tableau dashboard on realtime.
But there is a problem: The project workers would like to collect data using both Android and on Windows PC.
Now I need to adopt one of the following options:
I need to find a way to collect data using both Windows PC and Android to Google sheets, I do not know whether that is doable! or
Connect tableau to the backend database of Aggregate server, ODK Central or KoBo Toolbox
It should be straightforward to connect Tableau to a Central server directly.
See the docs about Connecting to submission data over OData. This will have the added benefit of being more secure than Google Sheets! Unfortunately Enketo web forms are not yet integrated into the Central install process. Although that feature is funded, and coming soon!
We don't support question about KoBo Toolbox on this forum, but it should be possible to connect Tableau to data via the KoBo API. You can ask on their forum if that's something you'd like to explore.
Thanks for your guidance. I found the option 2 most convenient.
Previously I tried this option and found that the published Google sheets don't get updated based on the live data. Is it how it should be? There something I need to do to ensure that the published data gets updated based on the submissions to the Aggregate server.