Streamlining your data warehouse migration with NodeGraph | NodeGraph
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
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 SolutionIdentify 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.
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.
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!