Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction

• OracleAS CDC Adapter for SQL Server Overview
• OracleAS Adapter for SQL Server CDC Agent Architecture
• OracleAS CDC Adapter for SQL Server Architecture
  • The Staging Area

2 Configuring the OracleAS CDC Adapter for SQL Server

• Setting Up a Windows Computer in Oracle Studio
• Securing Access to Oracle Connect
  • Setting Password Access to Oracle Studio
  • Specifying Users with Administrative Rights
  • Setting Up Run-Time User Access
• Setting Up a Change Data Capture with the OracleAS CDC Adapter for SQL Server
  • Enabling SQL Replication
    • SQL Server 2000 Replication
    • SQL Server 2005 Replication
  • Configuring Security Properties
  • Setting up Log On Information
  • Setting up the Database
    • SQL Server 2000 Settings
    • SQL Server 2005 Settings
  • Setting Up the TLOG Miner (LGR)
    • Call the LGR Service Interface
    • Configuring the Template Input File
    • Registering the TLOG Miner (LGR) Service
    • Setting the Recovery Policy
  • Setting up a Change Data Capture in Oracle Studio
    • Create a CDC Project
    • Set up the CDC Server
    • Set up the Staging Area Server
  • Deploying a Change Data Capture
    • Activating and Deactivating Solution Workspaces
• Testing the OracleAS CDC Adapter for SQL Server CDC Solution
• Handling Metadata Changes
• Environment Verification
  • Verify the SQL Server Version
  • Ensure that the Service is Registered
  • Verify that the LGR Service is Running
  • Viewing the Service Greetings
  • Check the Output Files

3 WebLogic Deployment and Adapter Integration

• Configuring the SQL Server CDC Adapter In the Application Server
  • CDC Stream Positions Table Definition
  • Configuring the SQL Server CDC Adapter Connection Factory
• Configuring the JCA Configuration Files for the OracleAS CDC Adapter for SQL Server
  • Creating JCA Configuration Files
  • Configuring the Binding File
• High Availability
• Troubleshooting Rollback Loops

4 Configuring a SQL Server CDC Adapter

• Creating Outbound Interactions with the OracleAS Adapter for SQL Server
  • Requirements
• Adding the SQL Server Hospital Data Source
  • Prepare the System
  • Set up Machine Access to Oracle Connect
• Create a Change Data Capture
  • Setting up a Change Data Capture
  • Deploy the Solution
• Create the JCA Configuration Files

5 Creating the Project in JDeveloper Examples

• Getting Started
  • Prerequisites
  • Beginning Tasks
• Deploy a BPEL Inbound Process
  • Design-Time Configuration
    • Create a BPEL Inbound Process
    • Use a Third-Party Adapter for the Inbound Process
    • Design the BPEL Inbound Process
    • Deploy the Project
  • Run-time Configuration
    • Triggering the Event using the XML Utility
• Mediator Inbound Process
  • Beginning Tasks
  • Create a Mediator Inbound Process
  • Use a Third-Party Adapter for the Inbound Process
  • Create a File Adapter
  • Design an Inbound Mediator
  • Create Mapping Rules and Map the Files
  • Deploy the Project

6 Run-time Tasks and Troubleshooting

• Adding and Removing Tables
• Handling Metadata Changes
• Staging Area Maintenance
• Monitoring the Change Data Capture
  • Service Context Table
  • Monitoring the Status
• Daemon Life-Cycle Tasks
  • Starting the Daemon
  • Shutting Down the Daemon
  • Monitoring the Daemon During Run time
    • Daemon (Computer) Options
    • Workspace Options
    • Server Options
  • Daemon Logs
    • The Log Monitor
• Resolving Communication Errors
• Resolving Specific Errors

7 Advanced Features of OracleAS CDC Adapter for SQL Server

• Configuring the Daemon for High Availability
  • Adding a New Daemon Workspace Configuration
  • Editing the Workspace
  • Configuring the Server Mode
• Configuring a Binding Environment
  • Debug
  • General
  • Language
  • Modeling
  • ODBC
  • OLEDB
  • Optimizer
  • Parallel Processing
  • Query Processor
  • Transaction
  • Tuning
  • XML
• Migration Considerations
• Security Considerations
  • Setting Design Time Security
  • Setting Run-time Security
• Transaction Support

A Advanced Tuning of the Metadata

• Metadata for the SQL Server Data Source
  • General Tab
  • Columns Tab
    • Column Definition Section
    • Column Properties
  • Indexes Tab
    • Table Information
    • Properties
  • Statistics Tab
    • Generating Statistics
  • Advanced Tab
• Adapter Metadata
  • Adapter Metadata General Properties
  • Adapter Metadata Interactions
    • Interaction Advanced Tab
  • Adapter Metadata Schema Records
  • Adapter Metadata XML

B Advanced Tuning of the Daemon

• Control
• Logging
• Security
• Workspaces
  • General
  • Server Mode
  • Security

C Editing Properties for the OracleAS CDC Adapter for SQL Server

• Editing Properties in Oracle Studio
  • Editing the OracleAS CDC Adapter Properties
• Configuration Properties
  • CDC Logger Properties
  • OracleAS CDC Adapter Configuration Properties
    • OracleAS CDC Adapter for SQL Server Properties
    • CDC Queue Adapter Properties
    • Common CDC Adapter Properties
  • Change Router Properties
  • Referential Integrity Considerations
• Access to Change Events
• Transaction Support
• Security
• Data Types
  • User Defined Data Types (UDT)

D Globalization Settings

• Defining the Language and Code Page

E Editing XML Files in Oracle Studio

• Preparing to Edit XML Files in Oracle Studio
• Making Changes to the XML File
  • Remove Objects
  • Add DTD Information
  • Edit Namespaces
  • Add Elements and Attributes
  • Replace an Element

Index