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

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 - 13:43:21 CDT