ODA Edition

The ODA edition tool has been written to analyze database dependencies between database objects such as procedures, tables, views etc.

 

Display object usage context.

 Database dependencies tree.

Able usage in PL/SQL code with SQL statement accuracy.

Object dependency search in any PL/SQL code.

Database links usage.

Globals in forms.

Application objects relationships.

Forms/Reports explorer.

Informatica workflow explorer.

 

 

ODA Edition (Oracle)

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 finds object usage in the flat files(Unix scripts,C,XML) and Informatica workflows.The database dependencies hierarchy is visualized as an object dependency tree with display support of object context.

You can provide the following reports:

    •   All detail Oracle objects which are used in parental object with dependencies context of use;
    •   An easy Oracle*forms/reports, Informatica workflow components review;
    •   A text of the program with the dependency allocated by color;  

   

 

The ODA edition 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;