Metadata and Profiling Tool Selection Improve Data Management and Analytics Capabilities
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.
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.
Sagence presented four strategic options to meet our client’s enterprise metadata and profiling tool needs. These options included:
- Integrated suite: bundled package using IBM InfoSphere Information Server to understand, cleanse, monitor, transform, and deliver data
- Manual tools: custom queries to extract DDL and conduct data profiling
- Formalize and monitor: formalize existing toolsets, monitor outcomes, and tactically fill functional gaps
- 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.
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.
Sign up to receive our latest insights:
We value your privacy and will never sell your personal information.