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
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.
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).
ODI deploys on-premises and requires the deployment of server software and agents.
The Autonomous Integration Cloud is cloud-based.
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.
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.
- Rich ETL for Oracle databases
- Integrates with other Oracle software
- Native big data support
- Fast performance
- Low total cost of ownership
Support and Services:
Training, support and professional services are available.
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|
|Autonomous Integration Cloud: cloud|
|Operating System||Linux, Windows|
|Storage||1 GB (standalone) 2.5 GB (enterprise)|
|Connectors||Databases, Hadoop, ERPs, CRMs, B2B systems, flat files, XML, JSON, LDAP, JDBC, ODBC|
|Design and Development Environment||ODI Studio (graphical interface)|
|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|