How To Configure RCU For Creating ODI Repositories On Microsoft SQLServer DBO Schema
Last updated on JUNE 28, 2016
Applies to:Oracle Data Integrator - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
How to create ODI Repositories on Microsoft SQLServer technology on a specific schema (DBO) while RCU does not provide an option to specify the schema name, only a prefix which is merged into ODI_REPO as the name of the schema?
In RCU after you specify the prefix, (PROD_ODI_REPO) and during the Repository creation process, by default PROD_ODI_REPO is defined as schema owner by RCU for all objects created under ODI Repositories.
Why does it define PROD_ODI_REPO as schema owner for ODI Repository objects, and how could this be changed?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms