My Oracle Support Banner

How To Audit ODI Updates Via the SDK (Doc ID 2063418.1)

Last updated on JULY 24, 2024

Applies to:

Oracle Data Integrator - Version 11.1.1.7.0 and later
Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.

Goal

Oracle Data Integrator (ODI) Studio provides a feature that helps finding ODI objects by category and name, but also based on the creation or last modification date and / or user name.

See: https://docs.oracle.com/middleware/12212/odi/ODISH/f1_find_odi_object.htm#ODISH118

The Oracle blog article "ODI - Who Changed What and When? Search!" provides pointers in finding out who last updated an ODI object and when those modifications were done.
It mentions: "The audit information is also available via the SDK and the non-supported but useful repository tables in order to build custom scripts."

How to obtain this type of audit information via the ODI APIs?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.