|
Home > Archive > BizTalk Server Applications Integration > March 2005 > AS400 / DB2 integration with BizTalk 2004
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
AS400 / DB2 integration with BizTalk 2004
|
|
| Alan Smith 2005-03-04, 7:47 am |
| Hi,
We are looking for a way to implement a communication channel between a
system running on AS400, and using a DB2 database, and BizTalk Server 2004.
We need this channel to work in two directions, firstly to insert data into a
DB2 table, and secondly, to send a message to BizTalk when specific tables
are updated by the AS400 application in the DB2 database.
We are planning to use HIS for the data inserts, but we are looking for a
way to get the messages into BizTalk when data is updated in DB2. This may be
time critical, so a polling adapter may not provide the required response
time.
A few questions…
How would BizTalk communicate with HIS?
How could a DB2 insert or update trigger a message to be sent to BizTalk?
Is there a better alternative to using HIS to communicate with DB2?
Any help would be great,
Regards,
Alan
--
The Bloggers Guide to BizTalk
http://geekswithblogs.com/asmith
| |
| Ian Archibald 2005-03-31, 5:58 pm |
| On Fri, 4 Mar 2005 02:03:04 -0800, "Alan Smith"
<AlanSmith@discussions.microsoft.com> wrote:
> Hi,
>
>We are looking for a way to implement a communication channel between a
>system running on AS400, and using a DB2 database, and BizTalk Server 2004.
>We need this channel to work in two directions, firstly to insert data into a
>DB2 table, and secondly, to send a message to BizTalk when specific tables
>are updated by the AS400 application in the DB2 database.
>
>We are planning to use HIS for the data inserts, but we are looking for a
>way to get the messages into BizTalk when data is updated in DB2. This may be
>time critical, so a polling adapter may not provide the required response
>time.
>
>A few questions…
>
>How would BizTalk communicate with HIS?
>
>How could a DB2 insert or update trigger a message to be sent to BizTalk?
>
>Is there a better alternative to using HIS to communicate with DB2?
>
>
>Any help would be great,
>
>Regards,
>
>Alan
Hi
Let me say firstly that I work for Attunity and so could be accused of
having some bias.
Attunity has 2 products that can help with this situation.
Attunity Connect can handle the updates to DB2 on AS/400. SQL insert
statements are exposed as XML services within BizTalk and multiple
inserts can be applied within a single DB2 transaction.
Attunity Stream provides Change Data Capture and can allow changes to
specific tables, and the details of those changes, to be posted in
near realtime to a BizTalk 2004 receive port.
I would be more than happy to discuss this with you.
Regards
Ian Archibald
www.attunity.com
| |
| Ian Archibald 2005-03-31, 5:58 pm |
| On Fri, 4 Mar 2005 02:03:04 -0800, "Alan Smith"
<AlanSmith@discussions.microsoft.com> wrote:
> Hi,
>
>We are looking for a way to implement a communication channel between a
>system running on AS400, and using a DB2 database, and BizTalk Server 2004.
>We need this channel to work in two directions, firstly to insert data into a
>DB2 table, and secondly, to send a message to BizTalk when specific tables
>are updated by the AS400 application in the DB2 database.
>
>We are planning to use HIS for the data inserts, but we are looking for a
>way to get the messages into BizTalk when data is updated in DB2. This may be
>time critical, so a polling adapter may not provide the required response
>time.
>
>A few questions…
>
>How would BizTalk communicate with HIS?
>
>How could a DB2 insert or update trigger a message to be sent to BizTalk?
>
>Is there a better alternative to using HIS to communicate with DB2?
>
>
>Any help would be great,
>
>Regards,
>
>Alan
Hi
Let me say firstly that I work for Attunity and so could be accused of
having some bias.
Attunity has 2 products that can help with this situation.
Attunity Connect can handle the updates to DB2 on AS/400. SQL insert
statements are exposed as XML services within BizTalk and multiple
inserts can be applied within a single DB2 transaction.
Attunity Stream provides Change Data Capture and can allow changes to
specific tables, and the details of those changes, to be posted in
near realtime to a BizTalk 2004 receive port.
I would be more than happy to discuss this with you.
Regards
Ian Archibald
www.attunity.com
|
|
|
|
|