Re: ETL tool - insight on Ascential DataStage?

In my opinion, OWB does that and a whole lot more.

OWB is designed to start at both warehouse and source modelling (vs 2 sessions in ERWin), then allow mapping between sources and warehouse, define exrtact & load patterns, define translations and transformation (including staged/synchronized tranform). A form of versioning and real time testing is also supported.

Together with Oracle gateways, OWB allows access to a large variety of data sources.

OWB includes the runtime - event management, scheduleing, monitoring - which takes the ETL design and actually invokes and monitors it, complete with success/fail alerting.

This is just an overview of some of the more basic capabilities.

That said, I strongly encourage anyone who needs to design, manage & maintain warehouses to look at it very seriously.

/Hans

Matt Houseman wrote:

> What's the opinion on OWB compared to say ERWin and Data Junction?
>
> Matt
>
> "Hans Forbrich" <forbrich_at_telusplanet.net> wrote in message
> news:3B33CA31.C7E78101_at_telusplanet.net...
> > Sorry, don't know that one. Have you looked at Oracle's Oracle Warehouse
 Builder?
> > (Check http://oraclestore.oracle.com > Database [tab] > Tools [scroll] >
 Internet
> > Developer Suite
> >
> > A lot of the related info you need, from OWB perspective is at technet or
> > oraclestore.
> >
> > HTH
> > /Hans
> >
> >
> >
> > Tagliere_at_aol.dontwantspam.com wrote:
> >
> > > I am currently doing some research on different vendors of ETL tools.
> > > I have solid information on Informatica's PowerMart and wanted to know
 how
> > > Ascential DataStage measured up. Can anyone provide me with some
 insights
> > > based on the following metrics:
> > >
> > > Integration with Source Environment
> > > Integration with Target Environment
> > > MetaData (exchange, protection)
> > > Integration with Operational Environment
> > > Availability of Transformation Logic
> > > Development Environment
> > > Performance and Scalability
> > > Productivity and Stability - learning curve, availability of support
> > > Vendor Track Record
> > > Cost
> > >
> > > ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the
 eb -----
> > > http://newsone.net/ -- Free reading and anonymous posting to 60,000+
 groups
> > > NewsOne.Net prohibits users from posting spam. If this or other
 posts
> > > made through NewsOne.Net violate posting guidelines, email
 abuse_at_newsone.net
> >
Received on Sun Jul 22 2001 - 08:53:26 CEST