Oracle Scanner Guide

Step 1: Preparation

To connect to an Oracle instance, you will need to do the following.

An Oracle DBA/Administrator must provide a native user access with the required privileges as per Oracle Integration Requirements.
An Oracle DBA/Administrator and/or network team must open firewall access between the Manta host machine and Oracle instances.
Review the other prerequisites as per Oracle Integration Requirements.

Step 2: Configure the Connection

Create a new Oracle connection in Manta Admin UI (the default URL/port showcased); that is: http://localhost:8281/manta-admin-gui/app/index.html?#/platform/connections/.

It is best-practice to create one connection for each unique Oracle instance.

Filtering the Scope of the Scan

If you leave the Extracted Schemas filtering blank (default behavior), IBM Automatic Data Lineage will perform the extraction against all schemas in the database.

Alternatively, you can build an exclusionary list. (The Excluded Schemas filtering mechanism is pre-populated by default. See the screenshot below.)

No alt text provided

JDBC Connection Details

Populate the pre-defined JDBC connection string and provide the native database account credentials with the appropriate read permissions as documented in Oracle Integration Requirements.

No alt text provided

For a detailed overview of all available configuration fields, see Oracle Resource Configuration.

Step 3: Provide External PLSQL Scripts for Lineage Analysis (Optional)

Automatic Data Lineage automatically extracts and analyzes lineage for database code (e.g., tables, views, functions, procedures, and tasks) stored directly in your Oracle environments. If you are using PLSQL scripts outside of Oracle and execute them against Oracle, you can provide them to the Manta Oracle scanner as per Oracle PL/SQL Manual Inputs.

We have also documented how to use Automatic Data Lineage to scan environments leveraging the SQL*Plus command line tool (executing SQL and PL/SQL code against an Oracle database) in How to Pre-Process Oracle and SQL Plus Scripts, along with an outline of how to handle Oracle database links in Oracle Database Links.