Capabilities

Safyr for Oracle

You can use Safyr to work with the metadata in your Oracle eBusiness Suite, JD Edwards EnterpriseOne, PeopleSoft, and Siebel applications.

Safyr harvests the metadata, including your customizations, from these systems ensuring that you are working with up to date and relevant information. This process makes it immediately ready for your data engineers and data scientists to explore, analyze, curate and exploit. They do not need to possess deep technical knowledge of these packages or have access to the application’s own tools.

Without a specialist tool for metadata discovery, doing this presents a significant challenge which can threaten trust in data, delay delivery of project benefits and cause cost overruns and loss of control.

This is because of the specific characteristics of Oracle’s enterprise systems applications which include a large, unwieldy, complex and opaque metadata model. Critical information such as business names and descriptions for tables, attributes and other objects, as well as the relationships between tables and attributes is not easily available.

Oracle eBusiness SuiteJD Edwards (EnterpriseOne)PeopleSoftSiebel
Safyr schematic

Oracle eBusiness Suite

Connectivity

Safyr extracts the metadata from the application data dictionary tables in the application database using Microsoft ADO (ActiveX Data Objects).

Metadata harvested

Business (logical) and Technical (physical) names for tables, attributes, domains, views and data elements, as well as and other objects. This includes customisations.

JD Edwards (EnterpriseOne)

Connectivity

Safyr extracts the metadata from a small set of tables in the application database and from a group of XML files that are generated by a process in the JD Edwards EnterpriseOne application.

Metadata harvested

Business (logical) and Technical (physical) names for tables, attributes, domains, views and data elements, as well as and other objects. This includes customisations. The relationships (primary and foreign keys) between tables in JD Edwards EnterpriseOne are not defined in either the System Catalog or in the Data Dictionary tables. Safyr infers these from the metadata it gathers from the application.
Safyr schematic
Safyr schematic

PeopleSoft

Connectivity

Safyr extracts the metadata from the application data dictionary tables in the application database using Microsoft ADO (ActiveX Data Objects)

Metadata harvested

Business (logical) and Technical (physical) names for tables, attributes, domains, views and data elements, as well as and other objects. This includes customisations.

Siebel

Connectivity

Safyr extracts the metadata from the application data dictionary tables in the application database using Microsoft ADO (ActiveX Data Objects).

Metadata harvested

Business (logical) and Technical (physical) names for tables, attributes, domains, views and data elements, as well as and other objects. This includes customisations.
Safyr schematic

Oracle Data Models

Safyr® is more than about providing a quick way to get at relevant Oracle data models, but Oracle data models are often a by-product of using Safyr.

Be it BI for Oracle, Master Data Management for Oracle or Data Governance for Oracle, an accurate and relevant Oracle data model will often be an important step in understanding the Oracle data.

In order to illustrate what the product can do, we offer an extensive set of pre-built entity-relationship models.  Below are examples Oracle data model showing the kind of thing that is available.

Oracle e-Business Suite data model
Example of eBusiness Suite data model
JD Edwards data model
Example of JD Edwards data model
PeopleSoft Data Model
Example of PeopleSoft data model
Siebel data model
Example of Siebel data model
Oracle Data Models

Request a data model

Please complete the form below to request a Oracle data model. We will send the model to the email you supply.
We normally limit free data models to a maximum of 3 per customer. There is no obligation to buy Safyr® – the models are free.
If you don’t see a data model that you need, feel free to contact us and we will do our best to help.

Oracle eBusiness Suite

Area for data model
AP Payables
AR Receivables
BOM Bill of  Materials
FV Federal  Financials
GL General Ledger
IBY Payments
IEX Collections
INV Inventory
LNS Loans
MSD Demand Planning
ONT Order  Management
PA Projects
PN Property Manager
PSA Public Sector  Financials
QP Advanced Pricing
WSH Shipping  Execution

JD Edwards

Area for data model
Accounts Payable
Accounts Receivable
Address Book
Benefits  Administration
Contracts Billing
Employment History
Expense Management
Fixed Assets
General Accounting
Inventory  Management
Job Cost
Journals
Profit Management
Purchase Order  Process
Real Estate
Sales Order  Processing
Time Accounting
Warehouse  Management

PeopleSoft

Area for data model
Billing
Budgeting
Expenses
General Ledger
Human Resources
Inventory
Manufacturing
Order Management
Payables
Payroll
Product Management
Quality
Real Estate  Management
Receivables
Services  Procurement
Supplier Contract  Management
Supply Planning
Treasury

Siebel

Area for data model
Account
Asset Management
Auction
Compensation  Planning
Content Management
Contracts
Employee KPI
Expense Reports
Field Service  Inventory
Forecasts
Invoiceable Charges
Lead Management
Marketing Campaign
Marketing Events
Marketing Plans
Marketing Program
Opportunity  Management
Order Lifecycle
Party
Payments
Performance Review
Pricing
Professional  Services
Revenue
Service Agreement
Service Request
Shipment
Territory  Management
Timesheet
Trade Promotions
Warranty
Word Order

Discover how Safyr works with your other applications

The process of transforming raw metadata from your ERP applications into information which can be used with other data platforms and tools is made up of four main tasks. These include accessing and harvesting the application metadata as implemented, discovering and curating the critical metadata you need and then sharing it.

Safyr provides you with a single software product designed to allow data analysts to be able to complete all these steps quickly, easily and accurately.

Safyr helps you to deliver a strong metadata based foundation for your data governance, data catalog, data migration and data analytics projects which include your complex ERP applications.

SAPSalesforceMicrosoftOther