The title sounds like that of an opening weekend success action movie, doesn’t it? But it’s just a case that MANTA solves daily: Automating Data Lineage Visualization from old SQL based Databases. Let’s look at one of our customer’s cases with Teradata database.
1. Problem
The customer, an international Healthcare provider, had an ancient database system. They had been using Teradata for over 30 years, within which they had accumulated over 21,000 scripts of code. Their metadata management solution was also integrated with the application Workday. This solution was regularly making changes to the environment, notifying them 6 weeks before performing the changes. This included changes to the data scheme and interferences with data publishing.
When the customer wanted to perform an impact analysis, the time needed to analyze 8 tables was 800 hours (100 man-days of work) and that was nearly impossible to achieve in the 6-week time-frame.
2. Solution
In order for the customer’s metadata management solution to work, they needed to automate the impact analysis process and the implementation of changes to the data warehouse structure so that it would be possible to perform the structural changes across the entire 21,000 script Teradata warehouse within the 6-week time frame. MANTA was pretty much their only hope.
3. Result
After deploying MANTA, the customer was able to successfully automate the impact analysis processes as well as the search for and implementation of changes to the data warehouse structure from the integrated Workday application.
MANTA gave the customer a comfortable user interface, seamlessly integrating all their metadata management applications, including EDC, and improved the overall state of the customer’s data governance projects.
Any questions? We’re here for you at manta@getmanta.com, as always.