Oracle Integration Release Meets Real Time Demands - InformationWeek
Software // Information Management
01:52 PM
Connect Directly

Oracle Integration Release Meets Real Time Demands

Acquired technologies are paired to speed big-data capture and transformation.

Oracle on Thursday formally introduced a data integration lineup capable of handling big-data loads in heterogeneous environments with real-time performance -- a combination that's increasingly in demand.

Oracle's new portfolio includes two key products: Oracle GoldenGate 11g, the new name for the products acquired along with GoldenGate last year, and Oracle Data Integrator 11g, the latest upgrade of technologies gained through the 2007 acquisition of Sunopsis. The products remain distinct, but the work behind the latest release involved more than simple rebranding.

The strength of the GoldenGate technology is change data capture (CDC) for real-time updating. In contrast to conventional batch-oriented techniques, and the latency they entail, CDC monitors changes in source systems at the log level and then instantly applies changes in data to target systems.

Real-time-oriented businesses such as telcos and online retailers are well represented among GoldenGate's customer base.

CDC technologies aren't typically used for heavy-duty data transformation work such as aggregation. But that's where Oracle Data Integration 11g (ODI) comes in. ODI is distinguished from conventional extract, transform and load tools in that it offers the alternative extract, load and transform (EL-T) approach.

ETL tools handle all three steps on separate data integration servers. The EL-T approach moves processing-intensive transformation into the target database, where it can be done much more quickly (in much the same way that in-database analytic processing offers performance advantages).

By combining CDC and EL-T, companies can keep pace with high-volume operational workloads while also handling required transformations in near real time. Oracle executives said it's not uncommon for companies seeking these technologies to process more than 50 gigabytes per hour.

Oracle GoldenGate 11g and Oracle Data Integration 11g still have separate runtime environments, but Oracle has made it easier to use the two together by making it possible to handle configuration and administration through the ODI user interface. Other vendors offer CDC and EL-T technologies, but Oracle says it's unique in integrating the two to meet emerging real-time demands.

Oracle has also added certified GoldenGate integrations with Oracle applications including Oracle E-Business Suite, PeopleSoft, Siebel and JD Edwards. But the company insists that the tool continues to support a wide range of third-party applications (including SAP) and competitive databases (including Microsoft SQL Server, IBM DB2, Teradata, Netezza and others).

Filling out the list of 11g upgrades now shipping, Oracle has also released Oracle Data Quality for Data Integrator 11g and Oracle Data Profiling 11g on Thursday. Jointly developed with Trillium, these two data quality products were introduced in 2007, and they fill out Oracle's data integration portfolio.

Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
2017 State of IT Report
In today's technology-driven world, "innovation" has become a basic expectation. IT leaders are tasked with making technical magic, improving customer experience, and boosting the bottom line -- yet often without any increase to the IT budget. How are organizations striking the balance between new initiatives and cost control? Download our report to learn about the biggest challenges and how savvy IT executives are overcoming them.
Twitter Feed
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll