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.