Oracle Data Integrator: Product Overview and Insight
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 […]
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.
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.
Advertisement
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).
Advertisement
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.
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.
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.