Non-ASE Primary to Adaptive Server Replicate

The simplest heterogeneous replication scenario is replicating one-way from a non-ASE primary database to an Adaptive Server replicate database.

The only unique requirements are a Replication Agent designed to extract transaction data from the non-ASE primary database, and the application of the Heterogeneous Datatype Support (HDS) feature of Replication Server to translate primary database native datatypes to Adaptive Server datatypes.

See Replication Server Administration Guide Volume 1 > Manage Replicated Tables > Translating Datatypes Using HDS.

Replication System Components

The following components are required for a non-ASE primary to Adaptive Server replicate configuration:

Non-ASE primary data server. For example, Oracle.
Replication Agent designed for the primary data server
Replication Server
Adaptive Server replicate data server

Replication System Issues

In a non-ASE primary to Adaptive Server replicate configuration, the Replication Server database connection for the primary database may require a valid user ID and password for the primary database (validated only for Replication Agent), even though this user ID does not apply transactions to the primary database.