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

On 6 Jul 2004 08:17:56 -0700, ulrich_at_ulrichandhelvas.com (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.

Why use web services? Simple scriptin will be much more robust

--
Sybrand Bakker, Senior Oracle DBA