Free Sample
+ Collection
Code Files

Oracle Information Integration, Migration, and Consolidation

Jason Williamson, Tom Laszewski, Prakash Nauduri

The definitive book and eBook guide to Oracle Information Integration and Migration in a heterogeneous world
RRP $32.99
RRP $54.99
Print + eBook

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781849682206
Paperback332 pages

About This Book

  • Learn about integration practices that many IT professionals are not familiar with
  • Evaluate and implement numerous tools like Oracle SOA Suite and Oracle GoldenGate
  • Get to grips with the past, present, and future of Oracle Integration practices
  • Ultimately meet your own business requirements with Oracle Information and application integration products

Who This Book Is For

If you are a DBA, application or data architect, or data integration specialist who is running an Oracle database or middleware and you want to learn about the latest on Oracle's information integration platform, then this book is for you.

You can also benefit from this book if you are an application developer or technical and project lead with a focus on master data management, data warehousing, and data consolidation.

You should have working experience with Oracle Database, data integration, consolidation, and migration, as well as some familiarity with integration middleware products and information service buses.

Table of Contents

Chapter 1: Getting Started with Information Integration
Why consider information integration?
Business challenges in data integration and migration
Technical challenges of information integration
General approaches to information integration and migration
Integration and SOA, bringing it together
The real world: studies in integration
Chapter 2: Oracle Tools and Products
Database migration products and tools
Physical federation products
Virtual federation products
Data services
Data consolidation
Data grid
Information Lifecycle Management
Application integration
Products matrix summary
Products not covered
Chapter 3: Application and Data Integration Case Study
What is the POV?
Software and hardware requirements
Original architecture — nightly batch process
Functional specifications
Technical specifications
Assumptions, out of scope, and success criteria
Technical implementation details
Actual level of effort and outcome
Challenges and lessons learned
Cultural change in technology organizations
Next steps
Chapter 4: Oracle Database Migrations
Database migration scenarios
Using Oracle SQL Developer Version 3.0 for migrations to Oracle
Migration process using SQL Developer
Selection of the database connection for the repository
Enabling a factory approach to database migrations using SQL Developer
Data migration using Oracle SQL*Loader/External tables
Impact of database migrations on applications
Chapter 5: Database Migration Challenges and Solutions
Database schema migration challenges
Database migration case studies
Chapter 6: Data Consolidation and Management
What is enterprise data?
Oracle Master Data Management
Oracle RAC
Data grids using Oracle caching
Oracle as a service
Information Lifecycle Management
Oracle Exadata
Data management at IHOP, a case study
Chapter 7: Database-centric Data Integration
Oracle GoldenGate
Configuration overview
Oracle Database Gateways
Oracle Data Integrator
Data management case study
Chapter 8: Application and Process Integration
History of application integration
History of Oracle integration products
Oracle commercial off-the-shelf (COTS) application integration history
Oracle application and process integration software stack
Oracle Business Process Management
Oracle SOA Suite integration best practices
Oracle success stories
Chapter 9: Information Lifecycle Management for Transactional Applications
Data growth challenges
How enterprises try to solve data growth issues
What is Information Lifecycle Management?
What benefits can ILM offer?
Start with Application Portfolio Management
Application Retirement solution from Solix Technologies and Oracle partner

What You Will Learn

  • Get to grips with all that Oracle has to offer for information integration, migration, consolidation, and information life cycle management
  • Gain insight into migration tools and practices that are not well documented or understood even by many Oracle architects
  • Take a deep dive into how information integration and data migration are achieved in a complete and robust Oracle environment
  • Evaluate which Oracle products to implement to meet your company's unique technical requirements
  • Migrate data to Oracle in the most cost-effective, high performance and efficient manner
  • Learn from real-world case studies to help you define your own information and application integration solutions
  • Understand how Oracle's latest combined hardware and software platforms can be used not only to consolidate data, but as an information service bus solution 'in a box'
  • Tackle a myriad of tools like Oracle SOA Suite, Oracle Data Integrator, Oracle Golden Gate, and many more
  • Absorb the facts surrounding Oracle's strategic offering, Application Integration Architecture (AIA)
  • Understand the past, present, and future of Oracle Application Integration
  • Utilize an Oracle and a partner's product offerings to manage your large volumes of rarely accessed, but mission-critical information
  • Master an Oracle Commercial Off-The-Shelf (COTS) application

In Detail

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.


Read More