dhis2-devs team mailing list archive

[Rodolfo Melia <rmelia@xxxxxxxxxxxx>]

The ideal situation will be that any report_table in DHIS is ready to be
consumed by tableau. Currently, tableau sees the data returned by the DHIS
report_tables (see 40s video <https://www.youtube.com/watch?v=A84KZY5yUTU>),
but cannot complete the connection.

The link that you sent, if I understand correctly, will allow to develop
individual connections for specific report tables. So if an organization
wants to connect 10 tables representing 10 data collections, we need to
create 10 connectors - am I correct?
Ideally we want that the api can return data formatted is such a way that
Tableau can consume it - imagine something like this:
- server-url.org/api/tableau/aA5kJPtPf3p/data.json

*R*


On 28 January 2016 at 05:14, Morten Olav Hansen <mortenoh@xxxxxxxxx> wrote:

> HI Rodolfo
>
> Did you have a look at the example JSON connector?
>
> https://github.com/tableau/webdataconnector/blob/gh-pages/Examples/jsonConnector.html
>
> It seems pretty simple to connect to any kind of JSON source.. as long as
> you understand the data you are pulling in (analytics, etc) it should be a
> simple task to then map it to headers, columns etc..
>
> --
> Morten
>
> On Wed, Jan 27, 2016 at 11:24 PM, Rodolfo Melia <rmelia@xxxxxxxxxxxx>
> wrote:
>
>> Somehow, some organizations have used and want to continue using Tableau.
>> I understand 2.23 will offer a new vizualization engine. That will be
>> interesting, i will help taking them in that direccion.
>>
>>
>> On Wednesday, 27 January 2016, Morten Olav Hansen <mortenoh@xxxxxxxxx>
>> wrote:
>>
>>> It would also be interesting to know why they want to connect
>>> to Tableau, I thought our philosophy would point us to a more open source
>>> direction? Tableau is a hyper commercial company? no?
>>>
>>> While just a prototype, we in HISP Vietnam are also creating dashboards:
>>> http://dhis2.io (esc, or click hamburger to see menu)
>>>
>>> Tableau wanting to connect to us, should be seen both as a success.. and
>>> something to be wary about (if you care about code, and you have seen the
>>> output from a Tableau dashboard, you know how shitty it is)
>>>
>>> --
>>> Morten
>>>
>>> On Wed, Jan 27, 2016 at 10:21 PM, Knut Staring <knutst@xxxxxxxxx> wrote:
>>>
>>>> Copying this to Sundeep also, since HISP India is also interested in
>>>> this linkage, as are the WHO SEARO, WPRO and PAHO regional offices.
>>>>
>>>>
>>>> On Wed, Jan 27, 2016 at 4:17 PM, Morten Olav Hansen <mortenoh@xxxxxxxxx
>>>> > wrote:
>>>>
>>>>> Ok, Lars will know more about that.. I know they have reached out to
>>>>> us.. Not sure if they will do the work or us, but I don't think the amount
>>>>> of work would be much.. at least our analytical json should be easy to
>>>>> read, I have already make connectors for the dashboards I have been
>>>>> creating for Lao and Indoensia
>>>>>
>>>>> --
>>>>> Morten
>>>>>
>>>>> On Wed, Jan 27, 2016 at 10:14 PM, Rodolfo Melia <rmelia@xxxxxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> only for the connector...
>>>>>>
>>>>>>
>>>>>> On 27 January 2016 at 15:10, Morten Olav Hansen <mortenoh@xxxxxxxxx>
>>>>>> wrote:
>>>>>>
>>>>>>> Sure, are they planning to release an open source version then?
>>>>>>>
>>>>>>> --
>>>>>>> Morten
>>>>>>>
>>>>>>> On Wed, Jan 27, 2016 at 10:05 PM, Juan Manuel Alcantara Acosta <
>>>>>>> jmalcantara1@xxxxxxxxx> wrote:
>>>>>>>
>>>>>>>> Nicola recently told me someone form Tableau will be attending the
>>>>>>>> symposium. That could be a good opportunity to talk to them.
>>>>>>>> JM
>>>>>>>>
>>>>>>>>
>>>>>>>> El 27/01/2016, a las 9:02 a.m., Rodolfo Melia <rmelia@xxxxxxxxxxxx>
>>>>>>>> escribió:
>>>>>>>>
>>>>>>>> Hi Knut - that's interesting. Look forward to hear more about that
>>>>>>>> conversation with the Tableau foundation.
>>>>>>>>
>>>>>>>> I think that somehow we need DHIS to expose the data in a XML/Json
>>>>>>>> following Tableau conventions.
>>>>>>>>
>>>>>>>> *Rodolfo Meliá*
>>>>>>>> *Principal  |  *rmelia@xxxxxxxxxxxx
>>>>>>>> Skype: rod.melia  |  +44 777 576 4090  |  +1 708 872 7636
>>>>>>>> www.knowming.com
>>>>>>>>
>>>>>>>> On 27 January 2016 at 14:18, Knut Staring <knutst@xxxxxxxxx> wrote:
>>>>>>>>
>>>>>>>>> Hi Rodolfo,
>>>>>>>>>
>>>>>>>>> There was an email recently about direct contact with the Tableau
>>>>>>>>> Foundation, who seem interested in working with us directly.
>>>>>>>>>
>>>>>>>>> I think Lars will probably follow up on this when he is back from
>>>>>>>>> leave.
>>>>>>>>>
>>>>>>>>> Knut
>>>>>>>>>
>>>>>>>>> On Wed, Jan 27, 2016 at 2:45 PM, Morten Olav Hansen <
>>>>>>>>> mortenoh@xxxxxxxxx> wrote:
>>>>>>>>>
>>>>>>>>>> Hi Rodolfo
>>>>>>>>>>
>>>>>>>>>> I don't know anything about Tableau, but maybe you would have
>>>>>>>>>> better luck importing CSV data? its a bit more manageable than JSON (which
>>>>>>>>>> can have any format)
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> Morten
>>>>>>>>>>
>>>>>>>>>> On Wed, Jan 27, 2016 at 6:31 PM, Rodolfo Melia <
>>>>>>>>>> rmelia@xxxxxxxxxxxx> wrote:
>>>>>>>>>>
>>>>>>>>>>> Hi everyone - the latest version of Tableau (9.1) has a new 'web
>>>>>>>>>>> connector' that allows to read html/ json sources. As you can see from the
>>>>>>>>>>> image below, I have successfully got to the point of DHIS returning data to
>>>>>>>>>>> Tableau, but I cannot get to the final step to start doing the charts in
>>>>>>>>>>> tableau.
>>>>>>>>>>>
>>>>>>>>>>> Have anyone successfully connected DHIS to tableau using the new
>>>>>>>>>>> web connector in 9.X?
>>>>>>>>>>> I have the impression that there is the need to modify the json
>>>>>>>>>>> that DHIS returns, based on Tableau specs. Have anyone tried to do that?
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> <Tableau Web Connector.png>
>>>>>>>>>>>
>>>>>>>>>>> *R*
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> _______________________________________________
>>>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>>>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> _______________________________________________
>>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>>>>>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Knut Staring
>>>>>>>>> Dept. of Informatics, University of Oslo
>>>>>>>>> Norway: +4791880522
>>>>>>>>> Skype: knutstar
>>>>>>>>> http://dhis2.org
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Knut Staring
>>>> Dept. of Informatics, University of Oslo
>>>> Norway: +4791880522
>>>> Skype: knutstar
>>>> http://dhis2.org
>>>>
>>>
>>>
>>
>> --
>> *Rodolfo Meliá*
>> *Principal  |  *rmelia@xxxxxxxxxxxx
>> Skype: rod.melia  |  +44 777 576 4090  |  +1 708 872 7636
>> www.knowming.com
>>
>>
>