A
Assembly
A collection of compiled code (for example, in .NET) used in databases or data applications to enable custom functions, procedures, or types, extending the database's native capabilities by incorporating logic that isn’t natively available within the database system itself.
D
Define Columns
A page in the Create Target Table wizard where users can modify attributes or structures of the source table.
Distributor
Manages a log that keeps track of transactions for the source table.
G
Groups
A replication group contains related replications together as a group and allows you to manage replication properties (scheduling and preferences) for all replications in the group.
J
Journal
A log that collects modified data, detailing operations performed on physical files and recording them in a receiver.
L
Log Reader
A component of Syniti Replicate that reads the native database transaction log using a reader thread for each replication, sutiable if you have a limited number of replications and do not want to install additional services on the system that is running the Server Agent component.
Log Reader API
Extends the functionality of the Log Reader by supporting Large Object Binary values in transactional mode.
Log Server Agent
A Windows service on the system running the Server Agent that makes only a single connection to the database to read the binary log for all replications in a source connection. It autonomously reads the native database transaction log and writes changes from replicated tables into intermediate binary log files (in Syniti proprietary format) within a specified folder. The Replication Agent then reads these changes from the intermediate binary log files.
Log-based Transactional Replications
A form of mirroring or synchronization replications run by capturing changes directly from the database transaction log rather than from database triggers.
M
Management Center
The primary interface of Syniti Replicate, installed on-premises, for configuring and managing source/target connections, replications, and replication groups.
Mapping Info
A page in the Create Replication wizard that allows users to match source and target fields based on automatically generated field matches using the default mapping rule.
Mapping Rules
A field mapping function used to define how source and target columns should be mapped when their names use different prefixes. By default, columns with matching names in the source and target tables are mapped together.
Metadata Explorer
A tree-structured area in the Management Center used for various management tasks in Syniti Replicate, such as creating metadata, defining source/target connections, configuring replications, and organizing groups.
Mirroring or Change Data Capture (CDC)
A replication type that continuously updates a target table by applying changes recorded in the source database’s server log or triggers. It typically begins with an initial refresh to synchronize the target table, followed by scheduled checks of the source’s transaction log to replicate any new changes.
O
Object Browser
A tab that displays detailed information about the selected item in the Metadata Explorer. For instance, selecting a source table shows its column names and related information.
P
Provider
An external service responsible for supplying the initial data set or updates to other database systems or data integration platforms.
Publication
A mechanism for identifying tables involved in replication. One publication is created per database, enabling multiple replications to use the same publication.
R
Read Interval
Defines how frequently Syniti Replicate checks the transaction log for new events to replicate using Mirroring.
Receiver
A physical location where traced modifications are written.
Refresh
A one-time, full replication process that copies all data from a source to a target based on predefined replication settings and scripts. This process can occur between databases on the same or different servers and platforms.
Replication Agent
A component of Syniti Replicate that facilitates data replication. It can be installed as a service or run interactively, allowing users to manage and monitor the replication of data between different systems. The Replication Agent connects to a server, retrieves metadata, and synchronizes data as specified in the replication settings. Users can track the progress of the replication through the Replication Monitor tab in the Management Center.
Replication Browser
A tab that displays replications associated with the selected metadata, along with summary information for each replication.
Replication Hub
A component that allows an instance of Syniti Replicate that is installed on-site to connect to Syniti Replicate in the cloud. Replication hubs provide access to data replications which can be viewed and run on the Monitor page in Syniti Replicate.
Replication Monitor
A tab in the Management Center used to track the progress of each data replication.
Replications
A task that involves moving data from a source to a target system, based on specified source data and target connection configurations.
S
Sources
The original data repositories from which data needs to be extracted for replication. Sources include legacy databases, files, cloud storage, and data warehouses, serving as the starting points for data synchronization or migration to one or more target systems.
SQL Script
A page in the Create Target Table wizard that displays the target table creation script, allowing users to modify it as needed.
Synchronization
A replication type that captures changes in both source and target systems, ensuring both remain consistent. Replication settings manage the process by checking logs on each system and applying necessary updates.
T
Targets
The destination systems where data from sources is replicated or being synchronized. These are the systems, databases, or storage locations that receive and store the data, ensuring it is available for use and analysis after migration in the desired format and structure.
Trigger-based Transactional Replications
A form of mirroring or synchronization replication triggered automatically by specific events, such as database table triggers.
V
Verifier
A tool in Syniti Replicate used to verify replication results and reconcile data differences for replications that have been created and run in Syniti Replicate. It aids in troubleshooting replication problems during your replication setup and implementation phase.