Oracle Information Integration, Migration, and Consolidation Table of Contents

Table of Contents

Preface
Chapter 1: Getting Started with Information Integration
Chapter 2: Oracle Tools and Products
Chapter 3: Application and Data Integration Case Study
Chapter 4: Oracle Database Migrations
Chapter 5: Database Migration Challenges and Solutions
Chapter 6: Data Consolidation and Management
Chapter 7: Database-centric Data Integration
Chapter 8: Application and Process Integration
Chapter 9: Information Lifecycle Management for Transactional Applications
Appendix
Index

• Preface

• 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
• 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• Chapter 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

• 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