TrustRadius: an HG Insights company

Oracle Data Integrator (ODI) vs. Oracle Warehouse Builder

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Oracle Data Integrator (ODI)

    Score6.2 out of 10
    N/AOracle Data Integrator is an ELT data integrator designed with interoperability other Oracle programs. The program focuses on a high-performance capacity to support Big Data use within Oracle.N/A

    Oracle Warehouse Builder

    Score8.7 out of 10
    N/AOracle Warehouse Builder (OWB) is a data-warehousing centered data integration solution, from Oracle. It offers basic ETL functionality for building a simple data warehouse, as well as advanced ETL functionality supporting enterprise data integration projects, along with connectivity for Oracle and SAP applications.N/A
    Pricing
    Oracle Data Integrator (ODI)Oracle Warehouse Builder
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Oracle Data Integrator (ODI)Oracle Warehouse Builder
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details
    More Pricing Information
    Community Pulse
    Oracle Data Integrator (ODI)Oracle Warehouse Builder
    Considered Both Products
    Oracle
    Chose Oracle Data Integrator (ODI)
    Oracle's own ETL tool was Oracle Warehouse Builder, initially. When Oracle built the Oracle Business Intelligence Applications Suite, Oracle is in need of a strong ETL. As Oracle Warehouse Builder is not a strong ETL that customers prefer and as already Informatica captured …
    Incentivized
    Chose Oracle Data Integrator (ODI)
    ODI is the naturel successor of OWB, adopting the same EL-T approach but supporting a lot more technologies as source and target. The overall product is much more stable and not tied to the Oracle Database.
    Unlike Informatica, ODI generates all the code in the native underlying …
    Incentivized
    Chose Oracle Data Integrator (ODI)
    Because of variety of my projects that I involved, I used nearly all the world wide known tools within data warehouse environment.
    • Data Modeling Tools : Sybase Power Designer, SQL Developer Data Modeler, ERwin Data Modeler.
    Incentivized
    Oracle
    Chose Oracle Warehouse Builder
    I think that Oracle Warehouse Builder is easier to use the Oracle Data Integrator (ODI). The connections in Oracle Warehouse Builder (OWB) are easier to understand when troubleshooting. Anything that makes troubleshooting easier gets higher marks in my book. ODI wins in the …
    Incentivized
    Chose Oracle Warehouse Builder
    Depending on investment, I would prefer Oracle Data Integrator, since it complies with all versions of all types of databases including Big Data, Hadoop and NoSQL environment as well as the cloud and is the strategic heterogenous data integration product of Oracle, as it is …
    Incentivized
    Key User Insights
    Would buy again
    No answers on this topic
    No answers on this topic
    Delivers good value for the price
    No answers on this topic
    No answers on this topic
    Happy with the feature set
    No answers on this topic
    No answers on this topic
    Lived up to sales and marketing promises
    No answers on this topic
    No answers on this topic
    Implementation went as expected
    No answers on this topic
    No answers on this topic
    Features
    Oracle Data Integrator (ODI)Oracle Warehouse Builder
    Data Source Connection
    Comparison of Data Source Connection features of Oracle Data Integrator (ODI) and Oracle Warehouse Builder
    Feature
    Oracle Data Integrator (ODI)
    9.6
    11 Ratings
    Oracle Warehouse Builder
    9.5
    5 Ratings
    Connect to traditional data sources9.911 Ratings10.05 Ratings
    Connecto to Big Data and NoSQL9.39 Ratings9.02 Ratings
    Data Transformations
    Comparison of Data Transformations features of Oracle Data Integrator (ODI) and Oracle Warehouse Builder
    Feature
    Oracle Data Integrator (ODI)
    9.9
    11 Ratings
    Oracle Warehouse Builder
    10.0
    5 Ratings
    Simple transformations9.911 Ratings10.05 Ratings
    Complex transformations9.911 Ratings10.04 Ratings
    Data Modeling
    Comparison of Data Modeling features of Oracle Data Integrator (ODI) and Oracle Warehouse Builder
    Feature
    Oracle Data Integrator (ODI)
    9.2
    11 Ratings
    Oracle Warehouse Builder
    8.2
    5 Ratings
    Data model creation9.310 Ratings10.04 Ratings
    Metadata management9.510 Ratings6.04 Ratings
    Business rules and workflow9.111 Ratings9.04 Ratings
    Collaboration8.510 Ratings8.94 Ratings
    Testing and debugging9.311 Ratings7.04 Ratings
    Data Governance
    Comparison of Data Governance features of Oracle Data Integrator (ODI) and Oracle Warehouse Builder
    Feature
    Oracle Data Integrator (ODI)
    9.1
    9 Ratings
    Oracle Warehouse Builder
    8.0
    3 Ratings
    Integration with data quality tools9.59 Ratings8.03 Ratings
    Integration with MDM tools8.77 Ratings8.02 Ratings
    User Ratings
    Oracle Data Integrator (ODI)Oracle Warehouse Builder
    Likelihood to Recommend
    8.0
    (29 ratings)
    8.0
    (5 ratings)
    Likelihood to Renew
    10.0
    (4 ratings)
    -
    (0 ratings)
    Implementation Rating
    7.0
    (1 ratings)
    -
    (0 ratings)