Metadata and Profiling Tool Selection Improve Data Management and Analytics Capabilities

Share Via

Summary

Sagence’s data selection tool services 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 leading 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 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.

Share Via

Sign up to receive our latest insights:

Please enter a valid email address.
Something went wrong. Please check your entries and try again.

We value your privacy and will never sell your personal information.

Sagence is a management consulting firm advising clients in information-intensive industries. We specialize in data management and analytics and in the acquisition, evaluation, and development of critical data assets. Contact us today to learn how we can help you leverage your data as an asset.