Peoplesoft Metadata Discovery

Understanding PeopleSoft Enterprise data as easily as all other corporate data sources is a major metadata intelligence challenge.

Without this understanding, companies increase the risk of a critical operational system becoming isolated and difficult to integrate with wider corporate data and systems.

The challenge comes about because of the complex & closed nature of the PeopleSoft Enterprise data architecture and the high degree of specialist knowledge required to implement & maintain it.

The solution to the problem lies in ready access to comprehensive metadata in a form that is usable by all of the technical & analyst teams across the company.

Saphir is a unique metadata intelligence tool that helps solve this problem by allowing you to locate and understand the complex data structures within your PeopleSoft Enterprise databases, including any database customisations and extensions that you have made.

Saphir presents data warehouse designers, business analysts and information management teams with full details on the relationships between PeopleSoft Enterprise tables, making it easy to understand exactly how to join tables for queries and data extraction

Overall, Saphir enables key staff outside of the PeopleSoft Enterprise team to understand and work with PeopleSoft Enterprise data architectures with ease and without recourse to PeopleSoft Enterprise experts.

Dedicated tool for PeopleSoft metadata analysis

Saphir is the only tool capable of producing PeopleSoft data models from Enterprise systems as implemented.

Saphir provides a new window into the PeopleSoft metadata. Saphir lets you browse and search through the PeopleSoft tables and fields using a powerful and intuitive interface.    

The PeopleSoft data dictionary holds definitions of the relationships between tables, but there are many more 'implicit' relationships not formally defined.

Saphir uses a powerful inference engine to work out the links between PeopleSoft tables and then combines these with the existing relationship definitions to give a complete picture of your PeopleSoft database. 

Saphir will appeal to anyone wanting to gain a better understanding of the PeopleSoft data structures and is particularly suited to implementation teams, data warehouse designers, business information analysts and members of information management groups.

This example screen shot shows one of the PeopleSoft tables in Saphir. The display shows not only the ‘technical’ and ‘descriptive’ names for each column, but also which columns form the Primary Key (gold key symbol) and which are Foreign Keys (green relationship symbol).