Preface
Data Replication Overview
- Product Overview
- Data Replication Usage Scenarios
- Data Replication Sources and Targets
- Data Replication Architecture and Components
- Stages of Replication Processing
- Alternative Deployment Topologies
- Replication Configurations
Understanding Data Replication
- Overview
- Replicating Source Tables That Do Not Have a Primary Key Definition
- Start Point for the Extractor Task
- Apply Processing
- Checkpointing
- Recovery
  - Recovery Tables
- Tcl and SQL Scripts for Advanced InitialSync and Applier Processing of Data
- Database Character Set Conversion
- Replication of Database-Generated Values
- Generated Virtual Indexes
- Datatype Conversion Rules
- DDL Replication
Sources - Preparation and Replication Considerations
- DB2 for Linux, UNIX, and Windows Sources
- Microsoft SQL Server Sources
- MySQL Sources
- Oracle Sources
Targets - Preparation and Replication Considerations
- Amazon Redshift Targets
- Apache Kafka Targets
  - Preparing Apache Kafka Target Systems
  - Replication Considerations for Apache Kafka Targets
- Cloudera and Hortonworks Targets
  - Preparing Cloudera and Hortonworks Target Systems
- DB2 for Linux, UNIX, and Windows Targets
- Greenplum Targets
- MemSQL Targets
- Microsoft SQL Server Targets
- MySQL Targets
- Netezza Targets
- Oracle Targets
- PostgreSQL Targets
- Teradata Targets
- Vertica Targets
Starting the Server Manager
- Overview
- Installing the Server Manager as a Service on Windows
- Starting the Server Manager as a Windows Service
- Starting the Server Manager as a Daemon on Linux or UNIX
- Manually Starting the Server Manager
- Stopping a Server Manager Service or Daemon
- Uninstalling the Server Manager Service on Windows
Getting Started with the Data Replication Console
- Data Replication Console Interface
- Starting the Data Replication Console
Defining and Managing Server Manager Main Servers and Subservers
- Server Manager Main Server and Subservers
- Defining the Main Server and Its Subservers
- Editing Connection Information for a Main Server or 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
- Associating a Subserver with Another Main Server
- Deleting Subservers
Creating and Managing User Accounts
- User Account Overview
- Users and Privileges
- Server Manager Security Policies
- Creating a User Account
- Changing the Password for Your User Account - Replication User
- Changing the Password for a User Account - idradmin User
- Unlocking a User Account
- Resetting the Password for the idradmin Account
Creating and Managing Connections
- Connections Overview
- Creating a Source or Target Connection from the Server Manager Tab
- Editing a Source or Target Connection
- Assigning a Different Source or Target Connection to a Configuration
Creating Replication Configurations
- Replication Configuration
- Task Flow: Creating a Replication Configuration
- Defining the Source Database
  - Configuring a Connection to an Oracle ASM Instance
  - Configuring Connections to Oracle RAC Sources for High Availability
    - Connecting to an Oracle RAC by Using Custom Connection Strings
    - Connecting to an Oracle RAC by Using a Virtual IP Address or Host Name
- Defining the Target Database
- Generating Target Tables and Audit Log Tables
- Generating Avro Schemas for Apache Kafka Consumers
- Handling Source Tables with Long Table or Column Names
  - Strategies for Handling Long Table Names
    - Editing the Audit Log Table Suffix
    - Manually Editing Target Table Names in an SQL Script
  - Strategies for Handling Long Column Names
- Mapping Source and Target Tables
- Defining Source Table Indexes
- Enabling Replication of DDL Changes at the Schema and Table Levels
- Customizing Apply Settings for Target Tables
- Configuring the Start Points for Extractor and Applier Tasks
- Configuring Conflict Resolution
  - Example of Configuring a MAXIMUM Resolution Strategy for Update Conflicts
  - Example of Configuring Custom Conflict Resolution
- Customizing Column Mappings
  - Filtering Column Data
- 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
Materializing Targets with InitialSync
- InitialSync Overview
- Source Connectivity for Data Unload Operations
- Target Connectivity for Data Load Operations
- Sync Point Value
- InitialSync Handling of Target Table Constraints
- Considerations for Running InitialSync
- Task Flow: Using InitialSync to Materialize a Target
Scheduling and Running Replication Tasks
- Methods of Running Replication Tasks
- Types of Replication Tasks
- Schedule and Task Statuses
- Conflicting Replication Tasks
- Running Replication Executables Manually from the Data Replication Console
- Scheduling Replication Tasks
Implementing Advanced Replication Topologies
- Advanced Replication Topologies
- Configuring Continuous Replication
- Configuring Data Replication from One Source to Multiple Targets
- Configuring Bidirectional Replication
- Configuring Cascade Replication
- Loopback Avoidance for Replicated Data
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
Managing Replication Configurations
- Configuration Management Tasks
- Switching to Read or Edit Mode for a Replication Configuration
- Editing a Replication Configuration
- Changing the Server Manager Associated with a Replication Configuration
- Clearing User Replication Settings
- Managing Database Supplemental Logging
- Deploying Replication Configurations
- Generating a Reverse-Replication Configuration
- Exporting a Configuration File
- Importing a Configuration File
- Cleaning Replication Processing Information for a Configuration
  - Performing a Clean Operation on a Configuration
- Viewing Earlier Revisions of a Replication Configuration
- Viewing a List of Processed Database Logs
Handling Replication Environment Changes and Failures
- Manually Changing the Source Table Structure After Running Data Replication
- Updating an Avro Schema for Kafka Targets After Running Data Replication
- Adding Table Mappings Manually After Running Data Replication
- Resuming Replication After Upgrading a DB2 for Linux, UNIX, and Windows Source Database
- Resuming Replication After Upgrading a Microsoft SQL Server Source Database
- Handling Applier Failures
Troubleshooting
- Collecting Diagnostic Data for Troubleshooting
- Common Replication Problems
Data Replication Files and Subdirectories
- Files and Subdirectories
- Data Replication Script Files
- Executables Called from the Data Replication Console or Scripts
- Default.cfg File
- Other Key Files
- Subdirectories
Data Replication Runtime Parameters
Command Line Parameters for Data Replication Components
- About Command Line Parameters
- Command Line Parameters for InitialSync
- Command Line Parameters for the Extractor
- Command Line Parameters for the Applier
- Command Line Parameters for the Server Manager
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
- Applier task
- apply cycle
- Audit Apply
- audit log table
- bidirectional replication
- binary log
- calculated columns
- cascade replication
- change data capture
- checkpoint processing
- Command Line Interface
- configuration file
- continuous replication
- Copy File task
- data files
- data warehouse appliance
- Edit mode
- External task
- Extractor
- Extractor task
- Flat File target
- global transaction
- heterogeneous replication
- Informatica Data Replication Console
- initial materialization
- InitialSync
- InitialSync task
- intermediate files
- log coordinates
- loopback avoidance
- Merge Apply
- Microsoft SQL Server Backup task
- primary target
- CDC Publisher
- 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 Point
- subtask threads
- supplemental logging
- Sync Point
- Tcl expression
- Tcl Script Engine
- transaction files
- transactional replication
- virtual column
- virtual index

User Guide

9.8.0

Back Next

Toolbar Icon Buttons

Instead of choosing commands from the menu bar or right-clicking an item and selecting a command, you can click icon buttons on the Console toolbars to quickly initiate common actions.

Main Toolbar Buttons

The following icon buttons appear on the main toolbar:

Button	Description
	Create a configuration file.
	Open an existing configuration file.
	Save a configuration file remotely.
	Run an InitialSync task.
	Run an Extractor task.
	Run an Applier task.
	Generate schema-definition scripts (DDL) for a target.
	Display latency, Extractor, and intermediate files statistics for the open configuration.
	Enable Edit mode for the configuration that is currently open.
	Enable Read mode for the configuration that is currently open.

Replication Configurations Toolbar Buttons

The following icon buttons appear on the Server Manager tab >

Configs

view:

Button	Description
	Create a new replication configuration.
	Delete the selected replication configuration.
	Edit properties for the selected replication configuration, including the owner, connections, Server Manager instances, and runtime environments.
	In the Editing dialog box that displays when you click the Properties icon button, change the source or target Server Manager instance for configuration connections.
	Import a replication configuration.
	Export a replication configuration for saving as an XML file and a set of DB files.
	Clean the selected replication configuration.
	Display the Deploy a Configuration wizard for deploying the selected replication configuration.
	Display latency, Extractor, and intermediate files statistics for the selected replication configuration.
	Display the revisions for a selected replication configuration.
	Display a list of processed database log files for the selected replication configuration.
	Display a list of intermediate files for the selected replication configuration.
	Generate a reverse configuration of the selected replication configuration for bidirectional replication.
	Show the open transactions for the selected replication configuration.
	Check the connection from the Server Manager Main server to any subservers and from subservers back to the Server Manager Main server.
	Edit the default Applier, Extractor, and InitialSync tasks for a configuration.

Server Managers Toolbar Buttons

The following icon buttons appear on the

Server Manager

tab >

Servers

view:

Button	Description
	Add a new Server Manager subserver instance.
	Edit connection details for the selected Server Manager instance.
	Delete the selected Server Manager instance.
	Display the message log for the selected Server Manager instance.
	For Microsoft SQL Server source instances on the system where the selected Server Manager runs, manage connection details and SQL Server CDC jobs.
	Display details about the system environment variables on the system where the selected Server Manager instance runs.
	Test the connection between the selected Server Manager instance and the Data Replication Console.
	Check the connection from the Server Manager Main server to any subservers and from subservers back to the Server Manager Main server.
	Display properties for the selected Server Manager system, including the available disk space. Enables you to edit properties such as file paths, Server Manager advanced settings, message log settings, and parameters for latency statistics.
	Display a list of available servers.

Schedules Toolbar Buttons

The

Server Manager

tab >

Schedules

view includes two toolbars.

Schedules toolbar:

Button	Description
	Create a new schedule.
	Edit details for the selected schedule.
	Delete the selected schedule.
	Start the Schedule Wizard for creating a new schedule.
	Start the selected schedule.
	Stop the selected schedule.
	Force the selected task to end immediately when you cannot wait for the task to complete processing.
	Display latency, Extractor, and intermediate files statistics for the replication configuration that is associated with the selected schedule.
	Display a list of intermediate files for the replication configuration that is associated with the selected schedule.
	Refresh the status of the selected schedule.

Processes toolbar:

Button	Description
	Display detailed information about a selected task, including the run ID, task name, start and end time, database connection, server, type of task, command syntax, directory, success or failure status, and exit code.
	Display the task output log file names and sizes.
	Display any processes that are blocking the selected task.
	Start the selected task.
	Display the process logs for the selected task.
	Stop the selected task.
	Force the selected task to end immediately when you cannot wait for the task to complete processing.

Tasks and Task Dependencies Toolbar Buttons

The following icon buttons appear on the

Server Manager

tab >

Tasks

view:

Button	Description
	Create a new task.
	Edit the details and task dependencies for the selected task.
	Delete the selected task.
	Select the tasks that block the selected task.

Connections Toolbar Buttons

The following icon buttons appear on the

Server Manager

tab >

Connections

view:

Button	Description
	Create a new connection.
	Edit the connection details for the selected connection.
	Delete the selected connection.
	Test the connection between the source or target database specified in the selected connection and the Data Replication Console.

Environment Lists Toolbar Buttons

The following icon buttons appear on the

Server Manager

tab >

Environment

view:

Button	Description
	Create a new environment variable.
	Edit the selected environment variable.
	Delete the selected environment variable.

Event Viewer > Logs of Schedules Toolbar Buttons

The following icon buttons appear on the

Server Manager

tab >

Event Viewer

view >

Logs of Schedules

subtab:

Button	Description
	Display detailed information about a selected task, including the run ID, task name, start and end time, database connection, server, type of task, command syntax, directory, success or failure status, and exit code.
	Display the task output log file names and sizes.
	Display any processes that are blocking the selected task.
	Display the process logs for the selected task.
	Stop the selected task.
	Force the selected task to end immediately when you cannot wait for the task to complete processing.

Map Tables Tab Toolbar Buttons

The following icon buttons appear on the

Map Tables

tab:

Button	Description
	Unmap a mapped source table.
	Edit the indexes that are defined for the selected mapped source table.
	Display, add, edit, delete, or reuse virtual columns for the selected mapped source table.
	Add or edit an SQL or Tcl expression for the selected source table.
	Define conflict resolution rules for the selected target table to handle conflicts that might occur during apply processing.
	Manage the database supplemental logging settings for DB2 for Linux, UNIX, and Windows, Microsoft SQL Server, and Oracle sources.

Map Columns Tab Toolbar Buttons

The following icon buttons appear on the

Map Columns

tab:

Button	Description
	Add or edit a WHERE clause to filter data from redo logs for a selected source column.
	Delete a virtual column.
	Add or edit an SQL or Tcl expression for a virtual column.
	Add a virtual column to the source table.

Routing Tab Toolbar Buttons

The following icon buttons appear on the

Routing

tab and its subtabs:

Top toolbar:

Button	Description
	Add a new target server instance and a connection for the target.
	Edit the connection for the selected target server instance.
	Delete the selected target server instance.

Filters

subtab > toolbar for groups:

Button	Description
	Add a new filter group.
	Edit the selected filter group.
	Delete the selected filter group.

Filters

subtab > toolbar for columns:

Button	Description
	Add a new filter condition for the group filter.
	Edit the selected filter condition.
	Delete the selected filter condition.

Schema Name

subtab toolbar:

Button	Description
	Rename the target schema name.
	Edit the selected target schema name.
	Delete the selected target schema name.

Rename Saved Search

Table of Contents

User Guide

User Guide

Toolbar Icon Buttons

Toolbar Icon Buttons

Main Toolbar Buttons

Replication Configurations Toolbar Buttons

Server Managers Toolbar Buttons

Schedules Toolbar Buttons

Tasks and Task Dependencies Toolbar Buttons

Connections Toolbar Buttons

Environment Lists Toolbar Buttons

Event Viewer > Logs of Schedules Toolbar Buttons

Map Tables Tab Toolbar Buttons

Map Columns Tab Toolbar Buttons

Routing Tab Toolbar Buttons