Migrating an old DWH to a new environment/technology

The VHV Group in Hanover is a German insurance, pension and asset management company that operates as a primary insurer and reinsurer both in Germany and abroad.

Project

VHV was faced with the challenge of migrating its old DWH to a new environment and talend was to be replaced by SAS. In addition, there was a need to build the DWH according to the data vault model and set up the data marts in a column-based database (DB2 BLU). Generation of jobs to fill the DWH would be metadata-driven.

adesso modelled DWH3.0 in MID Innovator, attended to the generation of jobs for filling a data vault model as well as the in-database processing of ETL processes – not to mention developing an Essbase interface.

The result

The ETL processes were adapted to the requirements and the automatic creation of loading processes now ensures a lighter workload for VHV. All data was also successfully loaded into the DWH.

Do you have any questions?

+49 231 7000-7000

There is no website or brochure which can replace a personal meeting to talk about your goals and topics. We are looking forward to an appointment on site.

Save this page. Remove this page.

C71.898,22.5,97.219,25.136,96.279,52.11z"/>