Datamation Logo

Oracle Data Integrator: Product Overview and Insight

September 7, 2018
Oracle Data Integrator: Product Overview and Insight
Datamation content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More.

Bottom Line:

Organizations that use Oracle database software or other enterprise software will likely want to consider the Oracle Data Integrator. It integrates easily with other Oracle solutions and promises low total cost of ownership. It doesn’t have as many capabilities as some other data integration platforms, but those features are available with other Oracle products.

See Oracle Data Integrator user reviews.

Jump to: Oracle Data Integrator Features Table

Company Description:

Oracle boasts 430,000 customers in 175 countries. Founded in 1977 by Larry Ellison, Bob Miner and Ed Oates, the company has its headquarters in Redwood Shores, California. It has more than 138,000 employees, and in fiscal 2018, it reported $39.83 billion in revenue and $3.82 billion in net income. It is traded on the New York Stock Exchange under the symbol ORCL, and it is a component of the S&P 500. It is number 82 on the Fortune 500 list.

Oracle’s best-known products include its database, middleware and other enterprise software. It has also made a strong push into cloud computing, and it continues to sell hardware for enterprise data centers.

Product Description:

Oracle offers two different data integration products. Oracle Data Integrator (ODI) is its on-premise software. It’s a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services. It comes in two flavors: Enterprise Edition or ODI for Big Data.

It also has a cloud-based solution called the Oracle Data Integration Platform Cloud. It includes pre-built connectors for software as a service (SaaS) applications and promises fast performance from a browser-based interface.

Gartner placed Oracle in the Leaders quadrant on both the Magic Quadrant for Data Integration Tools and the Magic Quadrant for integration platform as a service (iPaaS).

Features:

Deployment:

ODI deploys on-premises and requires the deployment of server software and agents.

The Autonomous Integration Cloud is cloud-based.

Licensing:

Proprietary

System Requirements:

ODI runs on Linux of Windows and requires at least a 2 GHz processor, 3 GB memory, and 1GB storage for a standalone installation and 2.5 GB storage for an enterprise installation.

Connectors

Out-of-the-box integration with databases, Hadoop, ERPs, CRMs, B2B systems, flat files, XML, JSON, LDAP, JDBC and ODBC. Java must also be installed.

Design and Development Environment:

ODI includes a graphical development environment called ODI Studio.

Key Capabilities

  • Rich ETL for Oracle databases
  • Integrates with other Oracle software
  • Native big data support
  • Fast performance
  • Low total cost of ownership
  • Java-based

Support and Services:

Training, support and professional services are available.

Pricing:

Companies can license ODI on a “named user plus” basis or per processor. It costs $900 per named user plus $198 for a software update license and support. Or enterprises can pay $30,000 per processor plus $6,400 for a software update license and support.

Oracle Autonomous Integration Cloud — Standard costs $900 per month on a pay-as-you-go plan or $600 per month on a monthly flex plan.

Oracle Data Integrator Features Table

Features Oracle Data Integrator
Deployment ODI: on-premise
Autonomous Integration Cloud: cloud
System Requirements
Operating System Linux, Windows
Processor 2 GHz
RAM 3 GB
Storage 1 GB (standalone) 2.5 GB (enterprise)
Software Java
Connectors Databases, Hadoop, ERPs, CRMs, B2B systems, flat files, XML, JSON, LDAP, JDBC, ODBC
Design and Development Environment ODI Studio (graphical interface)
Key Capabilities
ELT Yes
ETL Yes
CDC No (available through other software)
Data Quality No (available through other software)
Data Governance No (available through other software)
Others Native big data support
Support and Services Training, support, professional services
Gartner Magic Quadrant Rating Leader
Features Oracle Data Integrator
Deployment ODI: on-premise
Autonomous Integration Cloud: cloud
System Requirements
Operating System Linux, Windows
Processor 2 GHz
RAM 3 GB
Storage 1 GB (standalone) 2.5 GB (enterprise)
Software Java
Connectors Databases, Hadoop, ERPs, CRMs, B2B systems, flat files, XML, JSON, LDAP, JDBC, ODBC
Design and Development Environment ODI Studio (graphical interface)
Key Capabilities
ELT Yes
ETL Yes
CDC No (available through other software)
Data Quality No (available through other software)
Data Governance No (available through other software)
Others Native big data support
Support and Services Training, support, professional services
Gartner Magic Quadrant Rating Leader
Price ODI: approximately $36,400 for a one processor deployment
Cloud: $600 per month and up
  SEE ALL
BIG DATA ARTICLES
 

Subscribe to Data Insider

Learn the latest news and best practices about data science, big data analytics, artificial intelligence, data security, and more.

Datamation Logo

Datamation is the leading industry resource for B2B data professionals and technology buyers. Datamation's focus is on providing insight into the latest trends and innovation in AI, data security, big data, and more, along with in-depth product recommendations and comparisons. More than 1.7M users gain insight and guidance from Datamation every year.

Advertisers

Advertise with TechnologyAdvice on Datamation and our other data and technology-focused platforms.

Advertise with Us

Our Brands


Privacy Policy Terms & Conditions About Contact Advertise California - Do Not Sell My Information

Property of TechnologyAdvice.
© 2025 TechnologyAdvice. All Rights Reserved

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.