What is Daffodil Replicator (E)?

Daffodil Replicator (E) is a Java tool for data synchronization, data integration, data migration, and data backup between database servers. Daffodil Replicator works over standard JDBC driver and supports replication across heterogeneous databases. At present, it supports following databases: Microsoft SQL Server, Oracle, Daffodil DB, DB2, Derby, MySql, PostGreSql, Firebird.

Features


  • Bi-directional Data Synchronization ?? Daffodil Replicator supports bi-directional data synchronization. It allows you to synchronize all the datasources used in the replication process. It maintains data integrity by updating all the changes made at one end to another end and vice versa in the replication process.

  • Supports replication across heterogeneous database ?? Daffodil Replicator supports replication among different databases. For example, you can use one database as Daffodil DB and another as SQL Server in the same replication process.

  • Supports unlocking ?? Daffodil Replicator does not set any lock while retrieving and merging changes to the database.

  • Security ?? Daffodil Replicator enables you to replicate data in a secure environment using HTTPS (HTTP over SSL). To know more about security, please click here.

  • Conflict detection and resolution ?? Daffodil Replicator provides conflict detection and resolution functionalities that allow you to make changes in the same table stored at different locations. For example, Lets assume emp table is stored at Database A and Database B. An employee (named as James) address is changed. It is updated in Database A but not in Database B. Therefore, a conflict occurs between the emp table stored at Database A and Database B. In such a case of conflicts, Daffodil Replicator automatically manages consistency between the data based on the settings specified by the user at the time of creating job or subscription.

  • Partial Replication ?? Daffodil Replicator also allows you to replicate only a part of the database in place of replicating the whole database. For example, you can replicate some tables from a database selecting the table names. In addition, you can replicate some rows and columns from a database using filtering.

Frequently Asked Questions


1. What is Daffodil Replicator (E)?

2. How long does it take to install Daffodil Replicator (E)?

3. How much hard drive space does Daffodil Replicator (E) require?

4. What are the minimum and recommended configurations of Replicator and Replication DataSource?

5. Which Replicator and Replication DataSource platforms are supported by Daffodil Replicator (E)?

6. Does Daffodil Replicator (E) supports networked, Internet, and remote users?

7. Does Daffodil Replicator (E) contain wizards that help me in configuring a datasource?

1. What is Daffodil Replicator (E)?

Daffodil Replicator (E) is a Java tool for data synchronization, data integration, data migration, and data backup between various database servers. Daffodil Replicator supports following databases: Microsoft SQL Server, Oracle, Daffodil DB, DB2, Derby, MySql, PostGreSql, Firebird.

Daffodil Replicator can support any database that comes with JDBC connectivity. You can send the request for the support of any other database, which is currently not supported by Daffodil Replicator, through user forum .

2. How long does it take to install Daffodil Replicator (E)?

There is no need for separate installation of Daffodil Replicator. You need to download Daffodil Replicator. After downloading, include the driver jars (in which you want to perform replication) in the lib folder and start the . bat/.sh file.

3. What is the minimum hardware configuration for Daffodil Replicator (E)?

Processor - Celeron 700MHz

RAM - 128 MB

Hard Drive Space - For Replicator 8.14 MB and Replication DataSource 6.84 MB

4. Which platforms are supported by Daffodil Replicator (E)?

Daffodil Replicator (E) is a Java-based tool. Therefore, it is platform independent.

5. Does Daffodil Replicator (E) support networked, Internet, and remote users?

Yes, Daffodil Replicator (E) supports networked, Internet, and remote users.

6. Does Daffodil Replicator (E) contain wizards that help me in configuring a datasource?

Yes, you can refer the Getting Started Guide that includes wizards, which helps you in configuring a datasource.


What is Daffodil Replicator (OS)?

Daffodil Replicator (OS) is an open source Java tool for data integration, data migration and data protection in real time. Daffodil Replicator performs data replication based on the 'Publish and Subscribe' model (in client and server architecture). A publication is a collection of one or more tables required for data replication. A subscription is a copy of tables involved in publication on client side.

Replicator supports bi-directional data replication by either capturing a data source snapshot or synchronizing the changes. It monitors data changes in the tables involved and synchronizes all data changes made by the subscriber and the publisher on periodic basis or on-demand by the subscriber. While synchronizing with one or more target data source. Replicator uses pre-defined conflict resolution algorithms to resolve conflicts between publisher and subscriber. The publications and subscriptions are defined using GUI or APIs on existing database servers.


Features

  • Bi-directional Data Synchronization Replicator does not put any constraint on changing data in databases. Changes can be done to any/all databases involved in replication job and data integrity will be maintained.

  • Supports replication across heterogeneous database Replicator supports replication across any combination of supported databases. Data source on one end could be daffodil db and SQL Server could be on other end. In the same job different data sources could be used in any combination.

  • Conflict detector and resolution Daffodil Replicator offers very strong conflict detection and resolution functionalities that allow multiple users to send in changes from the workstations simultaneously, while ensuring the integrity of the data. "paste a link to conflict resolution document".

  • Partial data (Tables, Rows and column) Replication A user can ignore the columns that he does not want to replicate. Columns that do not allow insert, update and delete operations, create problem in data replication. Can ignore the tables he don't want to replicate or can also add filter to data source for replication of required filtered rows.

  • Large datatype support Replicator supports almost all data types of supported databases. It also supports BLOB and CLOB replication.


Frequently Asked Questions


1. What is Daffodil Replicator (OS)?

2. Where has Daffodil Replicator (OS) been made Open Source?

3. Where can I access the source of Daffodil Replicator (OS)?

4. How long does it take to install Daffodil Replicator (OS)?

5. How much hard drive space does Daffodil Replicator (OS) require?

6. What are the minimum and recommended client and server configurations?

7. What client and server platforms does Daffodil Replicator (OS) support?

1. What is Daffodil Replicator (OS)?

Daffodil Replicator (OS) is an Open Source Data Synchronization tool that provides the capability to synchronize multiple heterogeneous data sources - some of which may be residing on a remote network.

Daffodil database synchronization tool allows its users to develop Java Databases for applications that can replicate and synchronize data between distributed Java-enabled databases. Replicator integrates impeccably with all Daffodil database products as well as with selected third-party databases that provide JDBC drivers.

2. Where has Daffodil Replicator (OS) been made Open Source?

Daffodil Replicator (OS) has been made Open Source on SourceForge.net, the world's largest repository of Open Source projects.

3. Where can I access the source of Daffodil Replicator (OS)?

The source code of Daffodil Replicator (OS) is available here..

4. How long does it take to install Daffodil Replicator (OS)?

There is no need for separate installation just includes the replication files in your application

5. How much hard drive space does Daffodil Replicator (OS) require?

You need 628 KB (including documentation).

6. What are the minimum and recommended client and server configurations?

You require a minimum 32MB RAM on any platform. With regards to recommended configurations, this further depends on your database configuration.

7. What client and server platforms does Daffodil Replicator (OS) support?

Daffodil Replicator (OS) is Java-based, and hence is platform-independent.