Biztalk vs SSIS as an ETL tool

Hello,

At our company we are considering building an architecture for file
imports and processing and considering both Biztalk and SSIS at this
time.


My understanding from reading the material out there regarding this
subject that Biztalk is more suited for integrating applications and
real time communication of information and SSIS is more suited for
bulk loads into databases/data warehouses and data manipulation.


Currently we are somewhat along the lines described above, but there
is a desire to use one technology over the other for importing files
and data manipulation, and I am not sure that is practical. Also
there is a debate currently as to whether Biztalk does better at
handling logic than SSIS.


I have read through the article on microsoft site that outlines the
above - http://www.microsoft.com/technet/prodtechnol/biztalk/2004/wh itepapers...


However, I would like to get some input from people who have actually
used both these tools in the real world for ETL process and could
provide some insight so as to help us make an informed decision.


Thanks
KR

Re: Biztalk vs SSIS as an ETL tool

On Jan 16, 9:03=A0am, KR wrote:
> Hello,
>
> At our company we are considering building an architecture for file
> imports and processing and considering both Biztalk and SSIS at this
> time.
>
> My understanding from reading the material out there regarding this
> subject that Biztalk is more suited for integrating applications and
> real time communication of information and SSIS is more suited for
> bulk loads into databases/data warehouses and data manipulation.
>
> Currently we are somewhat along the lines described above, but there
> is a desire to use one technology over the other for importing files
> and data manipulation, and I am not sure that is practical. =A0 Also
> there is a debate currently as to whether Biztalk does better at
> handling logic than SSIS.
>
> I have read through the article on microsoft site that outlines the
> above -http://www.microsoft.com/technet/prodtechnol/biztalk/2004/w hitepape=
rs...
>
> However, I would like to get some input from people who have actually
> used both these tools in the real world for ETL process and could
> provide some insight so as to help us make an informed decision.
>
> Thanks
> KR

Both products are very good but Biztalk is more for trading documents
electronically, workflow and application integration as you stated.
We have used SSIS extensively for data warehousing ETL work and would
recommend it for that of work over Biztalk.

Brad