Oracle Information Integration, Migration, and Consolidation电子书

Oracle Information Integration, Migration, and Consolidation

Table of Contents

Oracle Information Integration, Migration, and Consolidation

Credits

About The Author

About the Contributing Authors

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

Who this book is written for

Conventions

Reader feedback

Customer support

Errata

Piracy

Questions

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

Data integration

Data migration

Architectures: federated versus shared

Data sharing integration

Considerations when choosing an integration approach

Integration and SOA, bringing it together

Architected for the Internet

Scalability

Availability

Greater software options

On-demand reporting

Security

Overcoming barriers to change

Custom integration applications and utilities

Custom workflow

The real world: studies in integration

Banking case

Education case

High technology case

Summary

2. Oracle Tools and Products

Database migration products and tools

SQL Loader

Oracle external tables

Oracle Warehouse Builder

SQL Developer Migration Workbench

Oracle Data Integrator

Oracle Enterprise Manager tuning and diagnostic packs

Physical federation products

Oracle Data Integrator

Oracle GoldenGate

Oracle CDC adapters

Oracle Master Data Management

Oracle Data Quality and Profiling

Virtual federation products

Oracle Gateways and Heterogeneous Services

Oracle Business Intelligence Suite

Oracle SOA adapters

Oracle Web Center and Portal

Oracle Business Activity Monitoring

Data services

Oracle Data Integration Suite

Data consolidation

Oracle Exadata

Data grid

Oracle Coherence

Oracle TimesTen

Oracle Exalogic

Information Lifecycle Management

Oracle Information Lifecycle Management

Oracle-to-Oracle

Oracle Streams

Oracle Data Pump

Oracle XStream

Application integration

Oracle SOA Suite

Oracle Advanced Queuing

Oracle Application Information Architecture

Products matrix summary

Products not covered

Summary

3. Application and Data Integration Case Study

What is the POV?

Solving a business problem

Estimated level of effort

Software and hardware requirements

Software

Hardware and network

Original architecture — nightly batch process

Batch cycle diagram — technical architecture

Functional specifications

Functional design diagram

Technical specifications

Technical specifications diagram

Assumptions, out of scope, and success criteria

Assumptions

Out of scope

Success criteria

Technical implementation details

Reading from the Oracle Database

Writing to flat files

Executing the z/OS COBOL module

Reading from VSAM files

Writing to IBM MQSeries

BPEL process

Security

Actual level of effort and outcome

Challenges and lessons learned

Cultural change in technology organizations

Next steps

Summary

4. Oracle Database Migrations

Database migration scenarios

Migrating an Oracle database from one platform to another

Migrating relational databases to Oracle

Using Oracle SQL Developer Version 3.0 for migrations to Oracle

Prerequisites for using SQL Developer

Creating a migration repository

JDBC Drivers setup

Creating a connection for a privileged database user in Oracle using SQL Developer

Creating a directory for a migration project

Migration process using SQL Developer

Migration steps in SQL Developer

Selection of the database connection for the repository

Project creation

Gathering source database metadata

Online capture

Offline mode

Convert the captured database model to an Oracle model

Target Oracle schema generation

Data migration

Enabling a factory approach to database migrations using SQL Developer

Data migration using Oracle SQL*Loader/External tables

Using Oracle SQL*Loader

Using Oracle External Table

Using Oracle Data Integrator (ODI) for data migration

Production rollout using Oracle GoldenGate

Impact of database migrations on applications

Summary

5. Database Migration Challenges and Solutions

Database schema migration challenges

Database object naming/definition issues

Use of special characters in object names

Use of reserved words in object names and their definitions

Use of case-sensitive object names

Length of object names

Data type conversion issues

Numeric data

Identity columns

Date/timestamp data

User-defined data types

Database feature mapping

Clustered indexes

Database schema layout

Empty strings and NULL value handling

Data case-sensitivity

EBCDIC/ASCII conversions

Globalization

Database migration case studies

Case Study #1: DB2/400 migration to Oracle using Oracle DRDA Gateway for DB2

Case Study #2: Sybase migration to Oracle

Case Study #3: Mainframe data migration/archiving from various databases such as DB2, IDMS, and VSAM

Summary

6. Data Consolidation and Management

What is enterprise data?

Transactional data

Analytical data

Master data

Enterprise data hub

Oracle Master Data Management

Oracle Customer Hub

Oracle Product Hub

Oracle Supplier Hub

Oracle Supplier Hub capabilities

Oracle Site Hub

Oracle RAC

Data grids using Oracle caching

Database-centric — TimesTen

Application-centric — Coherence

Oracle as a service

Reasons to consider Consolidation

Information Lifecycle Management

Active data archiving

Passive data archiving

Oracle Exadata

Data management at IHOP, a case study

Summary

7. Database-centric Data Integration

Oracle GoldenGate

Configuring GoldenGate for IBM DB2 to Oracle data replication

Prerequisites

Configuration overview

On the Oracle database server (target)

Oracle Database Gateways

Oracle heterogeneous connectivity solution architecture

Heterogeneous Services

Database Gateways (Heterogeneous Services agent)

Overview of Database Gateway installation and configuration

Oracle Data Integrator

ODI repositories

ODI Studio

ODI runtime agent

ODI console

Data management case study

Company overview

Company challenges

Overstock.com's value proposition

Integration framework

Summary

8. Application and Process Integration

History of application integration

Point-to-Point API-based integration

EDI

Message and integration brokers

XML over HTTP or FTP

History of Oracle integration products

Oracle InterConnect

Oracle ProcessConnect

Oracle Enterprise Service Bus

Oracle Workflow - process integration

Oracle commercial off-the-shelf (COTS) application integration history

Oracle application and process integration software stack

Oracle Business Process Analysis

Oracle Business Process Management

SOA Adapters

Oracle Business Rules

Oracle BPEL

Oracle Service Bus

Oracle Complex Events Processing (CEP)

Oracle Business-to-Business (B2B)

Oracle Service Component Architecture (SCA)

Oracle Web Services Registry

Oracle Web Services Manager

Metadata Services (MDS)

AIA — Going beyond the Oracle SOA Suite

AIA — fundamentals

Enterprise Business Objects

Enterprise Business Messages

Enterprise Business Service

Enterprise Business Flow

Application Business Connector Service

Tools — development environment

Oracle AIA Foundation and Process Integration Packs

Oracle JDeveloper

Eclipse

Oracle SOA Suite integration best practices

Oracle success stories

Success one — Saleforce.com and Oracle E-Business Suite

Solution

Benefits

Success two — cross-industry Oracle eAM print solution

Solution

Benefits

Summary

9. Information Lifecycle Management for Transactional Applications

Data growth challenges

How enterprises try to solve data growth issues

Hardware refresh

SQL/DB tuning

Delete historical data

What is Information Lifecycle Management?

What benefits can ILM offer?

Active Application Archiving

Application Retirement

Start with Application Portfolio Management

Application Retirement solution from Solix Technologies and Oracle partner

Summary

A. Appendix

Cloud integration

Implications of web services for all Integration

Data, process, and application integration convergence

Job scheduling, ETL/ELT and BPEL product convergence

Middle tier integration appliances

Security

Mobile data and collective intelligence

Summary

Index