| Craig Yellick 2004-03-11, 10:43 pm |
| Perfect timing, Juan. I just completed an Application Integration
Component (AIC) that performs inserts into a SQL Server database,
based on data read from an interchange.
There are three parts to your question.
1. Reading an XML document and determining what modifications need to
be made to data in the database. This has very little to do with
BizTalk. BizTalk will hand you the XML document and the rest is up to
you. (I assume you'll want to use the XML version of the interchange,
that's not required.)
2. Getting BizTalk to call your component. This is done by configuring
a port that uses your component (known as an AIC). The port will hand
the interchange document to your component. On the surface this seems
simple, but in practice there are many details that must be
implemented and installed just right for it to work. Briefly, your COM
component must expose specific interfaces to BizTalk and be registered
in with the correct "implemented categories" affinity for BizTalk.
3. On-going administrative support for your component in production.
This can be a challenge as well. Items #1 and #2 above will work fine
with everything hard-coded in your .DLL: database connection string,
etc. Getting that stuff out of the .DLL and into a process that can be
administrated by someone other that the developer is important. Since
BizTalk runs the AIC "in the dark" so to speak you'll need to handle
all exceptions and be sure to log key events and errors.
If you want to know more about any of the above, just ask. I've spent
the last two weeks deeply immersed in all three.
-- Craig Yellick, Alto
"Juan" <anonymous@discussions.microsoft.com> wrote in message news:<8df701c40521$fe4dfcc0$a001280a@phx.gbl>...
> Could you help me about how BTS adapters modify un SQL
> database using a message from the output pipleline ?
> The adapter includes the needed SQL ?
> Thanks
|