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.
Updated 24-Feb-16 10:55am
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


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


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.

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