Vidya Bala's Blog

Search My Blog

Add RSS Feed

Friday, November 10, 2006

what’s up with ETL Tools……………….

Over the last few years I have worked on quite a few ETL Projects. Starting with Sagent in 2000 to Informatica and now with Oracle Warehouse Builder.

With Warehouse Builder I can pretty much download it on technet setup a quick demo for users to demonstrate how this can be used as an ETL tool and even let them try it before we can get the entire Sales force involved for purchase etc ( I would like to get them out of the habit of doing major migrations only with PL/SQL code and maintenance becomes a nightmare)
I have not seen a single ETL tool apart from warehouse builder that I can download and setup a quick demo for, for all other vendor products I will have to contact the vendor setup a sales call , demo etc etc. We have the skills in-house and wish we could get our hands on these products, download it and evaluate them ourselves …………….

2 Comments:

  • Yes, unfortunately Oracle are unusual in the industry in giving out full versions of their tools for evaluation. I think it pays off for them in that it puts OWB, and the database, in so many hands.

    Trying to get evaluation copies of other tools (BO, Cognos, Informatica etc) is very hard, although of course there's a bundled version of Informatica within the Siebel Analytics download you can get from http://edelivery.oracle.com. I know it's restricted in terms of how you can legally use it (only to populate the warehouse used for Siebel's BI apps) but I expect it'll still actually work the same way as the regular version. Let me know if you get a chance to download and play with it.

    By Blogger Mark, at 6:02 AM  

  • You can also download and use Microsoft SSIS for ETL. For the vendors with larger and more complex tools like Informatica and IBM they really only give out evaluation versions to partners (who generate sales) and potential customers (who make sales). So they really focus on giving out copies to revenue generators and not your average developer.

    By Blogger Vincent ITToolbox blogger, at 3:37 PM  

Post a Comment

<< Home