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

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 Wed Jul 07 2004 - 02:27:03 CEST