The ODA tool has been written to analyze database dependencies between database objects such as procedures, tables, views etc.
The tool can also be used to analyze database dependencies
between objects in Forms/Report PL/SQL code and block properties and the database objects dependencies also.
The ODA find object usage in the flat files(Unix scripts,C,XML) ,Informatica workflows and Word files.
The database dependencies hierarchy is visualized as a object dependency tree with display support of object context.
There is an opportunity of delivery reports:
- All detail Oracle objects which are used in parental object with dependencies context of use;
- An easy Oracle*forms/reports, Informatica workflows components review;
- A text of the program with the dependency allocated by color;
The
ODA will give you the answer to questions about application dependencies:
- What Database objects will be mentioned with alter the table/procedure/package/Informatica workflows?
- What DML operations are carried out above the table(select/update/delete/insert)?
From this it is possible to draw a conclusion what privileges to give the user;
- While upgrading application in other environment (9i/10g/Java) can be planned that varies;
- Display database object usage context in PL/SQL code, word documents,any text files
- Database objects dependencies tree
- Table usage in PL/SQL code with SQL statement accuracy
- Object references
- Object dependency search in PL/SQL code or any plain text files
- Globals usage in forms
- Database links usage
- Application objects relationships
- Forms/Reports explorer
- Informatica workflow explorer