My Oracle Support Banner

How To Dynamically Set/Unset Session NLS Parameters when Connecting/Disconnection to/from ODI Data Servers (Doc ID 1462354.1)

Last updated on SEPTEMBER 20, 2023

Applies to:

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

Goal

The article applies to all releases of Oracle Data Integrator (ODI) like the current 12C as well as to previous releases.

It is now possible in Oracle Data Integrator (ODI) 11.1.1.5.0 and forward to define ODI Data Server SQL commands which will be automatically executed when a connection to a Data Server defined in the Physical Architecture is created or closed. 

Such a command can be used for altering and pre-configuring sessions (for example, for internationalization of messages or forcing implicit conversions) or in multi-tenant infrastructure where commands must be placed at connection time to access information of a given tenant.

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.