← Back to team overview

dhis2-devs team mailing list archive

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