Java Batch Processor For OPA

(Doc ID 1944563.1)

Last updated on MARCH 02, 2017

Applies to:

Oracle Policy Automation - Version 10.4.4.21.0 and later
Information in this document applies to any platform.

Goal

Need to fetch several fields from various database tables for executing Business Rules implemented in OPA and dump data into another Database tables.,
i.e
Table A-Fields AA(int),AB(String)---AA is Primary Key
Table B-Fields BB(int),BC(String)---BB is Primary Key
Table C-Fields CC(int),CD(String)---CC is Primary Key
Table D-Fields DD(int),DE(String)---DD is Primary Key
Table E-Fields EE(int),EF(String),EG,EH,EI----EE is Primary Key
Table F--Fields FF(int),FG(String)----FF is Primary Key

created Business Rules in OPA which read fields values from AB,BC,CD,DE,EF by Java Batch Processor and dump into Fields values EF,EG,EH,EI and FG (OPA processing result data will be publish into Table E , Table F)

can it be possible with out creating SQL view or if possible in SQL view (Doc ref- http://docs.oracle.com/html/E54502_01/toc.htm#Tutorials and Samples/Eg_Batch_Processor_using_with_dbase.htm%3FTocPath%3DTutorials%20and%20examples%7C_____28) then how can result data inserted into View and its original database tables .

The customer  have to make a updatable view  but what about data accessing from  various database schema in same and different database (only Databases which support by OPA batch Processor)  .
Is it possible to map in single config.xml file or have to  create isolatedly
?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms