data mart deprecation - 2.21

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 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

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@gmail.com 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 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


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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 "

Thanks Lars,

Now pivot table is good enough to serve users. But for some specific program requests, we use sqlviews.

I support the idea, in our settings we don’t use Datamart.

···

On Wednesday, August 26, 2015 1:27 PM, Lars Helge Øverland larshelge@gmail.com 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 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


Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

In Bangladesh we are not using Data Mart; instead we are using paralytics. So no problem from our end.

Regards

Hannan Khan

HISP Bangladesh

···

On Wed, Aug 26, 2015 at 5:27 PM, Lars Helge Øverland larshelge@gmail.com 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 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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Paralytics??

···

On 27 August 2015 at 09:35, Hannan Khan hannank@gmail.com wrote:

In Bangladesh we are not using Data Mart; instead we are using paralytics. So no problem from our end.

Regards

Hannan Khan

HISP Bangladesh


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Wed, Aug 26, 2015 at 5:27 PM, Lars Helge Øverland larshelge@gmail.com 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 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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19274

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


That seems a little extreme, but whatever works. Desperate times call for desperate measures.

  • Edward -
···

On Thursday, August 27, 2015 9:53 AM, Calle Hedberg calle.hedberg@gmail.com wrote:

Paralytics??

On 27 August 2015 at 09:35, Hannan Khan hannank@gmail.com wrote:

In Bangladesh we are not using Data Mart; instead we are using paralytics. So no problem from our end.

Regards

Hannan Khan

HISP Bangladesh

On Wed, Aug 26, 2015 at 5:27 PM, Lars Helge Øverland larshelge@gmail.com 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 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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19274

Email: calle.hedberg@gmail.com

Skype: calle_hedberg



Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

Hi Calle
Hannan meant Analytics. :slight_smile:

rgds

David

···

2015-08-27 11:53 GMT+03:00 Calle Hedberg calle.hedberg@gmail.com:

Paralytics??


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On 27 August 2015 at 09:35, Hannan Khan hannank@gmail.com wrote:

In Bangladesh we are not using Data Mart; instead we are using paralytics. So no problem from our end.

Regards

Hannan Khan

HISP Bangladesh


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19274

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On Wed, Aug 26, 2015 at 5:27 PM, Lars Helge Øverland larshelge@gmail.com 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 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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi all,

many thanks for the feedback. We will remove data mart for 2.21 then.

regards,

Lars

···

On Fri, Aug 28, 2015 at 8:47 PM, David Muturi dnmuturi@gmail.com wrote:

Hi Calle
Hannan meant Analytics. :slight_smile:

rgds

David


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

2015-08-27 11:53 GMT+03:00 Calle Hedberg calle.hedberg@gmail.com:

Paralytics??


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On 27 August 2015 at 09:35, Hannan Khan hannank@gmail.com wrote:

In Bangladesh we are not using Data Mart; instead we are using paralytics. So no problem from our end.

Regards

Hannan Khan

HISP Bangladesh


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19274

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On Wed, Aug 26, 2015 at 5:27 PM, Lars Helge Øverland larshelge@gmail.com 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 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


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org