Re: ETL (Extraction/Transformation/Loading) tools for DW???

We also did an extensive evaluation and selected Ascential's Data Stage ( Informatica then) for our , mostly Oracle, shop...It beat out PowerMart by a only a few points so either would be a good choice..

"Andre van Winssen" <awinssen_at_xs4all.nl> wrote:

>Hi,
>I used Oracle Warehouse Builder (up to version 2.1.1) quite a few times
>with good results. It can work with Oracle Enterprise Manager and
>Oracle Workflow. The code generator provides you with DDL, PLSQL
>and TCL scripts.
>The HSODBC framework that is part of 8i RDBMS can help you
>with foreign ODBC data sources.
>
>I admit, I'm an Oracle fan, but that's because I used to work for Oracle
>for almost 6 years and enjoyed it.
>
>Regards,
>Andre van Winssen
>
>
>
>"Robert" <rwolffman_at_hotmail.com> schreef in bericht
>news:tdrjp2a2p3vb44_at_corp.supernews.com...
>> We are at the tail end of an ETL evaluation. Top two market leaders are
>> Ascential's DataStage and Informatica's PowerMart products. Let me know
>> if you want more information.
>>
>> David Sisk wrote:
>> >
>> >
>> > We're in need of one or more ETL tools. (We've built our own at a
 previous
>> > product company, but with this service organization, buying a tool makes
>> > more sense.) The sources include Oracle8.1, SQLServer7, and probably
 flat
>> > files and/or ODBC-compliant formats, the target is Oracle8.1. There are
>> > quite a few listed on www.dwinfocenter.org. Has anyone used any of
 these or
>> > other ETL tools? Any good or bad experiences? Any tools you'd strongly
>> > recommend?
>> >
>> > Please post or email!
>> >
>> > Regards,
>> > Dave
>> >
>> >
>> >
>>
>>
>> --
>> Posted via CNET Help.com
>> http://www.help.com/
>
  Received on Thu Apr 19 2001 - 14:16:06 CDT