1) Stored Procedure calling using DB Adapter
2) Invocation of Stored procedure using BPEL Process
Lets start configuring DB Adapter for master table insertion data from Apps to Siebel DB
1) Drag and Drop a Database Adapter in you composite. Give it a name click next and create DB connection of DB where you want to insert this Data, i am inserting this data into Siebel DB. Make sure you should create a Data source in your Weblogic and you should give your JNDI name according to that otherwise it will not work.
2) Click next and select insert only as shown below
3) Click next and choose your schema and select table in which you want to insert data and click ok
4) Click next, I am not making any relationship, so click next and on Attribute filtering screen choose attribute, where you will insert data.
5) Click next and click on deselect all as shown below to avoid any extra attribute if you do not want to include
6) Click next and then again next without any changes then finish . Your DB Adapter to insert data into Other DB is ready.
In next tutorial i will show how to use mediator to transform and insert data into DB using Mediator component.
Next Tutorial http://technasir.blogspot.com/2013/08/integration-of-oracle-ebs-with-siebel.html
Comments
2 responses to “Inserting data using DB Adapter in BPEL SOA Suite”
Thank you a lot for sharing this with all people you actually realize what you're speaking about!
Bookmarked. Kindly additionally seek advice from my web site =).
We could have a link exchange agreement between us
Here is my homepage :: how do people buy followers on twitter
These are genuinely wonderful ideas in concerning blogging.
You have touched some nice factors here.
Any way keep up wrinting.
Here is my website … ireless