PacktLib: Oracle Information Integration, Migration, and Consolidation

Oracle Information Integration, Migration, and Consolidation

Credits

About The Author

About the Contributing Authors

About the Reviewers

www.PacktPub.com

Preface

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

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

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

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

Database Migration Challenges and Solutions

Database schema migration challenges

Database migration case studies

Summary

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

Database-centric Data Integration

Oracle GoldenGate

Configuration overview

Oracle Database Gateways

Oracle Data Integrator

Data management case study

Summary

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

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

Appendix

Appendix

Appendix

Appendix

Appendix

Appendix

Appendix

Appendix

Appendix