Oracle Integration Release Meets Real Time Demands - InformationWeek
Software // Information Management
01:52 PM
Connect Directly
Threat Intelligence Overload?
Aug 23, 2017
A wide range of threat intelligence feeds and services have cropped up keep IT organizations up to ...Read More>>

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
IT Strategies to Conquer the Cloud
Chances are your organization is adopting cloud computing in one way or another -- or in multiple ways. Understanding the skills you need and how cloud affects IT operations and networking will help you adapt.
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