fhs
Volume 12, Number 24 -- September 11, 2012

Oracle Completes DB2/400 Support in Data Replication Tool

Published: September 11, 2012

by Alex Woodie

Oracle last week unveiled GoldenGate 11g Release 2, a new release of its real time data integration tool, which is commonly used to load large amounts of data, often for business intelligence or disaster recovery purposes. The new release adds support for data capture from DB2/400, which may be useful for organizations looking to move data contained in their IBM i applications to other IBM i servers or other platforms. The product already could load data into DB2/400.

GoldenGate is a high speed data integration and replication tool that Oracle acquired in 2009. The tool is based on changed data capture (CDC) technology that keeps the freshest pieces of data flowing from a production database into a secondary database for the purposes of feeding data warehouses, operational reporting, continuous availability, or maintaining production systems in parallel during upgrades or migrations. The software uses a log-based data capture method that Oracle claims minimizes the impact on the source database, while maintaining integrity of the data and delivering sub-second latency across multiple platforms.

Soon after acquiring GoldenGate, Oracle released 11g in September 2010, which added support for DB2/400. However, that release only supported the loading of data into DB2/400 from other applications or databases; it couldn't use DB2/400 as a source of data. It would be nice to think that there's a big demand for moving data into DB2/400, but the reality is there is a greater demand for moving DB2/400 data to other databases, most often for analytic workloads. (The IBM i server is, wrongly, considered by many to be poor choice for BI and analytic workloads, but that is another story.)

Oracle remedied the lack of support for using DB2/400 as a source with GoldenGate 11g Release 2. Customers can now use the software to move the latest transactions recorded by their IBM i applications into their Windows- or Unix-based data warehouses, for instance. Or it could be used to enable real-time replication of data between two separate IBM i servers, for the purpose of DR preparedness, system upgrades, or migrations. (Two-way data replication gives Oracle the basic plumbing on which to build an IBM i high availability solution, but it seems doubtful that it wants to be in that business.)

GoldenGate 11g Release brings several other features, including support for delivering data into Postgres database; new data types supported in SQL Server, MySQL, and Sybase databases; support for multi-byte DDL in Teradata environments; better initial load performance in z/OS environments; a new "integrated" capture within the Oracle 11g database; and support for the capture and delivery of compressed objects within Oracle 11g and Oracle Exadata environments.

Other 11g Release 2 features include Federal Information Protection Standard (FIPS) support; multi-byte enhancements for supporting Asian operations; new automatic conflict detection and resolution capabilities; and the capability to manage the software through a plug-in for the Oracle Enterprise Manager.


RELATED STORY

Oracle Adds DB2/400 Support to GoldenGate Data Integration Tool



                     Post this story to del.icio.us
               Post this story to Digg
    Post this story to Slashdot


Sponsored By
NEW GENERATION SOFTWARE

Do you want a better understanding of IBM's
recent analytics software announcements?

Are you confused about IBM's support for
Query/400 and DB2 Web Query features?

Would you like help explaining what makes
IBM i ideal for BI?

Read the new White Paper:
BI for IBM i Customers.

Learn about IBM's business and analytics
strategy, DB2 Web Query, Cognos, Microsoft,
Open Source BI, and our alternative, NGS-IQ.

Call 800 824-1220. Visit www.ngsi.com


Editor: Alex Woodie
Contributing Editors: Dan Burger, Timothy Prickett Morgan
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

Sponsored Links

Databorough:  Discover legacy RPG, COBOL or SYNON assets with X-Analysis 9.7
ASNA:  ASNA Wings® brings the world of mobile devices to your RPG applications
Help/Systems:  2012 Solutions Summit. September 17-20 in Minneapolis, MN.


 

IT Jungle Store Top Book Picks

BACK IN STOCK: Easy Steps to Internet Programming for System i: List Price, $49.95

The iSeries Express Web Implementer's Guide: List Price, $49.95
The iSeries Pocket Database Guide: List Price, $59
The iSeries Pocket SQL Guide: List Price, $59
The iSeries Pocket WebFacing Primer: List Price, $39
Migrating to WebSphere Express for iSeries: List Price, $49
Getting Started with WebSphere Express for iSeries: List Price, $49
The All-Everything Operating System: List Price, $35
The Best Joomla! Tutorial Ever!: List Price, $19.95


 
The Four Hundred
Performance Choices For Power7+ Servers Could Be Complicated

Casualties Stack Up In The IBM i Job Wars

Gartner Concurs: Second Quarter Server Sales Stall

As I See It: Game Changer

Google's Nexus 7: A Viable Tablet For IBM i Users

Four Hundred Guru
Future Coding

Checking IBM i OS and PTF Level Status for Sarbanes-Oxley Documentation

Admin Alert: Two Useful PC5250 Parameters In IBM i Access For Windows 7.1

Four Hundred Monitor
Four Hundred Monitor's
Full iSeries Events Calendar

System i PTF Guide
September 8, 2012: Volume 14, Number 36

September 1, 2012: Volume 14, Number 35

August 25, 2012: Volume 14, Number 34

August 18, 2012: Volume 14, Number 33

August 11, 2012: Volume 14, Number 32

August 4, 2012: Volume 14, Number 31

July 28, 2012: Volume 14, Number 30

TPM at The Register
Intel rolls eyes at flaccid PC biz, cuts $1bn off expected sales

NEC, Egenera tag team on cloudy infrastructure freakage

US energy lab's pump-happy petaflopper goes green

IBM's z12 mainframe engine makes each clock count

Intel teaches Xeon Phi x86 coprocessor snappy new tricks

Supercomputing takes a slight pause in Q2

Fujitsu to embiggen iron bigtime with Sparc64-X

Oracle hurls Sparc T5 gladiators into big-iron arena

A second opinion on sucky second quarter server sales

IBM to double-stuff sockets with power-packed Power7+

Ethernet switch sales sizzle

Applied Micro's X-Gene server chip ARMed to the teeth


THIS ISSUE SPONSORED BY:

Databorough
New Generation Software
HiT Software
Computer Keyes
RJS Software Systems


Printer Friendly Version


TABLE OF CONTENTS
Attunity: Moving Big Data for Dollars

Oracle Completes DB2/400 Support in Data Replication Tool

New Mobile and Cloud Software from IBM is Really Neat, But Doesn't Run on IBM i

Tango/04 Distills IBM i Operations Knowledge into New Module

Kronos Goes Mobile with iSeries Central 6.2

News Briefs and Product Shorts:

SEQUEL Brings Parity to Web and Desktop Interfaces . . . Seacore Grows Business with VAI on IBM i . . . mrc Bolsters Web UI, Launches Cloud Program for ISVs . . . Maxava Goes HTML5 with maxView . . . Terrible's Casino Taps Agilysys for Inventory Management . . .

Four Hundred Stuff

BACK ISSUES




 
Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at http://www.itjungle.com/sub/subscribe.html.

Copyright © 1996-2012 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement