Let's face it - data is the lifeblood of any company. And for SQL Developers and DBAs, knowing the relationships and origins of data can be the difference between meeting a deadline or not.
As a new Product Engineer at Pragmatic Works, I find that a common issue developers face is knowing what is going to break downstream upon making changes to their ecosystem, like a package or table name, for example. Additionally, a common question may be, "How did my data get into this column?"
This is where lineage and impact analysis come in handy. Lineage analysis is essentially “the family tree” for your data, documenting where your data comes from and goes to. Impact analysis allows you to monitor the resulting effects of any changes implemented.
Pragmatic Works' Lineage and Impact Analyzer feature in DOC xPress gives you an interactive graphical user interface (GUI) that allows you to rapidly explore lineage models and lineage details.
This video demo shows how the Lineage and Impact Analysis feature works in DOC xPress:
Most importantly, you don't need to write a single line of code! You can automatically see where your data comes from and goes to, as well as how your data is going to be affected down the line.
This Lineage and Impact Analysis feature is available in Pragmatic Works’ DOC xPress, or as part of our Workbench package. Visit our website or click the download link below to integrate this, and all the fantastic features of DOC xPress, into your data world.