Inserting data using DB Adapter in BPEL SOA Suite

In this Post i am going to show how to insert data using DB Adapter in SOA Suite. This is a integration of Oracle Apps with Siebel CRM. First i will show you how to configure DB Adapter to insert data in it. I have two tables master and detail. I will show you only master table insertion wizard, however this can be done in combine as well. You can also create relationship between table in DB Adapter but i am not going into much detail. Please see following posts for basic development and pulling data from Apps DB. I have done this already so you should complete this. Now i will insert that apps data to Siebel CRM table.
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


Posted

in

by

Tags:

Comments

2 responses to “Inserting data using DB Adapter in BPEL SOA Suite”

  1. Anonymous Avatar
    Anonymous

    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

  2. Anonymous Avatar
    Anonymous

    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