Configure an Oracle catalog source to extract metadata from an Oracle database hosted on a dedicated server, an AWS RDS Oracle instance, or Oracle Autonomous Database.
Oracle Autonomous Database is a SaaS implementation of Oracle Database on the Oracle Cloud Infrastructure.
Objects extracted
Metadata Command Center extracts the following objects from an Oracle source system:
•Database
•Schema
•Table
•View
•Materialized View
Note: Objects of the Materialized View type appear as View in Data Governance and Catalog.
•Column
- Primary Key
- Foreign Key
•Stored Procedure
•Function
•Package
•External Table
•Sequence
•Trigger
•Objects created using Oracle database link
You can also use the following SQL functionalities:
•Static SQL
•PL/SQL
•Procedure calls with parameters tracing
•Dynamic SQL with metatables
•COPY_DATA
•EXPORT_DATA
Data profiling for Oracle objects
Configure data profiling to run profiles on the metadata extracted from an Oracle source system. You can either use the Oracle connector to establish a connection to Oracle for profiling data, or use the JDBC V2 connector to enable Secure Agent-based data profiling for Oracle. You can run data profiles on the following Oracle objects:
•Table
•View
After running the data profiling capability on an Oracle catalog source, you can view the profiling statistics in Data Governance and Catalog. The data profiling task runs profiles on the following data types for Oracle objects:
•CHAR
•DATE
•NUMBER
•NUMBER (p,s)
•TIMESTAMP
•VARCHAR
•VARCHAR2
•NCHAR
•NVARCHAR2
•FLOAT (126)
•TIMESTAMP WITH TIMEZONE
•TIMESTAMP WITH LOCAL TIMEZONE
•INTERVAL DAY TO SECOND
•INTERVAL YEAR TO MONTH
•BINARY FLOAT
•BINARY DOUBLE
•FLOAT
•UROWID
•ROWID
Note: Oracle supports the maximum precision value of 38 for the NUMBER data type for data profiling.
Sampling type
Determine the sample rows on which you want to run the data profiling task. You can choose one of the following sampling types for an Oracle catalog source:
- All Rows
- Limit N Rows
Data classification for Oracle objects
Configure data classification for an Oracle catalog source to classify and organize data in your organization. You can view the data classification results in Data Governance and Catalog.
Data Lineage
The following lineage data is available for Oracle assets:
•From table to view
•Stored Procedures linked to tables or views
•Functions linked to tables or views
•Procedure calling a procedure
•Procedure calling a function
For more information about data lineage, see Data Lineage in the Working With Assets help.