Is Biztalk EAI the right solution to retrieve data for a web application
(online)residing on the same intranet as the other server and both use SQL a
s
their database?

Please respond.

Thanks,
Lakshmi

[ Post a follow-up to this message ]

Hi Lakshmi,

The EAI (Enteprise Application Integration) is a use scenario of BizTalk
Server. In EAI scenario many applications (web application, legacy
application, client/server application, and more) in the same organization
is connecting with BizTalk.

BizTalk can help you to communicate your web application with other systems.
Verify the following article the use scenarios of BizTalk Server 2006:
http://msdn.microsoft.com/library/d...cba2b6fa587.asp

Regards,
Douglas Mello
http://spaces.msn.com/dnmello


"Lakshmi" <Lakshmi@discussions.microsoft.com> wrote in message
news:392DDDA5-4C3F-449B-B9EC-18C0386B7A1B@microsoft.com...
> Is Biztalk EAI the right solution to retrieve data for a web application
> (online)residing on the same intranet as the other server and both use SQL
> as
> their database?
>
> Please respond.
>
> Thanks,
> Lakshmi

[ Post a follow-up to this message ]

Thanks Douglas for the reply. I did go through the article sent across and I
believe that EAI is appropriate when we want to integrate applications which
are completely different platforms and this integration is established using
the underlying messaging architecture. In my case, I have to develop an
intranet application (ASP.Net & SQL Server 2005) and have to retrieve data
from another system's database (CRM system, based on SQL Server 2000) and
display it on my web page.

The Biztalk Server version is 2004. I have 2 issues:

1) I am not sure if there is an adapter available for 2005 in Biztalk 2004.
2) In my case, the response time is crucial. I feel that if I use Biztalk
EAI, though the message will reach me but there is no guarantee for the
response time.

Hence I was thinking that the best way to get data from the CRM is to create
a synonym in the database and directly call it from my application.

Kindly validate my understanding.

Thanks and Regards,
Lakshmi

"Douglas Mello" wrote:

> Hi Lakshmi,
>
> The EAI (Enteprise Application Integration) is a use scenario of BizTalk
> Server. In EAI scenario many applications (web application, legacy
> application, client/server application, and more) in the same organization
> is connecting with BizTalk.
>
> BizTalk can help you to communicate your web application with other system
s.
> Verify the following article the use scenarios of BizTalk Server 2006:
> http://msdn.microsoft.com/library/d...cba2b6fa587.asp
>
> Regards,
> Douglas Mello
> http://spaces.msn.com/dnmello
>
>
> "Lakshmi" <Lakshmi@discussions.microsoft.com> wrote in message
> news:392DDDA5-4C3F-449B-B9EC-18C0386B7A1B@microsoft.com... 
>
>
>

[ Post a follow-up to this message ]

Hi Lakshmi,

Reply your questions:

1. http://support.microsoft.com/kb/915919/
2. BizTalk Server support thousand messages per second. If you have only
this integration, your BizTalk will be little used, but if your applications
to grow, to be more complex with more integration, use BizTalk Server for
develop and manage your business process.


Regards,
Douglas Mello.
http://spaces.msn.com/dnmello

"Lakshmi" <Lakshmi@discussions.microsoft.com> wrote in message
news:EE5972C8-22CC-4F9A-8298-DB31F34497FA@microsoft.com...[vbcol=seagreen]
> Thanks Douglas for the reply. I did go through the article sent across and
> I
> believe that EAI is appropriate when we want to integrate applications
> which
> are completely different platforms and this integration is established
> using
> the underlying messaging architecture. In my case, I have to develop an
> intranet application (ASP.Net & SQL Server 2005) and have to retrieve data
> from another system's database (CRM system, based on SQL Server 2000) and
> display it on my web page.
>
> The Biztalk Server version is 2004. I have 2 issues:
>
> 1) I am not sure if there is an adapter available for 2005 in Biztalk
> 2004.
> 2) In my case, the response time is crucial. I feel that if I use Biztalk
> EAI, though the message will reach me but there is no guarantee for the
> response time.
>
> Hence I was thinking that the best way to get data from the CRM is to
> create
> a synonym in the database and directly call it from my application.
>
> Kindly validate my understanding.
>
> Thanks and Regards,
> Lakshmi
>
> "Douglas Mello" wrote:
> 

[ Post a follow-up to this message ]

Hi,

A BizTalk 2004 sql adapter for sql 2005 does not come out of the box,
however there are plenty of adapters out there that can do odbc.

I have implemented a similar scenario to the one you are faced with.

One thing to be careful of.... is you do not want to implement a UI that is
sitting there waiting for the response to return from the end system. Your
user will always complain... Always try to make it a disconnected process,
the request can be sent on one page, and the response can be obtained and
returned to the application, either vi a message or direct into a table, and
the details can be then displayed on the final confirmation page. It is a
common mistake to insist on the data right there and then when you can give
your self some breathing room to get the information while the user does
other things.

When dealing with different systems, it always better to have a managed
environment for these messages, if they have to reliably get data from one
application to another. Mind you it is always faster to do it point to point
with a nasty database or something in the middle, however its also very
dirty to do it like this, and it will bite you in the end.


Paul.

"Lakshmi" <Lakshmi@discussions.microsoft.com> wrote in message
news:EE5972C8-22CC-4F9A-8298-DB31F34497FA@microsoft.com...[vbcol=seagreen]
> Thanks Douglas for the reply. I did go through the article sent across and
> I
> believe that EAI is appropriate when we want to integrate applications
> which
> are completely different platforms and this integration is established
> using
> the underlying messaging architecture. In my case, I have to develop an
> intranet application (ASP.Net & SQL Server 2005) and have to retrieve data
> from another system's database (CRM system, based on SQL Server 2000) and
> display it on my web page.
>
> The Biztalk Server version is 2004. I have 2 issues:
>
> 1) I am not sure if there is an adapter available for 2005 in Biztalk
> 2004.
> 2) In my case, the response time is crucial. I feel that if I use Biztalk
> EAI, though the message will reach me but there is no guarantee for the
> response time.
>
> Hence I was thinking that the best way to get data from the CRM is to
> create
> a synonym in the database and directly call it from my application.
>
> Kindly validate my understanding.
>
> Thanks and Regards,
> Lakshmi
>
> "Douglas Mello" wrote:
> 

[ Post a follow-up to this message ]