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