Book Image

Oracle Information Integration, Migration, and Consolidation

Book Image

Oracle Information Integration, Migration, and Consolidation

Overview of this book

The book covers data migration, data consolidation, and data integration, the three scenarios that are typically part of the information integration life cycle. Organizations typically find themselves migrating data to Oracle and either later, or at the same time, consolidating multiple database instances into a single global instance for a department, or even an entire company. The business savings and technical benefits of data consolidation cannot be overlooked, and this book will help you to use Oracle's technology to achieve these goals. This highly practical and business-applicable book will teach you to be successful with the latest Oracle data and application integration, migration, information life-cycle management, and consolidation products and technologies.In this book, you will gain hands-on advice about data consolidation, integration, and migration using tools and best practices. Along the way you will leverage products like Oracle Data Integrator, Oracle GoldenGate, and SQL Developer, as well as Data Hubs and 11gR2 Database. The book covers everything from the early background of information integration and the impact of SOA, to products like Oracle GoldenGate and Oracle Data Integrator. By the end you'll have a clear idea of where information and application integration is headed and how to plan your own projects.
Table of Contents (17 chapters)
Oracle Information Integration, Migration, and Consolidation
Credits
About The Author
About the Contributing Authors
About the Reviewers
www.PacktPub.com
Preface

About the Reviewers

Peter C. Boyd-Bowman is a Technical Manager and Consultant with the Oracle Corporation. He has over 30 years of software engineering and database management experience, including 12 years of focused interest in data warehousing and business intelligence. Capitalizing on his extensive background in Oracle database technologies dating back to 1985, he has spent recent years specializing in data migration. After many successful project implementations using Oracle Warehouse Builder and shortly after Oracle's acquisition of the Sunopsis Corporation, he switched his area of focus over to Oracle's flagship ETL product: Oracle Data Integrator. He holds a BS degree in Industrial Management and Computer Science from Purdue University and currently resides in North Carolina.

Martin A. Kendall has been working with IT systems since the mid 1980s. He has a deep understanding of application infrastructure, system engineering, and database architecture. He specializes in Oracle RAC and Oracle Identity Management solutions, along with object-oriented software engineering through the use of the Unified Process.

Martin consults through two distinct organizations to deliver Oracle integration services through sysnetica.com and to provide private cloud infrastructure adoption consultancy through dicedcloud.com.

Asif Momen has been working with Oracle technologies for over 12 years and has expertise in performance tuning and high availability. He has a Master's degree in Software Systems from Birla Institute of Technology and Science (BITS), Pilani.

He is an Oracle ACE and is OCP certified DBA, Forms Developer, and RAC Expert. He is a speaker at Oracle OpenWorld and All India Oracle User Group (AIOUG). In addition, he is the Editor of Oracle Connect — the quarterly publication of AIOUG. His particular interests are database tuning, Oracle RAC, Oracle Data Guard, and backup and recovery.

Asif posts his ideas and opinions on The Momen Blog (http://momendba.blogspot.com). He can be reached at .

Ronald Rood is an innovating Oracle DBA, an ACE with over 20 years of IT experience. He has built and managed cluster databases on about each and every platform that Oracle ever supported from the famous OPS databases in version 7, until the latest RAC releases, currently being 11g. Ronald is constantly looking for ways to get the most value out of the database to make investment for his customers even more valuable. He knows how to the handle the power of the rich Unix environment very well, making him a first class trouble-shooter and solution architect. Next to the spoken languages like Dutch, English, German, and French, he also writes fluently in many scripting languages.

Currently, he is a principal consultant working for Ciber (CBR) in The Netherlands, where he cooperates in many complex projects for large companies where downtime is not an option. Ciber CBR is an Oracle Platinum Partner and committed to the limit.

He can often be found replying in the Oracle forums where he is an active member, writes his own blog (http://ronr.blogspot.com) called From errors we learn, and writes for various Oracle-related magazines. He is also the author of Packt Publishing's Mastering Oracle Scheduler in Oracle 11g Databases, where he fills the gap between the Oracle documentation and the customer questions. As well as reviewing this book, he was also part of the technical reviewing team for Packt Publishing's Oracle 11g R1/R2 Real Application Clusters Essentials.

Ronald has lots of certifications, among them:

  • Oracle Certified Master

  • Oracle RAC ACE

  • Oracle Certified Professional

  • Oracle Database 11g Tuning Specialist

  • Oracle Database 11g Data Warehouse Certified Implementation Specialist

Ronald fills his time with Oracle, his family, sky-diving, radio controlled model airplane flying, running a scouting group, and having a lot of fun.

His quote: "A problem is merely a challenge that might take a little time so solve."