Have you thought about storing your spreadsheet data in Google Sheets instead?
That way external users can store them 'securely' and your Tableau Server will be able to connect to it.
Also, you dont have any infrastructure to manage or worry about.
Hope this helps
Thanks Glen. If only life were so simple
Information Governance would probably have a field day with that one. Data will need to reside within the UK, especially with the uncertainty of Brexit looming. I suspect that a physical server would be the only solution that would fly. You built our system so you know some of the constricts that a Public Service in the UK has to comply with.
My main worry with free cloud systems is the long term support of the spreadsheet. If I created it in my own Google sheets account and allowed the Tableau server access then it would work but if I leave my employment how would my employer maintain that sheet. We have the need for that sheet to be edited by multiple people and that data stays within UK boundaries.
I thought that you would say that
If you need to manage the storage that these excel files are on, then you have 2 options.
That storage can be inside the firewall or outside.
If its inside, then you are going to have to allow external users access and give them accounts.
If it is outside then your Tableau Service Account is going to need to be able to access that storage.
The potential difficultly (i think) is that your Tableau Service Account is a Domain Account, so the external storage will also need to be on a Domain, and a trust relationship created between the 2 domains (or you may be able to use ADFS, but i'm not sure).
This means that the external storage needs to be on a domain, with a domain controller, etc...
You will need to manage user accounts for this domain for your external users.
I think that it would be relatively straight forward to setup on AWS (or similar). The harder part would be getting sign off, managing users, etc etc
Hope this helps