dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #39169
Re: data mart deprecation - 2.21
Thanks Lars.
I was the biggest user of the datamart until last year and I agree to your
suggestion of using the webapi. The webapi is better in performance and
ideally it can do almost everything with addition of a few SQLviews in case
of too specific requirements.
Thanks for the great work Dev team.
Alex
On Wed, Aug 26, 2015 at 2:27 PM, Lars Helge Øverland <larshelge@xxxxxxxxx>
wrote:
> Hi,
>
> we are thinking of removing the data mart functionality in DHIS 2. This
> refers to the ability to populate the "aggregateddatavalue" and
> "aggregatedindicatorvalue" tables with pre-aggregated data.
>
> The data mart is no longer in use by DHIS 2. There might be third-party
> report tools out there that connects directly to the data mart tables.
>
> We recommend that you connect reporting tools to the analytics web api
> <https://www.dhis2.org/doc/snapshot/en/developer/html/ch01s26.html> for
> the sake of performance, accessibility and security. If you need to
> connect with JDBC it is possible to create a SQL view to combine all
> analytics partitions and perform aggregation using group by statements.
>
> If we do not hear strong objections within a week we will remove data mart
> for version 2.21.
>
>
> regards,
>
> Lars
>
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org <https://www.dhis2.org>
>
>
> _______________________________________________
> 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
>
>
--
Alex Tumwesigye
Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET
Kampala
Uganda
IT Consultant - BarefootPower Uganda Ltd, SmartSolar, Kenya
IT Specialist (Servers, Networks and Security, Health Information Systems -
DHIS2 ) & Solar Consultant
+256 774149 775, + 256 759 800161
"I don't want to be anything other than what I have been - one tree hill "
References