dhis2-devs team mailing list archive

[Rodolfo Melia <rmelia@xxxxxxxxxxxx>]

We are probably going to develop one connector to test this. I will write
back.

On Saturday, 30 January 2016, Morten Olav Hansen <mortenoh@xxxxxxxxx> wrote:

> 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.
>>
>
> Yeah, as far as I know.. this is something being worked on, but Lars will
> have to give the details.. I don't think you will see tableau compatible
> data coming out of DHIS 2, but rather a specialised connector from their
> side.
>
>
>> 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?
>>
>
> Well, yes.. it would require a XHR request for every data source you want
> to pull in, but that's the case anyways.. even with a specialised
> connector. The only way to remedy something like that would be to bundle
> multiple resource tables together.
>
> --
> Morten
>
>
>> 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
>> <javascript:_e(%7B%7D,'cvml','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
>>> <javascript:_e(%7B%7D,'cvml','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
>>>> <javascript:_e(%7B%7D,'cvml','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
>>>> <javascript:_e(%7B%7D,'cvml','rmelia@xxxxxxxxxxxx');>
>>>> Skype: rod.melia  |  +44 777 576 4090  |  +1 708 872 7636
>>>> www.knowming.com
>>>>
>>>>
>>>
>>
>

-- 
*Rodolfo Meliá*
*Principal  |  *rmelia@xxxxxxxxxxxx
Skype: rod.melia  |  +44 777 576 4090  |  +1 708 872 7636
www.knowming.com