Preface
Data Replication Overview
- Product Overview
- Data Replication Usage Scenarios
- Data Replication Sources and Targets
- Data Replication Components
- Data Replication Deployment Topologies
- Data Replication Apply Modes
Installing Data Replication
- Installation Overview
- System Requirements
- Installing Data Replication
- Installing the Java Runtime Environment
- JDBC Drivers
- Defining the DBSYNC_HOME Environment Variable
- Adding DBSYNC_HOME Libraries to the Library Path Environment Variable on Linux and UNIX
- Verifying the Environment Variables on Linux and UNIX
- Setting Limits for System Resources on Linux and UNIX
- Entering the License Key
Preparing Source and Target Systems
- Source and Target Preparation and Replication Considerations
- ODBC Drivers
  - Supported ODBC Drivers
  - Configuring the DataDirect ODBC Drivers and Driver Manager
- Preparing Source Systems
- Preparing Target Systems
- Replication Configuration Considerations for Sources
- Replication Configuration Considerations for Targets
Replication Basic Concepts
- Understanding Replication Basics
- Strategies for Running Replications
- Replication Configurations
- Database Character Set Conversion
- Replication of Database-Generated Values
- Database Logging Requirements for Source Tables
- Replicating Tables without a Primary Key Definition
- Datatype Conversion Rules
- Tcl and SQL Scripting for Advanced InitialSync and Applier Processing of Data
- DBSYNC_SYNC_LSN Table
InitialSync Processing
- Target Materialization with InitialSync
- Source Connectivity for Data Unload Operations
- Target Connectivity for Data Load Operations
- Sync SCN Value
- InitialSync Handling of Target Table Constraints
- Considerations for Running InitialSync
Extractor and Applier Processing
- Start SCN Value for the Extractor Task
- Extractor Processing of Redo Logs from Oracle RAC Sources
  - The Order of Writing Extracted Records to the Intermediate Files
  - Configuring Archived Log Switches
- Applier Processing of Intermediate Files
- Applier Handling of the Sync SCN Value
- Applier Processing of Updates in Merge Apply Mode
- Commit Processing and Target Constraints with Applier Multi-Threaded Processing
- Applier Processing of Updates for Duplicate Records
- Conflict Resolution for Replicated Data
- Post-Apply Processing
  - AFTER_APPLY XML Data Structure
  - Data Visibility Across Multiple Applier Threads
DDL Replication
- DDL Replication Overview
- Considerations for DDL Replication
- Replication Considerations for CREATE TABLE and ADD COLUMN Operations
  - Logging Supplemental Information for Source Tables Created with Replicated DDL
- Replication of TRUNCATE TABLE Operations
- Order in Which Data Replication Applies DDL Operations
- Examples of DDL Replication
- Supported DDL Operations for Sources
- Supported DDL Operations for Targets
Recovery and Checkpoint Processing
- Stages of Recovery Processing
- Checkpoint Processing
- Recovery Tables
- Guidelines for Resuming Applier Processing After a Failure
Configuring the Server Manager
- Server Manager Main Server and Subservers
- Installing the Server Manager as a Service on Windows
- Starting the Server Manager as a Service or Daemon
- Manually Starting the Server Manager
- Stopping a Server Manager Service or Daemon
- Uninstalling the Server Manager Service on Windows
- Defining the Main Server and Its Subservers
- Editing the Main Server or a Subserver
- Editing Microsoft SQL Server Instance Settings
- Editing Properties for the Main Server or a Subserver
- Viewing Information About the Server Manager System
- Configuring the Server Manager for HTTPS Communication
- Configuring the Server Manager Main Server to Run with NAT
- Creating and Managing User Accounts
- Associating a Subserver with Another Main Server
- Deleting Subservers
Creating Replication Configurations in the Data Replication Console
- Data Replication Console Interface
- Starting the Informatica Data Replication Console
- Task Flow: Creating a Replication Configuration
- Defining the Source Database
  - Configuring a Connection to an Oracle ASM Instance
  - Connecting to Oracle RAC Sources
    - Connecting to an Oracle RAC by Using Custom Connection Strings
    - Connecting to an Oracle RAC by Using a Virtual IP Address
- Defining the Target Database
- Generating Target Tables and Audit Log Tables
- Handling Source Tables with Long Table or Column Names in Merge Apply or Audit Apply Mode
  - Strategies for Handling Long Table Names
    - Editing the Audit Log Table Suffix
    - Manually Editing Target Table Names in an SQL Script for Merge Apply
  - Strategies for Handling Long Column Names
- Mapping Source and Target Tables
- Defining Source Table Indexes
- Customizing Apply Settings for Target Tables
- Configuring Conflict Resolution
  - Example of Configuring a MAXIMUM Resolution Strategy for Update Conflicts
  - Example of Configuring Custom Conflict Resolution
- Configuring the Start Points for Extractor and Applier Tasks
- Customizing Column Mappings
  - Filtering Column Data
- Enabling Replication of DDL Changes
- Adding Tcl and SQL Expressions
- Specifying the Database Logs from Which to Extract Data
- Configuring Runtime Settings
- Configuring Message Logging
- Saving Replication Configurations to the Main Server Manager
Managing Replication Configurations
- Configuration Management Tasks
- Opening a Replication Configuration in the Data Replication Console
- Switching to Read or Edit Mode for a Replication Configuration
- Editing a Replication Configuration
- Updating Connection Information for a Replication Configuration
- Clearing User Replication Settings
- Cleaning Replication-Related Information
- Deploying Replication Configurations
- Importing a Configuration File
- Exporting a Configuration File
- Replication Configuration Revisions
  - Viewing Earlier Revisions of a Replication Configuration
- Generating a Reverse-Replication Configuration
- Managing Database Supplemental Logging
Running Data Replications
- Methods of Running Replications
- Conflicting Replication Tasks
- Running Replication Executables Manually from the Data Replication Console
- Scheduling Replication Tasks
Configuring Selected Replication Types
- Overview of Selected Replication Types
- Configuring Continuous Replication
- Configuring Data Replication from One Source to Multiple Targets
- Loopback Avoidance for Replicated Data
- Configuring Bidirectional Replication
- Configuring Cascade Replication
Monitoring Data Replication
- Types of Monitoring Information
- Replication Statistics
- Intermediate Files
- Task Execution Logs
- Server Manager Logs
  - Viewing Server Manager Logs
- User Notifications
- Skipped Transaction Records
- Managing Open Transactions
Maintaining the Replication Environment
- Manually Changing the Source Table Structure After Running Data Replication
- Adding Table Mappings Manually After Running Data Replication
- Viewing a List of Processed Database Logs
- Resuming Replication After Upgrading a DB2 for Linux, UNIX, and Windows Source Database
Troubleshooting
Data Replication Files and Subdirectories
- Data Replication Script Files
- Executables Called from the Data Replication Console or Scripts
- Other Key Files
- Subdirectories
Data Replication Runtime Parameters
InitialSync, Extractor, and Applier Command Line Parameters
Server Manager Command Line Parameters
Updating Configurations in the Replication Configuration CLI
- Replication Configuration CLI Overview
- Updating Source and Target Metadata for a Replication Configuration in the CLI
  - Updating Source and Target Metadata for a Configuration in Interactive Mode
  - Updating Source and Target Metadata for a Configuration in Non-interactive Mode
- Replication Configuration CLI Commands
DDL Statements for Manually Creating Recovery Tables
Sample Scripts for Enabling or Disabling SQL Server Change Data Capture
- Microsoft SQL Server Enterprise Edition
Glossary
- Applier
- apply cycle
- Audit Apply
- audit log table
- bidirectional replication
- calculated columns
- cascade replication
- change data capture
- checkpoint processing
- Command Line Interface
- configuration file
- continuous replication
- data files
- data warehouse appliance
- Edit mode
- Extractor
- Flat File target
- global transaction
- heterogeneous replication
- Informatica Data Replication Console
- initial materialization
- InitialSync
- intermediate files
- loopback avoidance
- Merge Apply
- primary target
- Read mode
- recovery table
- Replication Configuration Command Line Interface
- replication configuration file
- replication statistics
- replication tasks
- routing
- secondary target
- Send File task
- Server Manager
- Server Manager Command Line Interface
- Server Manager Main server
- Server Manager subserver
- SQL Apply
- SQL Script Engine
- staging table
- Start SCN
- subtask threads
- supplemental logging
- Sync SCN
- Tcl expression
- Tcl Script Engine
- transaction files
- transactional replication
- virtual column
- virtual index

User Guide

9.6.3 HotFix 1
- 9.7.0 HotFix 1
- 9.6.3

Back Next

Subdirectories

A Data Replication installation includes the following subdirectories that appear after installation or that are generated subsequently:

configs: Contains Data Replication configuration files and the Extractor and Applier SQLite databases. For each configuration file, Data Replication generates the following directory and files:
<config_name>_<target_number>
. A subdirectory for a configuration that contains the SQLite database files that store the Applier service information for each target. When a replication has multiple targets, Data Replication generates a separate subdirectory for each target.
<config_name>.db
,
<config_name>.db-journal
or
<config_name>.db-wal
,
<config_name>.db-shm
. The SQLite database files that store the configuration file and Extractor service information.
dd/lib: On Linux and UNIX, contains the DataDirect ODBC driver libraries.
doc: Contains Data Replication user manuals, including this user guide. The
samples
deploy
subdirectory contains a sample deploy.properties file for deploying a configuration in the Server Manager Command Line Interface. Specify the settings for the configuration you want to deploy, and then save the file with another file name in any directory.
dump: Data Replication generates files in this directory to store invalid records that the Oracle Extractor cannot parse.
lib: On Windows, contains java libraries for the Data Replication Console, including JDBC drivers to connect to various databases.
The infaLib subdirectory contains .jar file executables for the following targets:
Cloudera
Hive
Hortonworks
logs: Initially, this subdirectory is empty. When you run the Data Replication Console, Server Manager, and replication tasks, Data Replication generates the following types of log files in this directory or in a subdirectory within it:
Data Replication Console log files, including se.log and ui.log. These log files contain error and debug information for a Console session.
A deployment log file, deployment.log. This log file contains error, status, and warning messages that the Console displays during local or remote deployment of a configuration or configuration changes.
Server Manager log files, which are stored in the SM subdirectory. These log files contain error and debug information for a Server Manager execution.
Log files for replication tasks, including Extractor, Applier, and Send File tasks. The Server Manager groups these logs by execution date and stores them in the appropriate subdirectories.
messages: Contains the error message files that the Data Replication Console displays for Data Replication tasks and processes. The subdirectory also contains separate message files for replication tasks performed with a specific source or target database.
output\configuration_name: Contains the intermediate files that Data Replication generates for a configuration when a replication job runs. Each configuration has a separate configuration_name subdirectory. The subdirectory contains both the data and transaction files that comprise the intermediate files. The data files are .dat files. The transaction files are .trn files.
scripts: On Linux and UNIX, contains the script that sets the environment variables to configure the DataDirect ODBC drivers. Data Replication script files call the script prior running the replication tasks.
support: Contains runtime libraries that the Data Replication executables use. The oci_stub subdirectory contains the Oracle Client library stub, which is required for all sources and targets.
uiconf: Contains global configuration files that are used and updated by the Data Replication Console.

Rename Saved Search

Table of Contents

User Guide

User Guide

Subdirectories

Subdirectories