Skip to Content

As stated in my previous post, in a replication system using SAP Sybase Replication Server an Oracle database can be either a source or a destination database for data replication. In this post, I’d like to describe an architecture employing Oracle databases as source and destination databases in a SAP Sybase replication environment. My initial focus, however, will be on the scenario where Oracle is the source of primary data i.e. Oracle is the source database. I will also detail an example configuration process for creating a replication system featuring Oracle 11 and ASE 15.7 as source and target or destination databases respectively. I will also share a how-to-video that demonstrates all the technical steps involved in standing up the system.

    In order for Oracle to participate as a source database in a SAP Sybase replication system, we need a separate component called Replication Agent for Oracle (RAO) to read from an Oracle transaction log. Likewise, in order for Oracle to participate as a destination database, we need a connectivity module to access Oracle. We have a couple of implementation options as below:

  • In Pre 15.5 Replication Server versions, we have to configure a separate server component called Direct Connect for Oracle as shown below:

blog_III_1.jpg

  • In Replication Server 15.5 and later a module called Express Connect for Oracle is shipped with Replication Server, hence eliminating the need to have a separate process to communicate with the destination database. This is illustrated below:

blog_III_2.jpg

 

    Adding a destination Oracle database in a SAP Sybase Replication Server system is really simple with Replication Server version 15.5 and later, but adding a source Oracle database is more complex because we have to create, start and configure a new RAO instance.

Configuring Replication from ORACLE 11 to ASE 15.7 with Replication Server 15.7

    In the how-to-video below, I go through the steps for establishing a replication system replicating from Oracle 11 to ASE 15.7 using SAP Sybase Replication Server. The prerequisites are:

  • Oracle 11 instance running with a schema that will have primary tables.
  • ASE 15.7 instance running with a database that will contain replicate tables.
  • 2 users created in the Oracle instance, one will be used by RAO and the other one by ECO (in this case called maintenance user). Check RAO manuals (link below) for specific permissions for these users ❗

    Steps:

  1. Create the connection to the ASE database (rs_init)
  2. Create the connection to the Oracle database (manually with create connection command). Note that:
    • Oracle has to be configured for archiving or redo logs and supplemental logging of primary key and unique index data
    • Install Oracle instant client
    • Add Oracle instance to tnsnames.ora file
  3. Create the new RAO instance and start it:
    • Add the new instance to interfaces file
    • Create the instance with “administrator” utility
    • Before starting the RAO server, be sure that both Oracle and Sybase jdbc drivers are included in the CLASSPATH
  4. Configure new RAO parameters
  5. Check that RAO is able to connect to RSSD, primary database and Replication Server
  6. Initialize new RAO instance
  7. Mark tables at primary, resume instance and create replication definitions/subscriptions

  I hope this post helps anyone who wants to start using Oracle as a primary database in an SAP Sybase Replication Server system. More interesting discussions on the topic of heterogeneous replication will be featured in upcoming blog posts wherein I will also address the following questions:

  • How can we configure other primary data sources, for example MSSQL Server ?
  • Is Hana going to be certified with SAP Sybase Replication Server ?

More details in SAP Sybase documentation:

Other/Related Posts:

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Ravinder Reddy Vangala

    Hi Javier,

    Thanks for your posts on sybase replication server. I have few questions could you please help me

    1. I can’t find the document for the initial load.(Source Oracle database to sap hana database)

    2.if the replication goes out of sync what needs to be done?

    Thanks,

    Ravinder

    (0) 
    1. Javier Martin Post author

         Hi Ravinder,

         I suggest you to take a look at data materialization methods in SRS manuals, and more deeply check Direct Load Materialization:

      Direct Load Materializationhttp://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc36924.1571100/doc/html/bde1347936041063.html?resultof=%22%64%69%72%65%63%74%20%6c%6f%61%64%22%20

          Of course if replication does out of sync you will have to materialize data again and the process can be more or less complex depending on the what you have lost

         Cheers.

          Javier.

      (0) 

Leave a Reply