Oracle SQL Loader Sources > Introduction to Oracle SQL Loader sources > Extraction and view process
  

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.