Catalog Source Configuration > Oracle SQL Loader > Introduction to Oracle SQL Loader sources
  

Introduction to Oracle SQL Loader 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 SQL Loader is a source system from which you can extract metadata through an Oracle SQL Loader 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. Then you configure capabilities for the catalog source. A capability is a task that Metadata Command Center can perform, such as metadata extraction, lineage discovery, data profiling, data classification, or glossary association.
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
Lineage Discovery
Builds the complete lineage of a catalog source by recommending endpoint catalog source objects to assign to reference catalog source connections. When you run the catalog source job, Metadata Command Center assigns the reference catalog source connections to CLAIRE recommended endpoint catalog source objects. You can then view the list of CLAIRE recommendations and accept or reject them.

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 a source system: The image shows the process of metadata extraction 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 SQL Loader:
  1. 1Register a catalog source. Create a catalog source object, select Oracle SQL Loader, and then select and test the connection.
  2. 2Configure the catalog source. Specify the runtime environment and configure parameters for metadata extraction. You can also configure other capabilities such as lineage discovery.
  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. For connection-aware scans, 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 SQL Loader catalog source

You can use the Oracle SQL Loader catalog source to extract metadata from an Oracle SQL Loader source system.
Oracle SQL Loader is an Oracle utility to load bulk data from external files into Oracle database tables.

Extracted metadata

You can extract specific metadata from an Oracle SQL Loader source system with an Oracle SQL Loader catalog source.

Objects extracted

Metadata Command Center extracts the following metadata from an Oracle SQL Loader source system:

Compatible connectors

Before you configure an Oracle SQL Loader catalog source, you must connect to the Oracle SQL Loader source system.
Use the Oracle connector to connect to the Oracle SQL Loader source system. For information about configuring a connection, see Connections in the Administrator help.