ODI 12c Online Training

Search This Blog

Oracle Data Integrator Architecture

May 26, 2012

Get link
Facebook
X
Pinterest
Email
Other Apps

Oracle Data Integrator Architecture

The architecture of Oracle Data Integrator relies on different components that collaborate together, as described in Figure 1-6.

Figure 1-6 Functional Architecture Overview

ARCHITECTURE

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Get Physical Schema name using odiref in ODI

Using below method we can get Database SchemaName. select * from all_tables where owner= '<%=odiRef.getSchemaName()%>' Using below method we can get Database SchemaName for Default Physical Schema from your Databaserver. select * from all_tables where owner= '<%=odiRef.getSchemaNameDefaultPSchema()%> '

BI Publisher error : Server not initialized. Please make sure the repository is ready

BI Publisher error : Server not initialized. Please make sure the repository is ready Solution: ---------- MW_HOME\user_projects\domains\bifoundation_domain\config\bipublisher Edit xmlp-server-config.xml file add below two lines and if already exists verify both repository path. <?xml version="1.0" encoding="UTF-8" standalone="no"?><xmlpConfig xmlns="http://xmlns.oracle.com/oxp/xmlp"> <resource> <file path="${xdo.server.config.dir}/repository"/> </resource> <config> <file path="${xdo.server.config.dir}/repository"/> </config> </xmlpConfig>

ODI 12c 12.1.3 Repository Tables : Master 67 tables & Work 153 tables total 220 tables.

Master repository Tables: 67 TNAME TABTYP ------------------------------ ------ SNP_ACTION TABLE SNP_AGENT TABLE SNP_AGENT_PROP TABLE SNP_AGENT_PROP_LST TABLE SNP_ALLOC_AGENT TABLE SNP_CONNECT TABLE SNP_CONNECT_PROP ...

Oracle Data Integrator Architecture

Oracle Data Integrator Architecture

Comments

Post a Comment