ODI 12c - Standalone and J2ee agent configuration

Steps to configure Standalone and J2ee agent:

Go to ODI installed path Oracle/Middleware/Oracle_Home/oracle_common/common/bin and run config 

Create a new domain.

Select templates to be installed required for Agents

Create an Admin server

Create ODI manage servers.

Create Machine

Create Standalone agent

Run installNodeMgrSvc

Services.msc in run and start it

Odiconsole 

Start the standalone agent

Once weblogic started, login console and check alll servers, deployment etc and test your created both standalone and j2ee agent.

From Weblogic, you can go to Deployments -- OracleDIAgent -- testing  to test the oracle j2ee agent.

ODI 12c - CKM with Flow control and Static control and Recycle errors

Here, we will show the setups required for Flow control , Static control and Recycle errors.

Brief steps:

1. Create a Primary key constraint on target data store.

2. Create a map and Select flow or static or recycle errors option

Flow diagram for LKM, IKM,CKM:

Implementation steps:

Step1: open the target data store constraints and control tab to checj if there is any duplicate rows.

Step2: Create  a new map and prividd LKM, IKM and Flow control as False and Statc control as true and run. You will see the the duplicate or null errors in E$_EMP table.

Step3: Now make Flow control also True

Step4: Now make Recycle errors as True

ODI 12C - CDC implementation using JKM

Here, we will see how to capture changed data(New inserted data and update data) using JKM and send the data to Target.

Implementation steps:

Step1: import JKM 

Step2: model -- Journalizing -- select Journalizing mode . Here choosing Simple and select KM.

Step3: Open Datastore and constraints -- create primary key as empno.

Step4: EMP datastore -- CDC -- Subscriber -- subscribe. Add one subscriber.

Step5: Add to CDC

Step6: Start Journal ans select subscriber.

Step7: you can check that Subscribers will be created and J$ and JV$ tables.

Step8: add emp table in the journalized table.

Step9: do the mapping Nd select subscriber in the logical Journalizing section

Step10: Add LKM and IKM and flow control as false.

Step11: select source unit and check the option Journalized Data only.

ODI 12c - Manually run a load plan if schedule not worked automatically

If schedule does not work automatically then we can run the load plan manually.

Steps:

Operator tab →Load plans and scenarios →select your load plan→ right click on and run and select your agent and ok.