System Architecture

An SAP Replication Server Data Assurance Option system has a central Data Assurance (DA) server component with zero or more satellite DA agents. The exact number of servers and agents depends on your deployment type: single-server or distributed.

Single-Server Deployment

The example architecture shown here illustrates a single-server deployment with:
  • One DA server (with embedded agent)
  • One primary (source) database
  • One replicate (target) database
  • Data Assurance System Database (DASD)
  • Command line tool (CLT)
  • Replication Server System Database (RSSD)
  • Protocols used between components
Single-Server Deployment
da_arc_ss

Distributed Deployment

The example architecture shown here illustrates a distributed deployment with:
  • One DA server (with embedded agent)
  • Two remote DA agents
  • One primary (source) database
  • Two replicate (target) databases
  • Data Assurance System Database (DASD)
  • Command line tool (CLT)
  • Replication Server System Database (RSSD)
  • Protocols used between components
Distributed Deployment
da_arc

DA server is the core component and includes the DASD and an embedded DA agent, which is called the local agent. The remote DA agent stands alone, and is used by a DA server to enhance comparison job performance. We recommend you to install a remote DA agent on a machine that shares a fast Ethernet connection with your database.

DA server:
  • Compares rows
  • Compares schemas
  • Creates jobs
  • Creates schedules for job
  • Creates script for reconciliation
  • Creates Data Manipulation Language (DML) commands for automatic reconciliation
  • Checks job status
  • Generates reports

Determine the number of DA agents to install based on your database or replication environment requirements. For example, you may choose to install one remote DA agent for your primary (source) database and one remote DA agent for your replicate (target) database. If you have different jobs that connect to different databases, you may decide to install multiple remote DA agents. Or you may have a single primary database and 10 replicate databases, and yet choose to perform the entire comparison task using the local agent.

To send commands to the DA server or the DA agent, use either:
  • The interactive SQL (isql) tool. The isql parser lets you run multiple commands sequentially through an isql options file. See SAP Adaptive Server Enterprise > Utility Guide > Using Interactive isql from the Command Line.
  • The SAP® Control Center (SAP SCC) Data Assurance plug-in. See SAP Control Center for Data Assurance Documentation.

DA server integrates with SAP Replication Server to automatically generate DA server jobs that are based on the information in the RSSD. SAP Replication Server can import jobs only from table replication definitions; it cannot import jobs from database replication definitions.

DA server supports only one login, da_admin, which is assigned all administrator privileges.

Related concepts
Data Assurance Agents
Connection Profiles
Data Assurance System Database
Integration with SAP Replication Server
Related reference
import job