| Author |
Topic |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2007-06-04 : 14:08:16
|
| Our company is willing to switch ETL Tool vendors, we currently use AbInitio (http://www.abinitio.com) and we're looking for a new ETL tool.If you can, let me know what you like/don't like on your current ETL software so I can take a look at what's available out there.---"Try not to become a man of success but rather try to become a man of value." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-04 : 14:15:03
|
| Why not just use Integration Services?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-04 : 14:35:35
|
| Because Integration Services allows you to program. Using T-SQL and sqlcmd for complex transformations would not be easy.I personally don't use Integration Services as we don't currently have a need for it. I simply use bcp and then T-SQL to transform. But you wouldn't want to do that for complex stuff.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-06-04 : 15:59:23
|
| I'm not that familiar with SSIS yet, we're trying to migrate smaller processes to SSIS to see how it goes, we could already tell that SSIS doesn't do a great job when it comes to manipulate files/data in files, for that, AbInitio still best, SSIS is just great when it comes to load and transform data from server to server, for that I'll give a 10/10.I wish T-SQL and SQLCmd could handle it... We must use a whole separate ETL tool to integrate all the data we get from different vendors, abinitio does a great job on that plus applying business rules and manipulate files, it does all of that at the file level, we do all of these processes in the AbIntio environment and load the records to SQL Server afterwards.I heard of another tool called "Informatica", I might give that a shot, let me know if anyone knows anything about this and any other tools.---"Try not to become a man of success but rather try to become a man of value." |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-04 : 16:13:17
|
| I worked on Informatica a little bit. We migrated data from DB2 to SQL Server and back. Just a combination of part legacy and part custom stuff. It was pretty good. Except the error messages are not all the time very explanative as to what went wrong. I have no idea of "AbInitio" so I cannot compare.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2008-02-20 : 16:42:53
|
quote:
Originally posted by tkizer
Because Integration Services allows you to program. Using T-SQL and sqlcmd for complex transformations would not be easy.I personally don't use Integration Services as we don't currently have a need for it. I simply use bcp and then T-SQL to transform. But you wouldn't want to do that for complex stuff.Tara Kizerhttp://weblogs.sqlteam.com/tarad/
Complex stuff like what I wonder....The informatica bug has cropped again around here, and I don't think there isn't anything I (or you guys) can't do in T-SQLThe only thing is the connection to disparate source, which if I remember looking a SQL Profiler, is probably not a good thing eitherBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-02-21 : 05:33:20
|
| you might want to check out Rhino ETL: http://www.ayende.com/Blog/category/545.aspxit's an open source ETL made by Ayende Rahien (a dude that is a legend in xDD community) just because SSIS pissed him of immensly.looks very promising._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-02-21 : 06:19:55
|
| Where I am currently, they use SAS. It is better at data manipulation from files then SSIS and has helped me with a few strangely formatted files I have received.Like everything though, it has its Pros and Cons. |
|
|
|
|
What ETL Tool(s) does your company uses?