Runtime Auditing for Deployments and Executions

Whenever you deploy and execute a design object, auditing information is generated and stored for you to view and manage.

The auditing information is specific to the type of object:

• PL/SQL runtime auditing is the auditing information for OWB objects deployed using PL/SQL scripts. Data objects, mappings, and process flows use PL/SQL deployments.

• Heterogeneous runtime auditing refers to auditing information about objects that are deployed to an OC4J server or a heterogeneous database such as DB2 or SQL Server. This type of auditing includes auditing from more than one Control Center Agent (CCA). This type of auditing also includes information about Code Templates, Web services, and Code Template mappings.

You view and manage the audit information through these methods:

• Control Center Manager. The Control Center Jobs panel displays a list of the deployment and executions jobs. When you double-click a job, you can see the job details.

• Repository Browser or Heterogeneous Repository Browser. You can access audit information The Heterogeneous Repository Browser enables you to access auditing information on systems that do not have Oracle Warehouse Builder installed.

• Public Views. As an alternative to using the Repository Browser, you can access the same information through the public views. To do this, start a SQL*Plus session and query the public views. Refer to Oracle Warehouse Builder Sources and Targets Guide for a list of public views.