Prerequisites

Review the prerequisites before you begin setting up Oracle-to-SAP HANA database replication.

Make sure:

  • You are familiar with Oracle and SAP HANA database.

  • You have valid licenses for Replication Server with ExpressConnect for HANA DB and Replication Server Options.

  • Oracle Database 10g or 11g Enterprise Edition is installed and configured to serve as the source (primary) database from which Replication Agent replicates transactions, and SAP HANA database is installed and configured as the target (replicate) database to which Replication Server with ExpressConnect for HANA DB replicates transactions.

  • If Oracle 10g or 11g Release 1 is the primary database, install the Oracle JDBC™ thin driver for Oracle 10g or 11g and for JDK 1.4 and 1.5. If the primary database is Oracle 11g Release 2, install the Oracle JDBC thin driver 11.2 for JDK 1.6.

  • TCP/IP connectivity is available between all hosts.

  • Any operating system patches required for Java have been installed.

  • The Replication Agent has direct access to the Oracle online and archived redo logs.

Do not use Replication Server reserved words for object names or connection names. A complete list of reserved words is in the Replication Server Reference Manual.

Parent topic: Oracle-to-SAP HANA Database Replication Setup