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
How to connect
- Connection type -choose connection type (Direct or Oracle Wallet )
- Host - provide a host name or address where a database is on. E.g. server17, server17.ourdomain.com or 192.168.0.37.
- Instance identifier - Service name or SID
- Port - type in Oracle instance port name
- User and password - provide your username and password
- Schema - you can choose schema(s) that you want to import to your documentation
- Record owner - you can choose record owner (logical layer) that you want to import to your documentation
NOTE! You can choose whether to import the physical layer, the logical layer, or both layers of Oracle PeopleSoft.
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
