A large US financial corporation is using Adaptive IT
Portfolio Manager™ (ITPM) to track its end-to-end data flows
in full detail through a complex network of applications and databases.
The original business driver was that certain figures needed to be
reported to a regulatory authority and financial penalties applied
if data errors exceed a certain level (for example a Gender field
is unknown or other than male/female).
In order to ensure the quality of the data reported
to the regulator, it is necessary to be able to trace it right back
to the system of origin and apply rigorous checks there: this needs
to be done at the individual field level to ensure that the extra
rigor is applied only where necessary.
ITPM allows the capture of the data definitions from
the different sources - including relational databases and program
structures, and the detail of the transformations that occurred -
loaded from definitions in extract-transform-load (ETL) tools. With
this detail, ITPM enables the construction of end-to-end visualization
of the information flows from any point (e.g. origin, final report,
any intermediate point), in a form suitable for both business and
technical users: and also allows the linkage of the technical definitions
to business term descriptions.
Having established the repository (regularly refreshed)
for the original purpose, it then forms a strong resource base for
other information management applications. |
