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

Before going ahead, now let’s look at the SYBASE RTL Server quickly , shall we ?

The Replication Server Real-Time Loading Edition (RTLE) is a special edition of SYBASE Replication Server features and includes components necessary to replicate to a Sybase IQ database from Adaptive Server (ASE) database  or Oracle to Sybase IQ.

It uses many asynchronous thread to communicate with and transfer data to and from the target and the source data server.

RTLE is made up of Replication Server and what’s more Replication Agent for Oracle dealt with before.

Now let’s look at SYBASE IQ database, shall we ?

SYBASE IQ database is  a column based database that has been built to hold large amount of data at a low cost and high availability environment. It stores data that you see as tables in columns of data rather than as rows data.

Doing so Sysbase IQ is extremely quick at searching and data retrieval on large amount of data.


Looking at the following web site you’ll find lots of handy stuff: 

http://infocenter.sybase.com/help/index.jsp

Now let’s get down to replicate Oracle data rows to IQ database , shall we ?

To make it clearer I’m going to explain only how carry out the replication process of an Oracle table to IQ table, without explain how to install or start for example the RAO Agent , RTL Server or IQ database too. 

By the way I’ll do so soon.

Replication process step by step :

1)    Create a table on Oracle database

CREATE TABLE TEST_REPLIC (campo1 VARCHAR2(100));
 
2)    Create the same table on IQ :

CREATE TABLE TEST_REPLIC (campo1 varchar(100) null)
 
3)    Create a replication definition on RTL Replication Server

create replication definition rep_ora_iq.TEST_REPLIC
with primary at ORACLE_DB.ORACLE_SID
with all tables named TEST_REPLIC
(campo1 varchar(100) null)
primary key(campo1)
replicate all columns
go



4)    Create a subscription definition on RTL Replication Server

create subscription sub_ora.TEST_REPLIC
for rep_ora_iq.TEST_REPLIC
with replicate at IQ_DB.IQ_DB
without materialization
go

5)    Mark the table on the RAO Instance Agent

pdb_setreptable TEST_REPLIC  ,mark,owner
go
   
pdb_setreptable TEST_REPLIC 
go

Name                  Marked  Enabled  Replicate                    Send Owner Shadow Table Shadow Row
--------------------- ------- -------- ---------------------------- ---------- ------------ ----------
TEST_REPLIC    marked  enabled  TEST_REPLIC      enabled    N/A          N/A

 
6)    Insert a row into Oracle and check if it has been replicated into IQ database.


I know it’s too simple and lots of other stuff has to be written but it’s only the beginning of our trip into SYBASE product.

See you in my next blog