Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ETL

Re: ETL

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 13 Sep 2007 09:05:08 -0700
Message-ID: <1189699500.258157@bubbleator.drizzle.com>


saifmomin21_at_gmail.com wrote:
> There are three different systems (a Mainframe, a C++ application and
> a VB application) connected to each other through Application
> Integration (AI) layer (CORBA + MOM). Database of two of the systems
> i.e., C++ application and VB application must be in sync with each
> other. This synchronisation of two databases is done by a PROLOG based
> application.
>
> Our company is moving to HP NGAS servers. And these new servers
> probably would not support this PROLOG application. So they are
> planning to retire this existing PROLOG application and replace it
> with some other suitable solution. There are two possible solutions
> they are considering -
>
> 1) Replace the existing PROLOG application with a new C++ or Java
> based application.
> 2) Replace the existing PROLOG application with ETL provided by ORACLE
> Warehouse Builder.
>
> Could you please let me know which solution is more feasible. And if
> we choose ETL, how does it fit into the architecture.

Use Warehouse Builder: Why reinvent the wheel.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Sep 13 2007 - 11:05:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US