Catalog Source Configuration > Oracle PL/SQL Script > Introduction to Oracle PL/SQL Script catalog sources
  

Introduction to Oracle PL/SQL Script catalog sources

You can use Metadata Command Center to extract metadata from a source system.
A source system is any system that contains data. For example, Oracle Database is a source system from which you can extract metadata through an Oracle PL/SQL Script catalog source. 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

You can use an Oracle PL/SQL Script catalog source to extract metadata from script files that define transformations on an Oracle Database. 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 a source system:
The image shows the process of metadata extraction from an Oracle 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 PL/SQL Script catalog sources:
  1. 1Register the Oracle PL/SQL Script source system with Metadata Command Center and assign a connection to the catalog source.
  2. 2Configure the catalog source. Specify the runtime environment and configure the metadata extraction capability.
  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. 5Assign a connection to referenced source system assets.

About the Oracle PL/SQL Script catalog source

You can use the Oracle PL/SQL Script catalog source to extract metadata from the Oracle Database source system.
Oracle PL/SQL Script is a set of Oracle SQL statements stored in a file which you can use to run sequential scripts.

Compatible connectors

Before you configure Oracle PL/SQL Script catalog source, you must connect to the Oracle PL/SQL database source system.
Use the Oracle connector to connect to the Oracle Database source system. For more information about configuring a connection, see Connections in the Administrator help.

Oracle PL/SQL Script extracted metadata and constraints

You can use the Oracle PL/SQL Script catalog source to extract metadata from the scripts.
Metadata Command Center extracts the following metadata from the Oracle Database source system: