MANTA and “The Quest To Automate The Ancient Database”

MANTA and “The Quest To Automate The Ancient Database”

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.

Manta technology callout 2017 teradata v1

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.

M
Meet MANTA

We’re a global team dedicated to a shared goal: bringing intelligence to metadata management. Explore our blog for the latest insights, updates, and ideas from our team of data industry experts.

Join us for a swim

Liked what you saw? There’s more! Sign up to get the latest news and subscriber-exclusive content directly in your inbox.

By submitting this form, you confirm that you have read and agree to the Terms and Conditions and Privacy Policy.
This field is for validation purposes and should be left unchanged.