Oracle-to-SAP HANA Database Replication Setup

Implement a sample replication system for replication from Oracle to SAP HANA database.

Use the tasks in this document to set up a proof-of-concept or test replication system. Only basic Oracle features are addressed in the example scenario. In particular, Oracle Automatic Storage Management (ASM) and Real Application Clusters (RAC) are not addressed in this guide, although Replication Agent does support these features. See the Replication Agent Primary Database Guide

The tasks use the sample Replication Server instance SAMPLE_RS. If you have already installed Replication Server, skip to the configuration procedures.

The replication of sequences is not discussed in this document. To set up sequence replication, see the Replication Agent Installation Guide and the Replication Agent Primary Database Guide.

For the most current information about Replication Server and its components, see the Replication Server Release Bulletin.

• System Architecture
  Multiple components are required to implement an Oracle-to-SAP HANA database replication system: a primary Oracle data server, a replicate SAP HANA database, a Replication Server with ExpressConnect for HANA DB, and Replication Agents for Oracle.
• Prerequisites
  Review the prerequisites before you begin setting up Oracle-to-SAP HANA database replication.
• Planning Your Installation
  Before installing the replication components, verify the system requirements, identify the Sybase installation directories, and obtain the installation software.
• Installing Replication Components
  Review the procedures for installing the replication components.
• Configuring Replication Components
  Review the procedures for configuring each of the replication components in the replication system.
• Testing Replication
  When you finish setting up the replication system, test that replication works as intended.