Oracle

Daffodil Replicator addresses the complexity of Oracle replication between Oracle server/client database and heterogeneous enterprise databases. With the advent of fast worldwide connectivity, Oracle professionals have recognized the benefits of distributing Oracle data. With the prevalence of heterogeneous database environments, many organizations require two-way replication between multi-vendor sources and targets. Replicator provides a simple solution that ensures the consistency of Oracle data across distributed platforms.

Daffodil Replicator allows bi-directional replication from Oracle database to SQL Server, DB2, Daffodil DB, PostgreSql and Derby. Its integration with different databases creates a stronger high-availability platform for e-business by providing a more efficient and intelligent method to move data around the enterprise. The Replicator file system technology maintains a record of incremental database changes and transfer only those file system blocks that have changed. This significantly reduces the amount of data that needs to be transferred.

Using Replicator, you can unite your Oracle enterprise database with other distributed relational databases into a cohesive and integrated database solution. It captures your data changes against Oracle database and propagates those changes to specified target database, keeping the two consistent. Being able to capture the data from the operational systems and to propagate it on a timed basis is another benefit of Replicator. Your business environment decides how often the data source needs to be refreshed: once a week or every five minutes.

Replicator offers full and differential refresh of data. Differential refresh setup enables Replicator to replicate only the database changes (insert, update, delete) from one system to another. In a full refresh setting, the whole database table will be replicated whenever there is a database change. Replicator provides flexible and efficient Oracle replication that can maximize the accessibility of Oracle data across any enterprise whether for business intelligence systems or distributed client/server applications.

Replicator can be used with Oracle database for the following:

Oracle replication for capturing Oracle database snapshots

Oracle replication for merging the Oracle data changes on target data sources

Oracle replication for mirroring the Oracle publisher data to target subscribers on synchronization call

Oracle replication for mirroring the Oracle subscriber data to target publisher on synchronization call

Oracle replication with pre-defined conflict resolution between publisher and subscriber

Mention below is the simple steps to configure Replicator with Oracle database (Publisher) and PostgreSQL (Subscriber).

Download the appropriate zip file
Extract the corresponding zip file to an appropriate folder
Make the following changes by editing setpath.bat (windows) or startup.sh (Linux) (both for Oracle and PostgreSQL)
Remove Rem from SET JAVA_HOME= and SET JDBC_CLASSPATH ="Replicator.jar"
Set JAVA_HOME. JAVA_HOME is the directory path where you have installed JRE/J2SDK
Example: SET JAVA_HOME=C:\j2sdk1.4.2
Set JDBC_CLASSPATH for Oracle, PostgreSQL and Replicator SET JDBC_CLASSPATH= C:\ classes12.jar ; pg80b1.308.jdbc3.jar ;Replicator.jar

Note: Directory path should not contain any blank spaces
Run PubServer.bat/PubServer.sh to start publication server (Oracle):
To start Publication Server on your system, run the file PubServer.bat or PubServer.sh for Linux) available under the installation directory of Daffodil Replicator and a dialog box appears Fill up the Data Source Information (Oracle) in the dialog box appeared
Driver - oracle.jdbc.driver.OracleDriver
URL - jdbc:oracle:thin:@:1521:(database name)
Password - Enter the password of the above specified user
System Name - Specify the name or network IP of the local machine
Server Port No. - Specify the port no. on which you wish to run Publication Server
Similarly, run SubServer.bat/SubServer.sh to start subscription server (PostgreSQL)

Listed below is the Driver and URL:
org.postgresql.Driver
jdbc:postgresql://:5432/(database name)