When you have a BPEL Process, and it needs to perform an operation on a Database Table, for example, insert an employee, you have to use the Database Adapter. The Database Adapter exposes to SOA, tables and SQL transparently and non-intrusively.
In this post, I will create a BPEL Process to insert employees into Employees table from HR Schema. Best practises, like the use of MDS and Mediator, are not the purpose of this post. Download the sample application: SOADBAdapterApp.zip.
Create a SOA Application.
In Step 1, set the Application Name and Application Package Prefix.
In Step 2, set the Project Name. Read the complete article here.
For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.