You can use the Oracle catalog source to extract metadata from an Oracle source system. You can also run profiles and configure other capabilities, such as data classification.
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.
Extracted metadata
You can use the Oracle catalog source to extract metadata from an Oracle source system.
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
Note:
- For Oracle On-premise you can extract data from external tables created in File System and Hadoop Distributed File System source systems.
- For Oracle ADB you can extract data from external tables created in Amazon S3, Microsoft Azure Data Lake, and Oracle Cloud Object Storage source systems.
You can extract data from the external tables created with DBMS_CLOUD.CREATE_EXTERNAL_TABLE and DBMS_CLOUD.CREATE_EXTERNAL_PART_TABLE procedures.
•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 view the profiling statistics in Data Governance and Catalog.
You can run data profiles on the following objects:
•Table
•View
•External table
The data profiling task runs profiles on the following data types:
•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 a maximum precision value of 38 for the NUMBER data type for data profiling.
You can perform data profiling on Oracle external tables, run data quality automations for Oracle external tables, and profile catalog sources with Oracle and Oracle external tables.
To create an external table, obtain data from one of the following sources:
•Oracle Loader
•Oracle Data Pump
•Large Object columns (LOBs)
•CSV delimited files
For more information, see the corresponding third-party vendor documentation.
Compatible connectors
Before you configure an Oracle catalog source, you must connect to the Oracle source system.
Use the Oracle connector to connect to the Oracle source system in Administrator.
For information about configuring a connection, see Connections in the Administrator help.