Click here to Skip to main content
15,667,466 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello All,

Can any one help me to solve an issue regarding inserting database entry from biztalk.


Thanks in advance

What I have tried:

I saw various plural sights videos, you tube videos, read msdn tutorials.
Posted
Updated 24-Feb-16 10:55am
v2
Comments
Suvendu Shekhar Giri 16-Feb-16 3:24am    
.. and have you tried implementing anything after watching those videos and tutorials?
Member 10239808 16-Feb-16 3:43am    
No i didn't found yet the exact way to do so. So not implemented yet. Thanks!

1 solution

Hi,

We can use SQL adapter to insert table entries from BizTalk.

Steps:

1.Make the database table ready.(Or create a new table)
2.Create a new BizTalk project, Add--> Add Generated Items.
3.Select Add adapter metadata.
4.In the Add adapter wizard, select adapter (SQL), SQL Server and database name.
No need to give port name here.
5 Create the connection string using SQL transport schema generation wizard and click next.
6.Give target Namespace (should you this same in the XML). Then select port type as 'Send Port', then provide request and response root element name.Click next.
7.Here we can select if we need to just insert entries to tables or use storedprocedures. Select Updategram and click next for inserting.
8. Select the table and required columns. Click next and we're done.
9.One orchestration and schema will be generated for this. Just finish the orchestration connections and deploy the project. Create receive(use File adapter) and send ports(use SQL adapter) in the application.
10. Drop the xml which has the data to be inserted into the table in the receive location. Check the table, it will be updated with the entries.

Regards,
Haris
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900