CA ERwin Data Modeler Saphir Option for ERP

CA ERwin Saphir Option extracts metadata from a variety of ERP applications - including SAP R/3, SAP BW, Oracle PeopleSoft Enterprise, Oracle JD Edwards Enterprise One, Oracle Siebel and Oracle eBusiness Suite. It enables you to translate the often-challenging naming conventions these system use into more user-friendly values, allowing modelers to search, browse and subset this metadata prior to creating CA ERwin data models.

Key Features

• Metadata Management: CA ERwin Saphir Option provides a complete and accurate inventory of the data structures in ERP systems. This inventory helps with data integration efforts, eliminates troublesome duplication, and keeps control of changes made from the standard system.


• Reverse Engineering: Using automatic reverse engineering capabilities, you can easily explore metadata from enterprise applications without the need for specialist application knowledge or interpretation. This automated extraction saves substantial time and money in extracting metadata and reduces dependence on application providers.


• Relationship Mapping and Navigation: See how tables are related to each other or the ERP application, as well as which tables have ‘parent’ and ‘child’ relationships. Easily navigate through the data structures and leverage these relationships to create and manage subsets of metadata that can be loaded into CA ERwin Data Modeler.


• Search and Browsing: CA ERwin Saphir Option provide a complete and easy-to-use metadata discovery and browsing environment. This interface provides capabilities such as: keyword search, object filtering, metadata drill-down and drill-across, hierarchical navigation, automated inference of undefined relationships and generation of ERP application statistics.


• Model Comparision: Model comparison allows you to understand the differences between a standard or reference version of an ERP application and a previous version of the same or a customized version that has been installed. This function lets you see the differences between implementations in different locations.


• Enterprise Information Management: CA ERwin Saphir Option and CA ERwin Data Modeler together enable metadata from enterprise applications to be transformed and shared across the entire organization’s information management landscape. Organizations benefit from centralized management of their metadata assets, such as improved application integration, enhanced quality, increased productivity and reduced maintenance costs.


• Separate Storage and Browsing Environment: With CA ERwin Saphir Option, you do not require constant ERP system access so that analysis of data models has no impact on system performance. You are able to maintain control of data models, independent from application specialists.


• Multiple ERP Support: CA ERwin Saphir Option works with a wide variety of ERP systems including: SAP/SAP BW, Oracle PeopleSoft Enterprise, Oracle JD Edwards EnterpriseOne, Oracle e-Business Suite and Oracle Siebel on both standard and customized systems.