Oracle Replicate Database Configuration

The heterogeneous datatype support (HDS) feature of Replication Server provides configuration information that allows you to set up the HDS feature in the replicate Replication Server and the Oracle replicate database.

The configuration information is provided as part of the installation and as part of the connection profile:

Replication Server installation:
- Create function strings, error classes, and user defined datatypes
Connection profile:
- Apply class-level datatype translations to RSSD
- Create objects in the Oracle replicate database
- Set connection properties
  
  You can connect using either an ECDA Server or ExpressConnect for Oracle. Depending on whether you are connecting using an ECDA Server or ExpressConnect for Oracle, the version or option name of the connection profile should be “ecda” or “eco,” respectively.
Additional settings:
- ECDA settings
- Settings for Command Batching
- Settings for Dynamic SQL

Replication Server Installation
Replication Server installation automatically installs the required function strings and classes to support replication.
Connection Profiles
Connection profiles allow you to configure your connection with a predefined set of properties.
Additional Settings
Learn about the additional settings provided to support replication.

Parent topic: Oracle as Replicate Data Server

Related concepts

Class-Level Datatype Translations to RSSD

Objects in the Oracle Replicate Database and Connection Properties

ECDA Settings

Command Batching Settings

Dynamic SQL Settings