HOW TO REPLICATE ROWS FROM ORACLE DATABASE TO IQ SYBASE DATABASE - Part 1

Every now and again It is necessary to work with lots of heterogeneous systems and what’s more being able to replicate rows among them.

Today I’m going to look at how oracle database rows  can be replicated on IQ SyBASE database.

First of all it is necessary to recap all the components. Let’s get started, shall we ?

1)    Oracle Database
2)    SYBASE RAO Agent
3)    SYBASE RTL Server
4)    SYBASE IQ database.

Everyone knows Oracle database, so I’m going to look at the second point, the  SYBASE RAO Agent.

The Replication Agent (RAO Agent) is a Java-based application that requires a Java Runtime Environment (JRE), JDBC driver for Oracle database and it is necessary to install it on the Oracle Database Server Machine too.

Each Replication Agent Java program uses an embedded Replication Agent System Database (RASD) to manage its stuff, I’ve been writing on it lately and you can find some handy information about it in my previous blog. 

Let’s see how it works, shall we ?

Using a Log Transfer Language (LTL), RAO Agent reads the primary Oracle database transaction log (archived logs),  and  transfers log records for replicated table to the Replication Server (RTL) , then it converts  and forwards LTL log records to the remote site (SYBASE IQ Database). 

To be continued....