Oracle Information Integration, Migration, and Consolidation

The definitive book and eBook guide to Oracle Information Integration and Migration in a heterogeneous world
Preview in Mapt
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
Mapt Subscription
FREE
$29.99/m after trial
eBook
$23.10
RRP $32.99
Save 29%
Print + eBook
$54.99
RRP $54.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$23.10
$54.99
$29.99 p/m after trial
RRP $32.99
RRP $54.99
Subscription
eBook
Print + eBook
Start 30 Day Trial

Frequently bought together


Oracle Information Integration, Migration, and Consolidation Book Cover
Oracle Information Integration, Migration, and Consolidation
$ 32.99
$ 23.10
Professional Oracle Mobile Book Cover
Professional Oracle Mobile
$ 39.99
$ 28.00
Buy 2 for $35.00
Save $37.98
Add to Cart

Book Details

ISBN 139781849682206
Paperback332 pages

Book Description

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

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
Summary
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
Oracle-to-Oracle
Application integration
Products matrix summary
Products not covered
Summary
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
Summary
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
Summary
Chapter 5: Database Migration Challenges and Solutions
Database schema migration challenges
Database migration case studies
Summary
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
Summary
Chapter 7: Database-centric Data Integration
Oracle GoldenGate
Configuration overview
Oracle Database Gateways
Oracle Data Integrator
Data management case study
Summary
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
Summary
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
Summary

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

Authors

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
Summary
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
Oracle-to-Oracle
Application integration
Products matrix summary
Products not covered
Summary
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
Summary
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
Summary
Chapter 5: Database Migration Challenges and Solutions
Database schema migration challenges
Database migration case studies
Summary
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
Summary
Chapter 7: Database-centric Data Integration
Oracle GoldenGate
Configuration overview
Oracle Database Gateways
Oracle Data Integrator
Data management case study
Summary
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
Summary
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
Summary

Book Details

ISBN 139781849682206
Paperback332 pages
Read More

Read More Reviews

Recommended for You

Oracle Data Guard 11gR2 Administration : Beginner's Guide  Book Cover
Oracle Data Guard 11gR2 Administration : Beginner's Guide
$ 35.99
$ 25.20
Oracle E-Business Suite R12 Core Development and Extension Cookbook Book Cover
Oracle E-Business Suite R12 Core Development and Extension Cookbook
$ 35.99
$ 25.20
Oracle ADF Real World Developer's Guide  Book Cover
Oracle ADF Real World Developer's Guide
$ 35.99
$ 25.20
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook Book Cover
Oracle E-Business Suite R12 Integration and OA Framework Development and Extension Cookbook
$ 32.99
$ 23.10
Oracle Identity and Access Manager 11g for Administrators Book Cover
Oracle Identity and Access Manager 11g for Administrators
$ 35.99
$ 25.20
Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial Book Cover
Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial
$ 35.99
$ 25.20