Oracle Peoplesoft

Catalog and documentation

Data catalog

Dataedo documents metadata of following objects:

• Tables
• Views
• Materialized views
• Procedures
• Packages
• Functions
• Sequences
• Jobs

Besides that Dataedo, imports PeopleSoft record (logical layer):

• SQL Table
• SQL View
• Query View

Imported objects

Object	Imported as
Table	Table
View	View
Materialized view	Materialized view (view subtype)
Procedure	Procedure
Package	Package
Function	Function
Sequence	Sequence
Job	Task/Job
SQL Table	Object (table subtype)
SQL View	Perspective (view subtype)
Query View	SQL Query

Supported features

Feature	Imported
Import comments	✅
Write comments back	✅
Data profiling
Generating DDL
FK relationship tester
Statistics import
Linked Sources
Data Quality

Required access level

Importing database objects requires certain access level in documented database. User specified in "Import objects from database" window should at least have "Connect" role, and "Create session" system privilege.

Importing objects definition from different schema requires either SELECT_ANY_DICTIONARY (recommended) or SELECT permission on any table, view and Execute on any procedure, function, sequence and job that are to be documented.

No data is altered in source database during a synchronization process.

Following objects are accessed during schema (physical layer) import process:

• all_constraints
• all_cons_columns
• all_objects
• all_tab_columns
• all_tab_comments
• ALL_ARGUMENTS
• ALL_CONSTRAINTS
• ALL_CONS_COLUMNS
• ALL_INDEXES
• ALL_IND_COLUMNS
• ALL_SOURCE
• ALL_TRIGGERS
• ALL_SEQUENCES
• ALL_SCHEDULER_JOBS
• dual

Following objects are accessed during record owners (logical layer) import process:

• PSRECDEFN
• PSSQLTEXTDEFN
• PSDBFIELD
• PSRECFIELD