[GeoNode-devel] How to apply Geonode permissions for Postgres database access? For Tableau etc

[Rob Atkinson]

Maybe tableau can access via HTTP GET? geoserver also has a lighter-weight
filter (CQL_FILTER) that makes URLs easier to craft..

I am thinking of a django module as a lightweight API wrapper for Geonode,
using OpenAPI (was swagger) to document these APIS - but also for a funky
WMS-by-feature id  capability.

Rob Atkinson

On Thu, 2 Nov 2017 at 13:29 Jonathan Doig <j.doig at unsw.edu.au> wrote:

> Hi all
>
>
>
> Visualisation software like Tableau can get data from remote databases
> including Postgres. I’ve verified that works in our Geonode, with just a
> couple of config changes in Postgres.
>
>
>
> But how do I allow Tableau users to access layers from Postgres while
> honouring Geonode’s Django-level ‘Download’ permission?
>
>
>
> Do I have to duplicate Geonode’s users and access controls as Postgres
> users and privileges?
>
>
>
> This could be done generically …is there a tool for that?
>
>
>
> Or is there a better way to expose Geonode data to Tableau? (I’ve just
> given their sales people a serve for supporting 32 flavours of commercial
> database but not one International Standard like WFS…).
>
>
>
> Regards
>
> Jonathan
>
>
>
> [image: Title: City Futures - Description: City Futures Logo]
>
> *Jonathan Doig*
>
> Software Engineer, City Futures Research Centre
> Built Environment
>
> UNSW SYDNEY NSW 2052 AUSTRALIA
> M: +61 409 049185 <0409%20049%20185>
>
> T: +61 (2) 9385 5319
>
> E: *j.doig at unsw.edu.au <j.doig at unsw.edu.au>*
>
> W: cityfutures.net.au <http://www.cityfutures.net.au/>
>
>
> CRICOS Provider Code 00098G
>
> *Think green:** Please consider the environment before printing this
> email*
>
>
> _______________________________________________
> geonode-devel mailing list
> geonode-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/geonode-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20171102/73704e70/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 6531 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20171102/73704e70/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 6531 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20171102/73704e70/attachment-0003.png>