OIC - How to modify XSLT for complex logic externally using Jdeveloper tool

Sometimes we may need to do some complex map logic which sometime not possible in OIC itself. In that case, we can add the complex logic externally using Jdeveloper tool and import back to OIC.

Steps in Brief:

1. Export the OIC .iar file
2. Open Jdev and import the .iar file as service bus resources
3. After import, open the XSLT map and add your logic and test accordingly.
4. Import the modified XSLT file back to OIC.

Implementation steps:

Export the OIC Integration

Import from Jdev

Choose "Service Bus Resources" option

Select "Zipped /Archived resources

After import, modify the map

Deactivate OIC integration and edit and select mapper activity and select More options

Select Import

Select the updated XSLT

After import , save , activate and test

See the updated logic is working as expected.

ODI - Sql query to monitor TEMP size and resize

Query to monitor the temp total, used and free space in mb:

Select A.tablespace_name tablespace , D.mb_total, SUM(A.used_blocks * D.block_size) / 1024 / 1024 mb_used, D.mb_total - SUM(A.used_blocks * D.block_size) / 1024 / 1024 mb_free

From v$sort_segment A, ( select B.name, C.block_size, SUM(C.bytes) / 1024 / 1024 mb_total from v$tablespace B, v$tempfile C where B.ts#= C.ts#

Group by B.name, C.block_size) D

Where A.tablespace_name = D.name

Group by A.tablespace_name, D.mb_total

Query to Resize the temp file space:

Alter Database TEMPFILE 'tempfile' RESIZE 300G

ODI 11g and 12c Architecture

 

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.