|
Home > Archive > BizTalk Server General > May 2006 > General Biztalk advice
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 |
General Biztalk advice
|
|
|
| Hi
My company is just about to begin to use BIZTALK 2006 (I'm scheduled for
training in a few weeks), at the moment I (and everyone else in the company)
know very little about the product.
However.... I have to give a presentation next week with an overview of how
we are going to integrate two systems together. Can you give me some
general advice on best practices for integration with BIZTALK with the
following (pretty simple) scenario :-
Two In-house applications, both using SQL 2005 Database and developed using
COLDFUSION. We need system A to send data to system B, then system B to
respond with the ID created The process does not have to be realtime, but
the data needs to get to the system within ideally 5 minutes. This
integration will not be very high volumn, maybe 500 small transactions a
day.
What I'm trying to assess is the best technical approach for doing this
(again with my limited knowledge of BIZTALK), my ideas are :-
Simple trigger based system which will write a table that BIZTALK
polls
Develop SQL 2005 Web services which would be called by COLDFUSION.
.... Something else ....
The next project after this one is SQL SERVER 2005 application to Peoplesoft
(ORACLE) so any guidance on that would also be useful.
Any help would be appreciated, I know in reality a lot more information
about the project would be needed for a full eveluation, but some initial
guidelines would be useful.
Thanks in advance
| |
| Naveenji 2006-04-28, 1:20 am |
| There are several articles in CodeProject. Please read them and understand.
http://www.codeproject.com/script/A...?userid=1909449
"...." wrote:
> Hi
>
> My company is just about to begin to use BIZTALK 2006 (I'm scheduled for
> training in a few weeks), at the moment I (and everyone else in the company)
> know very little about the product.
>
> However.... I have to give a presentation next week with an overview of how
> we are going to integrate two systems together. Can you give me some
> general advice on best practices for integration with BIZTALK with the
> following (pretty simple) scenario :-
>
> Two In-house applications, both using SQL 2005 Database and developed using
> COLDFUSION. We need system A to send data to system B, then system B to
> respond with the ID created The process does not have to be realtime, but
> the data needs to get to the system within ideally 5 minutes. This
> integration will not be very high volumn, maybe 500 small transactions a
> day.
>
> What I'm trying to assess is the best technical approach for doing this
> (again with my limited knowledge of BIZTALK), my ideas are :-
> Simple trigger based system which will write a table that BIZTALK
> polls
> Develop SQL 2005 Web services which would be called by COLDFUSION.
> .... Something else ....
>
> The next project after this one is SQL SERVER 2005 application to Peoplesoft
> (ORACLE) so any guidance on that would also be useful.
>
> Any help would be appreciated, I know in reality a lot more information
> about the project would be needed for a full eveluation, but some initial
> guidelines would be useful.
>
> Thanks in advance
>
>
>
>
| |
| Phua Chiu Kiang 2006-04-29, 1:19 am |
| It would probably be much easier and more efficient to simply write some SQL
stored procedures and ColdFusion code and get them to call each other.
Unless there are more requirements that you failed to mention, using BizTalk
in this scenario would be like using a sledgehammer to knock in a nail.
ck.
"...." wrote:
> Hi
>
> My company is just about to begin to use BIZTALK 2006 (I'm scheduled for
> training in a few weeks), at the moment I (and everyone else in the company)
> know very little about the product.
>
> However.... I have to give a presentation next week with an overview of how
> we are going to integrate two systems together. Can you give me some
> general advice on best practices for integration with BIZTALK with the
> following (pretty simple) scenario :-
>
> Two In-house applications, both using SQL 2005 Database and developed using
> COLDFUSION. We need system A to send data to system B, then system B to
> respond with the ID created The process does not have to be realtime, but
> the data needs to get to the system within ideally 5 minutes. This
> integration will not be very high volumn, maybe 500 small transactions a
> day.
>
> What I'm trying to assess is the best technical approach for doing this
> (again with my limited knowledge of BIZTALK), my ideas are :-
> Simple trigger based system which will write a table that BIZTALK
> polls
> Develop SQL 2005 Web services which would be called by COLDFUSION.
> .... Something else ....
>
> The next project after this one is SQL SERVER 2005 application to Peoplesoft
> (ORACLE) so any guidance on that would also be useful.
>
> Any help would be appreciated, I know in reality a lot more information
> about the project would be needed for a full eveluation, but some initial
> guidelines would be useful.
>
> Thanks in advance
>
>
>
>
| |
| Greg Forsythe 2006-04-29, 7:17 am |
| Check out the new SQL Service Broker in SQL 2005 for connecting your two SQL
Applications
Biztalk could prove useful for you SQL to Oracle integration
Greg
"...." <...@nowhere.com> wrote in message
news:enD$aajaGHA.4040@TK2MSFTNGP04.phx.gbl...
> Hi
>
> My company is just about to begin to use BIZTALK 2006 (I'm scheduled for
> training in a few weeks), at the moment I (and everyone else in the
> company) know very little about the product.
>
> However.... I have to give a presentation next week with an overview of
> how we are going to integrate two systems together. Can you give me some
> general advice on best practices for integration with BIZTALK with the
> following (pretty simple) scenario :-
>
> Two In-house applications, both using SQL 2005 Database and developed
> using COLDFUSION. We need system A to send data to system B, then system
> B to respond with the ID created The process does not have to be
> realtime, but the data needs to get to the system within ideally 5
> minutes. This integration will not be very high volumn, maybe 500 small
> transactions a day.
>
> What I'm trying to assess is the best technical approach for doing this
> (again with my limited knowledge of BIZTALK), my ideas are :-
> Simple trigger based system which will write a table that BIZTALK
> polls
> Develop SQL 2005 Web services which would be called by COLDFUSION.
> .... Something else ....
>
> The next project after this one is SQL SERVER 2005 application to
> Peoplesoft (ORACLE) so any guidance on that would also be useful.
>
> Any help would be appreciated, I know in reality a lot more information
> about the project would be needed for a full eveluation, but some initial
> guidelines would be useful.
>
> Thanks in advance
>
>
>
| |
| Matt Milner 2006-05-01, 1:24 am |
| You might want to consider using a combination of BizTalk and Sql Service
Broker, or just BizTalk.
You can start an orchestration from your web app by submitting to BizTalk
using a web service. your orchestration can then call to system b and get
the ID and then update system A. If you need to, you can call System A
first.
If you use SQL Service Broker, you can call a stored procedure in SQL for
System A, then use SSB to call system b and get the response. This gives
you asynchronous messaging at the database layer.
Based on your scenario, and your need to add other types of systems, I'd
start with the orchestration published as web service. Then have that
orchestration call a stored procedure in system A. At this point you can
either have system A's stored procedure use SSB to call system b, or call
system b from the orchestration. Either would work. Now you have the
orchestration in place and you can add other systems in as needed.
matt
"...." <...@nowhere.com> wrote in message
news:enD$aajaGHA.4040@TK2MSFTNGP04.phx.gbl...
> Hi
>
> My company is just about to begin to use BIZTALK 2006 (I'm scheduled for
> training in a few weeks), at the moment I (and everyone else in the
> company) know very little about the product.
>
> However.... I have to give a presentation next week with an overview of
> how we are going to integrate two systems together. Can you give me some
> general advice on best practices for integration with BIZTALK with the
> following (pretty simple) scenario :-
>
> Two In-house applications, both using SQL 2005 Database and developed
> using COLDFUSION. We need system A to send data to system B, then system
> B to respond with the ID created The process does not have to be
> realtime, but the data needs to get to the system within ideally 5
> minutes. This integration will not be very high volumn, maybe 500 small
> transactions a day.
>
> What I'm trying to assess is the best technical approach for doing this
> (again with my limited knowledge of BIZTALK), my ideas are :-
> Simple trigger based system which will write a table that BIZTALK
> polls
> Develop SQL 2005 Web services which would be called by COLDFUSION.
> .... Something else ....
>
> The next project after this one is SQL SERVER 2005 application to
> Peoplesoft (ORACLE) so any guidance on that would also be useful.
>
> Any help would be appreciated, I know in reality a lot more information
> about the project would be needed for a full eveluation, but some initial
> guidelines would be useful.
>
> Thanks in advance
>
>
>
|
|
|
|
|