Wednesday, December 4, 2024

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

Subscribe to Data Insider

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

Similar articles

Get the Free Newsletter!

Subscribe to Data Insider for top news, trends & analysis

Latest Articles