TrustRadius: an HG Insights company

Oracle Data Integrator (ODI)

Score6.2 out of 10

126 Reviews and Ratings

What is Oracle Data Integrator (ODI)?

Oracle 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.

Categories & Use Cases

Top Performing Features

  • Connect to traditional data sources

    Ability to connect to traditional data sources like relational databases, flat files, XML files and packaged applications

    Category average: 8.7

  • Simple transformations

    Simple data transformations are calculations, data type conversions, aggregations and search and replace operations

    Category average: 8.1

  • Complex transformations

    Complex data transformations are data normalization, advanced data parsing, etc.

    Category average: 7.1

Areas for Improvement

  • Business rules and workflow

    Ability to define and manage business rules and workflows

    Category average: 8.2

  • Integration with MDM tools

    Integration with master data management tools to ensure data consistency across the organization

    Category average: 7.8

  • Collaboration

    Collaboration is enabled by a shared repository of project information and metadata

    Category average: 7.2

ODI Tool for Huge Data

Pros

  • The User Interface is pretty neat and clean which is very easy to use.
  • There are a lot of transformation options available to choose from.
  • The scalability and performance are top notch.

Cons

  • The cost part is bit high as compared to its peers.
  • Sometimes there is a lag and it gets hanged.
  • Real time data Integration cannot be handled.

Return on Investment

  • This has made our whole process much more efficient.
  • Customer service is positively impacted.
  • Business process has been improved tremendously.

Other Software Used

Snowflake, Google Cloud AI, Google Cloud IoT

What i think about Oracle Data Integrator

Pros

  • Extract, transform and load the data
  • Work well with large volume of data
  • Use with multiple sources

Cons

  • Bit difficult to use as compare to other tools
  • Sometime feels slowness while working

Return on Investment

  • It is bit costly as compare to other tools in same category.
  • If you have good technical experience in ODI then you can implement effective solution for problems

Alternatives Considered

MuleSoft Anypoint Platform and Alteryx Platform

Other Software Used

Alteryx Platform, Microsoft Power BI, Microsoft SQL Server

Oracle Data Integrator is great for any ETL use cases

Pros

  • High-volume, batch load ETL processes
  • Data transformations before data warehousing
  • Flexible big-data extractions

Cons

  • More easily used in other clouds/platforms
  • More features in UI
  • Updated flow of ETL processes in UI

Return on Investment

  • Cleaner data loaded into BI platform
  • Refined data inside data warehouse
  • High-quality reporting using dashboards after ETL from Oracle Data Integrator

Alternatives Considered

Trifacta

Other Software Used

Google Cloud Spanner, Google Cloud SQL, Google Cloud Storage

Oracle Data Integrator review

Pros

  • There are enough aggregate functions to design a Data Warehouse. In this way, summary tables can be created.
  • Works compatible with Oracle databases. By making ODBC connections, database connections are made more stable.

Cons

  • The end user interface of Oracle Data Integrator ETL can be made simpler and more convenient.
  • Oracle external database connections are time out after a certain period of time. Therefore, data transfers can be disrupted.

Return on Investment

  • I think it's a useful product to be able to make data warehouse and ETL designs. It is exceptionally compatible with Oracle databases.
  • I think the data transfer performance is adequate. With different scenarios, it is possible to increase data transfer performance with Oracle Data Integrator product.

Alternatives Considered

SQL Server Integration Services and Pentaho

Other Software Used

Microsoft SQL Server, Pentaho, PostgreSQL, Microsoft Power BI, MongoDB, Oracle Database 12c, Visual Studio IDE, NetBeans

Oracle Data Integrator enthusiast!

Pros

  • Complex transformations.
  • Compatibility with almost any knows valid source.
  • Suited for batch loading processes.

Cons

  • Small bugs related to Java.
  • The user interface is not intuitive.
  • The complexity of the tool makes difficult to find qualified people in the market.
  • Expensive.

Return on Investment

  • Because of its architecture, ODI requires fewer hardware resources (compared to other ETL tools on the market).
  • Expensive, but it's worth it.