Streamlining your data warehouse migration with NodeGraph

Organization size: 3 000 users with 100 apps
Data sources: Multiple Data Warehouses, a few direct ERP connections, and 300 CSV & excel sources
Challenge: Streamlining their data warehouse migration
Solution: Planning, understanding & documenting their Qlik Solution

In collaboration with NodeGraph Partner eCraft

Introduction

This case story explores the journey of a large corporation who used NodeGraph to alleviate friction during a data warehouse migration. Continue reading to find out how NodeGraph, our data quality platform for QlikView and Qlik Sense, was able to make their transition smooth.

Challenge: Streamlining their data warehouse migration

The challenge that was faced by eCraft’s customer was to perform a swift data warehouse migration. More specifically, the organization in question were aiming to migrate their entire Qlik Solution to a new data warehouse without losing any data and while also maintaining a detailed account of the migration.

Solution: Planning, understanding & documenting their Qlik Solution

Identify which files and applications will be affected during the migration using The Dependency Explorer

By enabling the organization to plan the migration, i.e. find out which Qlik applications would need to be reworked during the migration process, the organization was able to proactively avoid corrupting any of their Qlik data. Furthermore, NodeGraph’s extensive data lineage functionalities also allowed eCraft’s customer to understand their Qlik Solution better prior to the migration, further simplifying the process.

As can be seen below, NodeGraph’s Dependency Explorer can be used to identify which files and applications will be affected during specific changes and migrations.

data warehouse migration nodegraph qlik sense qlikview metadata visualization data lineage

Automatically documenting their Qlik Solution throughout the entire migration process

Another major propellant towards a swift migration was the use of NodeGraph’s automated documentation feature. By eliminating the need for manual Qlik documentation, the customer in question was able to efficiently document their Qlik Solution throughout the entire migration process.

“Having constantly updated documentation is the key when they are looking at [their Qlik Solution before the migration] and also when they have implemented [the new data warehouse] so that they can see that [the migration] is working well.”

Ville Airo,
Senior Business Intelligence Consultant at eCraft Business Insight

See an example of how the automated documentation feature works below.

nodegraph automated documentation qlik sense qlikview data warehouse migration

Are you interested in finding out more about our data quality solution? If you are already working with eCraft, reach out to them by clicking here. Alternatively, click below to book a demo with us!