BizTalk Server serves as a wonderful application for the
business enterprises, thanks to the feature of the Adapters. Here we shall talk
about SQL Adapter. One of the common problems faced by those using this server
is to build multiple SQL Ports to call various stored procedures on the same
database. The SQL Adapter comprises of the Add Generated Items wizard that is
definitely helpful in doing so, though these are some of the things that it
does not take care of.
First of all it builds a new orchestration enclosing the
multipart message classes and the port that you can make use of for calling the
Adapter. Next it provides some horrible names to the Orchestration, Port, and
schema file/ type. The major issue crops up when you have to bind the Microsoft BizTalk server orchestration
ports. You will be left with four different send ports when you employ four
varied stored procedures on a single database by default as each needs a root
element and namespace of the returned message.
For avoiding the need to build a separate port for each of
the SQL calls, at the time of creating the schemas by means of the wizard, same
namespace must be used every time. The root response element must also be named
the same. This Adapter among many other BizTalk adapters makes sure that this does not have any effect on the returned data
by putting them under this node. After that, all the response elements having
the same name are to be combined together into one schema. If you are using an
Orchestration, then add the operations to a single SQL Port that you have. This
facilitates message routing.
No comments:
Post a Comment