Oracle data integrator targets increasingly in-depth BI

ODI is a data integration solution designed to help users free themselves from the time it takes to store a large amount of information on a variety of platforms and applications within the enterprise to do more meaningful things.

Oracle says integrated software allows companies to easily Process Business Intelligence, data warehouses, primary data management, business activity monitoring, application porting, and merging, and services-Oriented Architecture-related transactions.

ODI optimizes how Oracle databases, application servers, service-oriented architecture suites, and business activity monitoring software work. According to Oracle, the new version adds some features that allow users to support packaging applications from IBM, Microsoft, Netezza, Sybase, Teradata, and Trillium.

The software also allows users to build data warehouses that can be accessed and analyzed by the latest business intelligence kit. The executives of the company said that this feature is a major part of Oracle's plan to provide customers with "General and in-depth business intelligence, this means that the analysis capability can reach all applications and data sources within the enterprise.

However, some IT industry observers, such as Gerry Brown, a senior analyst at Bloor Research International at Towcester, believe that Business Intelligence does not need to be widely used.

"You can't say that everyone in a large enterprise should use business intelligence because they don't use it and they don't understand it," Brown told SearchDataManagement.com in an interview in February. He said that, as a substitute, Enterprise Performance Management software can monitor the performance of enterprises, which is truly widespread and in-depth.

Oracle-in nearly three years of buying spree, it increased its share in the business application market and squeezed sap ag-announcing its acquisition of Sunopsis in October.

With the release of the data integrator, Oracle has successfully implemented the commitment to integrate the product to the Fusion middleware platform, this platform can run all newly acquired and self-produced Oracle Applications.

"The Sunopsis tool and data integrator are currently fully Java-based, so we can really put it in Fusion middleware and perform deep integration within a few weeks, "said Jeff Pollock, Oracle senior director of Fusion middleware.

Key features: customers and prices

Oracle said that one of the most important features of ODI is the ELT (extraction, loading, conversion) technology-not to be confused with ETL (extraction, conversion, loading) technology, ETL is replaced by Oracle as the "previous generation ".

"In ELT, You can execute the conversion in the source or target system. You don't need an individual ETL server, "says Ashish Mohindroo, senior product director in charge of ODI. "You can perform the conversion first and then put the data in the target source ."

ELT technology can therefore provide higher performance and better support for third-party systems. It can also help reduce costs, Mohindroo said.

Pollock said that another key feature of the data integrator is its support for batch processing and Real-time Data Synchronization Through the Change Data Capture technology.

"What Change Data Capture does is let us monitor the log files of the downstream systems and databases to find the data that has changed," Pollock said. "When we see the changed data, we can now extract them from the local business activity monitoring tool as events and place them on the dashboard in turn ."

The executives said that by providing users with a series of pre-packaged code libraries (named the knowledge module), ODI reduces the cost of developing and maintaining the data integration roadmap, which can capture highly optimized sources and targets, because most databases and packaging applications have been optimized.

Oracle says the ODI currently available to customers includes Accenture, Netezza, Nielsen Media Research, Sabre-Holdings, Teradata, and Blue Cross Blue Shield (BCBS) in Massachusetts ).

BCBS is using ODI to select information from an IBM DB2-based data warehouse that contains 2.9 million TB of health care provider Information and claims to have members. In an Oracle speech, BCBS said that ODI helps users extract specific bytes of information from data warehouses, build data markets, and generate analysis to determine Sales Effectiveness and marketing, and other activities.

Oracle data integrator is typically sold at $10 thousand per database target CPU and $2000 per database source CPU.