Oracle E-Business Suite Metadata Discovery

Understanding Oracle E-Business Suite 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.

Oracle’s ever more sophisticated Applications and Fusion middleware environment presents unique integration opportunities and challenges. Challenges that stem from multiple and disparate data architectures.
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 data structures within your E-Business Suite 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 tables, making it easy to understand exactly how to join tables for BI and Systems integration projects.

Overall, Saphir enables key staff outside of the package team to understand and work with E-Business Suite data architectures with ease and without recourse to experts.

Dedicated tool for E-Business Suite metadata analysis

Saphir is the only tool capable of producing data models from as implemented E-Business Suite systems.

Saphir extracts and stores full metadata definitions from your own EBS data dictionary instances, including relationships between tables. Thereby capturing exact reference models which include all your data base customizations and extensions.
Saphir’s intuitive User Interface then allows you to easily analyse this metadata to create meaningful subject areas, which can then be exported to your chosen modeling or repository environment.

This example screen shot show the range of EBS ‘objects’ including Domains, Data Elements, Fields, Tables, Relationships, Indexes and Views that can be easily viewed and navigated from within Saphir.