Catalog Source Configuration > Oracle Cloud Infrastructure GoldenGate > Introduction to Oracle Cloud Infrastructure GoldenGate catalog sources
  

Introduction to Oracle Cloud Infrastructure GoldenGate 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 ADB is a source system from which you can extract metadata through an Oracle Cloud Infrastructure GoldenGate 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.
The following table describes the capabilities of the catalog source:
Capability
Description
Advanced Programming Language Parsing
Advanced Programming Language Parsing parses the source system code in addition to extracting objects from the source system.

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 Oracle Cloud Infrastructure GoldenGate:
The image shows the process of metadata extraction from a Microsoft OneDrive source system that begins with prerequisites verification, continues with the creation of the catalog source, and ends with viewing the results.
After you verify prerequisites, perform the following tasks to extract metadata from Oracle Cloud Infrastructure GoldenGate:
  1. 1Register a catalog source. Create a catalog source object, select Oracle Cloud Infrastructure GoldenGate, and specify values for connection properties.
  2. 2Configure the catalog source. Specify the runtime environment, configure the metadata extraction capability, and add filters for metadata extraction.
  3. 3Optionally, associate stakeholders. Associate users with technical assets, giving the users permission to perform actions determined by their roles.
  4. 4Run or schedule the catalog source job.
  5. 5Optionally, if the catalog source job generates referenced asset objects, you can assign a connection to referenced source system assets.
    6. You can view the lineage with object references without performing connection assignment. After connection assignment, you can view the objects.
  6. Run the catalog source again after you assign connections to referenced source system assets.
After you run the catalog source job, you view the results in Data Governance and Catalog.

About the Oracle Cloud Infrastructure GoldenGate catalog source

You can use the Oracle Cloud Infrastructure GoldenGate catalog source to extract metadata from an Oracle Cloud Infrastructure GoldenGate deployment.
Oracle Cloud Infrastructure GoldenGate is a data-replication tool to load, distribute, and filter committed transaction data within an enterprise and to enable migration between databases. You can also perform continuous extraction and replication of transactional Data Manipulation Language (DML) operations and data definition language (DDL) changes to keep your source and target data consistent.

Extracted metadata

You can use the Oracle Cloud Infrastructure GoldenGate catalog source to extract metadata from an Oracle Cloud Infrastructure GoldenGate source system.

Objects extracted

Metadata Command Center extracts the following metadata from an Oracle Cloud Infrastructure GoldenGate source system:
The following attributes are extracted for Replication Job and Replication Process: