Metadata and Profiling Tool Selection Improved Data Management and Analytics Capabilities

Share Via

Summary

Sagence’s metadata tool selection approach enabled an investment management firm to identify the most appropriate and cost effective solution to satisfy its enterprise metadata management and profiling needs.

Challenge

Our client is a Fortune 500 provider of investment management, asset and fund administration, fiduciary and banking solutions for corporations, institutions and high net-worth individuals worldwide with over $650B AUM and over $4T in assets under custody. They were seeking improved, cost-effective and improved data management and analysis capabilities through the use of data profiling, data quality, and metadata management tools.

Solution

Sagence presented four strategic options to meet our client’s enterprise metadata and profiling tool needs. These options included:

  1. Integrated suite: bundled package using IBM InfoSphere Information Server to understand, cleanse, monitor, transform, and deliver data
  2. Manual tools: custom queries to extract DDL and conduct data profiling
  3. Formalize and monitor: formalize existing toolsets, monitor outcomes, and tactically fill functional gaps
  4. Open source and best-of-breed: open source augmented with commercial products where applicable

 

Each option was carefully analyzed and scored for functional coverage, technical integration capabilities, path-to-support, and time to value. We recommended IBM InfoSphere Information Server as a complete solution. We identified key implementation risks and mitigation options were presented for long-term success. Sagence also developed an implementation plan outlining key action items for three primary areas: IT group readiness, enterprise operating model, and user group adoption.

Results

Our client dramatically improved management of different types of metadata within in a common repository: physical/technical metadata, logical and information models, data lineage, business glossary, and stewardship assignments. They gained the ability to reuse metadata assets and linkage across layers and now have a shared repository approach providing the lowest cross-team, cross-functional metadata management effort.