Re: Web Services w/Oracle and lots of data - practical?

1. for Oracle to Oracle - "Database Link" would by the most appropriate,
2. for Non-Oracle to Oracle - you can do it through text files, then Oracle "External Tables" or "SQL*Loader" would be the best, if you want to avoid text files then look at "Oracle Transparent Gateways"

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1089160035.921487_at_yasure>...
> Roy Zolnoski wrote:
>
> > I'm involved in a project where we are extracting data from multiple
> > source systems and placing in a data warehouse. The central
> > database/DW is Oracle 9i. The source systems are Oracle 8i and
> > possibly other databases (unknown at this point, it's still early).
> > I'd also like to prepare for non-Oracle databases.
> >
> > Data transfer would be once per day after an end of day process is run
> > in the source system. Each system would transfer 150,000+ records to
> > the DW each day. The records are from large, denormalized tables.
> > The average row length from one system is ~370, others might be
> > somewhat less or more.
> >
> > Are web services practical in this environment? Can web services be
> > used to transfer large amounts of data like this? Any horror or
> > success stories to share?
> >
> > Any help to this open ended request would be most appreciated.
>
> Can web services be used? Yes.
>
> Are they ever going to be competitive with other methods of loading
> such as SQL*Loader? Doubt it.
>
> Daniel Morgan
Received on Thu Jul 08 2004 - 13:40:46 CEST