Safyr® for Oracle eBusiness Suite Metadata Visualization and Discovery – powerful exploration software to access, understand and exploit your metadata.
Safyr® for Oracle eBusiness Suite is a powerful metadata visualization and discovery technology product that your data analysts and data scientists can use to gain insight into and exploit the data architecture in your own customized Oracle eBusiness Suite systems. This is a critical task for accelerating effective delivery of a wide range of information led projects. You utilise it to speed up the source data discovery process for many projects such as data catalog, data governance, data warehouse, data analytics, master data, data integration, data migration and more.
Whether you are looking for a single table in Oracle eBusiness Suite (e.g. Per_all_assignments, GL_Ledgers, BOM_resources), with its business names, attributes and relationships with other tables; or thousands of tables for your enterprise data catalog, Safyr for Oracle eBusiness Suite for metadata discovery will be of value to you.
Oracle eBusiness Suite presents you with some specific challenges when you come to try to make sense of its metadata. For example the physical names for tables and fields can be opaque. Also, the relationships between the tables are not defined in the data dictionary tables. Finally, there are tens of thousands of tables which make up this application. The combination of these characteristics make it very hard for you to navigate and make sense of the data model.
“Please pass this on to everyone at SAFYR. Each person I had contact with at SAFYR was professional, polite, patient … first class.”
“Also, I enjoyed using SAFYR because it accomplished complex tasks and yet, and most importantly, it is easy to use … a rare and valuable quality in today’s world.”
Customers use Safyr to solve the 3 challenges associated with Oracle eBusiness Suite Metadata Discovery.
Discovery: Locating the source of the useful, business ready metadata in your applications. There is very little of any value in the data system catalog. The useful metadata is in a series of data dictionary tables in eBusiness Suite.
Scoping and curation: Once the metadata has been located, the next challenge is to find the table or tables necessary for your task and save them for use in other tools and systems.
Delivery: The final hurdle is to provision the metadata into other tools and technical formats. These include data catalog and governance solutions such as Collibra, Informatica EDC, Alation, Infogix, ASG and Adaptive as well as data modeling tools such as SAP PowerDesigner, ER/Studio, erwin. Or you might want to use the information in Excel, CSV, XML or JSON formats.
Scroll down for more information on Safyr for Oracle E-Business Suite.
Safyr reveals details of all the tables in the E-Business Suite database, including any added by the user.
All the information displayed are drawn from the Oracle EBS Data Dictionary. It’s easy to search the tables and to see the numbers of relationships to other tables in the Oracle EBS system, and the number of Rows in each table.
Show full details of an Oracle EBS Table
Each table can be expanded to show all the Fields, the Primary Key and Foreign Keys and a detailed description of each Field, all based upon the definitions in the Oracle EBS Data Dictionary.
Safyr extracts Relationship information to help the user understand how Oracle EBS joins tables. Using this information, details of the related tables for a given table can be displayed. In addition, its easy to filter out any of the related tables that do not contain data.
See tables in a Hierarchy of Oracle EBS Modules
As well as seeing tables in list form, Safyr provides a Hierarchy of Oracle EBS modules, grouping the Tables by business areas like Accounts Payable, Risk Management, Inventory and Order Entry.
Visualize Oracle EBS Tables as a Data Model
Tables can be grouped into Subject Areas with Safyr and then visualised as an Entity Relationship diagram, either using Safyr’s built-in ERDiagrammer, or a range of popular data modelling tools including ERwin, ER/Studio and PowerDesigner.
An accurate and relevant Oracle E-Business Suite data model will often be an important step in understanding Oracle E-Business Suite data. Request a Oracle E-Business Suite Data Model that best fits your requirement.
Read our blog post for more on making models from selected Oracle EBS tables.
Pre-built Subject Areas of Oracle EBS Tables
Not only does Safyr let you browse and build your own Subject Areas, but we deliver over 100 ‘pre-built’ Subject Areas based upon popular grouping of EBusiness Suite Tables. These give users a fast-start to quickly identifying tables for key business domain areas. These include, Accounts Payable, Bill of Materials, Quality Management and many more.
We can help with your Business Case for Safyr.