The Informatica Data Replication Console is a graphical user interface for configuring and administering data replication on Windows operating systems.
Use the Console to perform the following tasks:
Create a replication configuration
Configure a Server Manager
Schedule and run a replication job
Monitor a replication job
Deploy a replication configuration to another replication environment
Manage replication configurations, users, and notifications
A Server Manager must be running to perform all of these tasks except configuring a new Server Manager instance.
When creating a replication configuration, you define the source database and tables, target database and tables, mappings between the source and target tables and columns, and other settings. The Console includes a schema generation option that generates compatible target table definitions based on selected source table definitions. The Data Replication Console leverages JDBC connectivity to extract the metadata that is required for mappings and execution of generated DDL.
For each replication configuration you create, Data Replication generates the following three SQLite database files that are stored in the
DataReplication_installation
/configs directory:
configuration_name
.db. This database file stores the table, column, and mapping definitions as well as Extractor processing information for the configuration. The Extractor uses this configuration database file to write the list of processed database logs and checkpoint information.
configuration_name
_buf.db. This database file contains only the processing information for the sendFile task, including the list of intermediate files that have been transferred to the Applier.
configuration_name
_loader.db. This database file contains processing information for Applier tasks, such as intermediate file statuses, a list of committed SCNs, and statistics.
If a replication configuration uses different servers for the source and target, a copy of the
configuration_name
.db file is stored in the
DataReplication_installation
/configs directory on both server machines. The
configuration_name
_buf.db file is stored only on the source database machine.
Informatica recommends that you use the Data Replication Console to manage configurations and replication jobs. You can run the Data Replication Console standalone on a 64-bit Windows computer system as long as the Console has JDBC connectivity to the source and target systems.