You can create various types of jobs according to your requirement. Various types of jobs
are:
-
One to One Job: Create this job when you want to exchange data between two
databases.
-
Many to One Job: Create this job when you want to exchange data from different
database to one database.
-
One to Many Job: Create this job when you want to replicate data from a single
database to different database.
-
Many to One Job: Create this job when you want to interchange data from different
databases to different databases.
The steps to create a job:
- Select
Job
Add Job in the
Replicator window to display various options that allow you to create different
types of jobs, as shown in the following figure:
-
Adding Job |
-
Select an option from the
Add Job menu based on your requirement. If you select the
One To One option,
OneToOne Job dialog box appears as shown in the following figure:
-
One To One Job |
-
If you select the
One To Many option,
OneToMany Job dialog box appears as shown in the following figure:
-
One To Many Job |
-
If you select the
Many To One option,
ManyToOne Job dialog box appears as shown in the following figure:
-
Many To One Job |
-
If you select the
Many To Many job,
ManyToMany Job dialog box appears as shown in the following figure:
-
Many To Many Job |
Note: In case of Unidirectional, you can't select
Target as
Winner.
Different data fields in OneToOne, OneToMany, ManyToOne, ManyToMany dialog boxes are:
-
Job Name – Enter the name of the job to identify the job that you want to
create.
-
Bidirectional – Select this check box to create a bidirectional job. On selecting
Bidirectional, Daffodil Replicator allows you to replicate data from source to
target and vice versa.
-
Winner – Select the radio button to specify the datasource from which you want to
replicate data in case of conflict resolution. For example, if you select
Source as
Winner, then in case of conflict resolution the changes made in the source is
applied to the target and the changes made by the target is lost.
-
DataSource – Select
Source DataSource and
Target DataSource name from the combo box in the OneToOne dialog box. In case of OneToMany, ManyToOne, ManyToMany dialog box, click on
button to add the datasource. DataSource dialog box appears:
-
DataSource |
-
Create Schema – Check this check box if you want to create structures of database
tables in target according to the structures of database tables in source.
-
Populate Existing Data – Check this check box to specify that the existing data of
target also takes place in the replication process.
Note: In case of One to One job, Create Schema and Populate Existing Data data fields appear on the OneToOne dialog box. In case of One to Many, Many to One, Many to Many
jobs, these data fields appear on the DataSource dialog box.
- After selecting the source and target datasource names, you can perform filtering. To
perform Filtering, click the filtering buttons, such as Row Level Filtering or Column Level Filtering, on any
Job dialog box. To know how to perform filtering, click
Filtering.
- After Filtering, click the
OK button to add the job.
