Introduction to Oracle Business Intelligence catalog sources
You can use Metadata Command Center to extract metadata from a source system.
A source system is any system that contains data or metadata. For example, Oracle Business Intelligence Enterprise Edition Presentation Server is a source system from which you can extract metadata through an Oracle Business Intelligence catalog source with Metadata Command Center. A catalog source is an object that represents and contains metadata from the source system.
Before you extract metadata from a source system, you first create and register a catalog source that represents the source system.
When Metadata Command Center extracts metadata, Data Governance and Catalog displays the extracted metadata and its attributes as technical assets. You can then perform tasks such as analyzing the assets, viewing lineage, and creating links between those assets and their business context.
You can only extract metadata using this catalog source.
Extraction and view process
To extract metadata from a source system, configure the catalog source and run the extraction job in Metadata Command Center. Then view the results in Data Governance and Catalog.
The following image shows the process to extract metadata from an Oracle Business Intelligence source system:
After you verify prerequisites, perform the following tasks to extract metadata from Oracle Business Intelligence:
1Register a catalog source. Create a catalog source object, select Oracle Business Intelligence, and specify values for connection properties.
2Configure the catalog source. Specify the runtime environment, configure the metadata extraction capability, and add filters for metadata extraction.
3Optionally, associate stakeholders. Associate users with technical assets, giving the users permission to perform actions determined by their roles.
4Run or schedule the catalog source job.
5Optionally, if the catalog source job generates referenced asset objects, you can assign a connection to referenced source system assets.
You can view the lineage with object references without performing connection assignment. After connection assignment, you can view the objects.
After you run the catalog source job, you view the results in Data Governance and Catalog.
About the Oracle Business Intelligence catalog source
You can use the Oracle Business Intelligence catalog source to extract metadata from the Oracle Business Intelligence Enterprise Edition Presentation Server.
Oracle Business Intelligence is a business intelligence tool to gather, store, and visualize enterprise data. You can create and configure an Oracle Business Intelligence catalog source to extract metadata from the Oracle Business Intelligence Enterprise Edition Presentation Server. Metadata Command Center extracts report objects that include presentations, business, and physical models.
Extracted metadata
You can use the Oracle Business Intelligence catalog source to extract metadata from the Oracle Business Intelligence Enterprise Edition Presentation Server.
Metadata Command Center extracts the following metadata from an Oracle Business Intelligence source system:
•Alias
•Alias Column
•Alias Key Column
•Alias Table
•Answers Report
•Business Model
•Business Model and Mapping
•Catalog
•Condition
•Criteria
•Criteria Column
•Criteria Hierarchical Column
•Dashboard
•Dashboard Page
•Dashboard Prompt
•Database
•Derived Logical Column
•Derived Presentation Column
•External Schema
•Folder
•Hierarchy
•Key
•KPI
•Logical Column
•Logical Dimension
•Logical Fact Table
•Logical Key Column
•Logical Level
•Logical Table
•Measure
•Physical Column
•Physical Key Column
•Physical Table
•Presentation Column
•Presentation Fact Table
•Presentation Hierarchy
•Presentation Level
•Presentation Table
•Presentation Variable
•Presentation Variables
•Prompt
•Prompt Answer
•Report
•Report Field
•Repository
•Repository Variables
•Session Init Block
•Session Initialization Blocks
•Session Variable
•Session Variables
•Static Variable
•Static Variables
•Subject Area
•Variables
Note: You cannot extract a Publisher Report and its child objects.