First, install Odi.
Odi Installation
If WLS is not installed, you can choose to install it independently, as shown in.
Install the SDK by following the steps.
RCU creates a service table
You need to create a service tables in RCU. The master/worker repository created in ODI studio does not have a service table in the ODI component data source. You also need to have master repo when creating the agent, which can be created in RCU or in ODI studio.
If ODI is installed on the Enterprise Edition (that is, WLS), the interface is as follows:
Create proxy
You still need to create a domain.
The schema owner and password corresponding to the service table created in the preceding RCU are required.
Password: odi/welcome1
Add a proxy in ODI Studio
Must be the same as the previous name
Add the agent to ODI toplogy and use hostname instead of localhost.
Start proxy and Test
After configuration is complete
C: \ oracle \ middleware \ ORACLE_HOME \ user_projects \ Domains \ odi_domain \ bin \ agent-name = oraclediagent1-Port = 20910
Testing in ODI
Odi 12.1.3 create standalone proxy