My Oracle Support Banner

ODI Enhancement Request: Request to Bring Back Temporary Interfaces in ODI 12c, Also Known as "Yellow Interfaces" in ODI 11g (Doc ID 2293193.1)

Last updated on MAY 11, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.2.6 and later
Information in this document applies to any platform.

Goal

In earlier releases of Oracle Data Integrator (ODI) 11g and lower, the temporary interfaces, also called "yellow" interfaces, allowed developers to dynamically create tables within the mapping, but without having to materialize these tables in a model. Furthermore, when the temporary interface was used in a mapping it was possible to either continue to create the table, or to bypass the table and use the temporary interface as a sub-query.

In ODI 12c, part of the functionality of temporary interfaces was replaced by reusable mappings. However, reusable mappings require an ODI model to exist.

This is a request to bring back temporary interfaces or "yellow" interfaces into 12.2.1.2.6

Currently, Global Temporary tables need to be created for this behavior. Temporary tables are generally a better descriptive and declarative way than explicit Global Temporary Tables. It will save time and maintenance needs.

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.