We looked at the whole reporting process, from data sources, through staging and ETL processes to populating ODS and reporting via Jasper BI from ODS. The amount of data that have to be moved became unpractical to keep using the current model and alternatives have been investigated. JBoss Data Virtualization (JDV) provided a usable alternative that resolves all the current issues including the handling of deleted records. A possible strategy has also been discussed for phased implementation. There is however a problem with the licensing of the product and currently we are looking at more affordable tertiary discount and even alternative products that can provide the same functionality at lower cost.
Once the JDV discovery process is completed it’s usability and cost will be discussed to determine if it can be used to resolve some of the current issues.
26 March 2018: JDV pilot completed, and moving forward with project. New project to be registered.
JDV Project scheduled for 2018 due to capacity and restructuring project
We looked at the whole reporting process, from data sources, through staging and ETL processes to populating ODS and reporting via Jasper BI from ODS. The amount of data that have to be moved became unpractical to keep using the current model and alternatives have been investigated. JBoss Data Virtualization (JDV) provided a usable alternative that resolves all the current issues including the handling of deleted records. A possible strategy has also been discussed for phased implementation. There is however a problem with the licensing of the product and currently we are looking at more affordable tertiary discount and even alternative products that can provide the same functionality at lower cost.
Once the JDV discovery process is completed it’s usability and cost will be discussed to determine if it can be used to resolve some of the current issues.