Is anyone have comparisions of ETL tools in the Market?
Ex: DI, Informatica, Abintio, Datastage, Power Builder, DTS etc…
KrishnaT (BOB member since 2005-04-12)
Do a search under www.google.com and search for ‘Compare ETL Tools’, I found a lot there.
Have a great day.
MayhewM 
(BOB member since 2003-10-22)
hi friend
pl share the information with us reg ETL tool comparison
regards,
True friend
niranjan_d (BOB member since 2003-11-21)
Google doesn’t return much – you mostly find forums with other people asking the same question.
I mostly encounter people who have done just one ETL tool, Informatica or Ascential. Occasionally, someone who has done both. But very few people have experience wtih DI plus both of those other ETL tools. Ab Initio is also smaller in market share.
Regarding DTS: DTS with SQL 2000 isn’t close to DI’s capabilities. But the new version coming with SQL Server 2005 is significantly advanced. BusObj should take notice and be sure they’re keeping DI “ahead of the curve”. (It will be easy for BO to dismiss DTS as something only SQL Server shops would use, and not powerful enough. That would be a mistake.)
dnewton (BOB member since 2004-01-30)
From what I have seen DTS is still “just an programming environment”. Okay, you get nice looking icons for e.g. stored procedures but it is still a stored procedure. No optimizer behind, SQLs have still to be created manually, limited connectivity to non-RDBMSes, etc, etc, etc. I am not very impressed, but keep in mind, I am also just such a person who has worked with one ETL tool only…
Werner Daehn 
(BOB member since 2004-12-17)
I think this will only be the second time I know of that Werner and I disagree. heh. SQL DTS is still “just a programming” environment, not a true 4GL with optimizers, etc. BUT, it handles non-RDBMS files in a more robust manner than DI, in my experience so far. You cannot for instance, have DI auto-sense the file format dynamically if your file can vary in format each time you get it. It also has native connectivity to Excel and can retrieve result sets from a stored procedure call and pass them on to later steps, which DI is lagging behind on (I keep hoping they will surprise me). Other than that, I am very happy with the many, many things that DI does that I had to write thousands (literally) of lines of SQL to do in DTS. And the tech support for DI is second to none.
- Ernie
eepjr24 (BOB member since 2005-09-16)