Benchmark of SSIS

Hi,

Has anyone seen any benchmark results for SSIS vs Informatica?

Thanks,

David

Mariner

David,

there is document that compares SSIS and informatica here : http://www.microsoft.com/sql/technologies/integration/conchango.mspx

and some comments here:

http://blogs.conchango.com/jamiethomson/archive/2005/03/22/1172.aspx

Rafael Salas

|||Thanks, these are helpful, but are not an offical benchmark between the two products.|||

David Botz wrote:

Thanks, these are helpful, but are not an offical benchmark between the two products.

I haven't seen anything published. I think the SSIS team did some benchmarking internally though whether they would publish those results is a differernt matter. I don't know whether it was compared against other ETL tools either

-Jamie

|||My thoughts are that I wouldn't expect anything to be published because I would guess a polished Informatica tool would kick the pants off of a first-generation Integration Services build.

I would also expect that the next major release of SSIS to be a real threat once they apply their learnings from our feedback and real-world usage.|||

Phil Brammer wrote:

My thoughts are that I wouldn't expect anything to be published because I would guess a polished Informatica tool would kick the pants off of a first-generation Integration Services build.

I'm not so sure. Yes INFA have had many more years of doing this but that means that their core engine was built years ago (probably) and I would expect that since then they have tweaked it rather than re-engineered it.

SSIS has been built from the ground up on newer technology (hardware & software) and that cannot be dismissed.

So INFAs maturity/SSISs immaturity could be both an advantage and a disadvantage.

And besides, when it comes down to sheer greasy fast speed at some point you come up against physical limitations so eeking out extra nanoseconds of performance is neither here not there regardless of which you are using.

Phil Brammer wrote:

I would also expect that the next major release of SSIS to be a real threat once they apply their learnings from our feedback and real-world usage.

Ooo that sounds like a challenge Phil

My advice is not to expect too much from the next release. The SQL Server team as a whole have realised the folly of a massive release that took 5 years to build and will be progressing on shorter release tiemframes. Inevitably this means that they won't have time to get everything in there that they would like. On the plus side we get to play with the new bits alot sooner. I also know some of what is coming (though I'm sworn to secrecy). There's stuff that will delight I'm sure whilst at the same time disappointments will be there for stuff that doesn't make it in.

Having said that, I don't think I'll get into too much trouble by saying that you should expect the Script Task/Component to change a whole lot for the better in SSIS 2007

-Jamie

|||Okay, well, the one thing SSIS has going for it is its bias towards using SQL Server databases, and rightfully so. They may have Informatica there, however as of yet, SSIS is not a competitor when using other database platform destinations. So, room to grow if they want.

Jamie, I hear ya though! My comments were based on years of experience with first-gen products, MS software notwithstanding.|||

Phil Brammer wrote:

Okay, well, the one thing SSIS has going for it is its bias towards using SQL Server databases, and rightfully so. They may have Informatica there, however as of yet, SSIS is not a competitor when using other database platform destinations. So, room to grow if they want.

very very good point. its easy to forget none-SQL Server targets.

-Jamie