Oracle Data Integrator
From: Marián Bednár <marian.bednar_at_gmail.com>
Date: Fri, 17 Jan 2020 14:08:55 +0100
Message-ID: <CAM2K34Fodh_KG-wB6kRbF6uhfHwfnys8JKTDy3R_Oa166nOUMQ_at_mail.gmail.com>
Hi all,
Date: Fri, 17 Jan 2020 14:08:55 +0100
Message-ID: <CAM2K34Fodh_KG-wB6kRbF6uhfHwfnys8JKTDy3R_Oa166nOUMQ_at_mail.gmail.com>
Hi all,
we are planning to build new DWH from scratch. Source databases are mostly
Oracle and new DWH databases will be Oracle too. Datamarts could be also MS
SQL databases.
And we have dilemma in choosing ETL tool. We have two options Oracle ODI or
MS SSIS (Cognos or Informatica is not the option).
ODI is robust Oracle solution suitable for Oracle databases, but we don't
have ODI people and licenses are not cheap.
MS SSIS - we have enterprise licenses and some experiences with it, but is
it suitable to use it in "oracle db" world?
Also we have some PL/SQL people.
Another question is, if ODI is still (will be) in standard development from
longer perspective?
I appreciate your experiences, insights, recommendations...
Thanks.
Marian
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 17 2020 - 14:08:55 CET