Create a Replication Task

Tasks orchestrate data synchronization between the source and target.

To create a replication task, follow these steps:

1. Go to Data Hub > Replication Tasks and select the relevant environment (if applicable).
2. Select New Task in the top-right corner.
3. On the Config tab, provide the basic details:

   Field	Description
   Task Name	Enter a descriptive name. For example, Infor Production Sync.
   Connection	Select a configured connection from the dropdown. Only connections you have already set up in Data Hub appear here.
   Description	Enter a brief description for this task.

4. Select Next.
5. On the Items tab, choose the data you want to replicate. Select Add Item.
6. In the Select Items to Replicate pop-up, find and select the tables you want to replicate:
   • Use the search box to filter by name.
   • Select Add Selected Tables. The selected items appear on the main screen.
7. (Optional) To configure a table further, select the Edit Item icon next to it. The following tabs are available: General, Fields, and Advanced.

   On the General tab, configure the following:

   Field	Description
   Target Table Name	The name of the table in the target database. This is pre-populated from the source table name and can be edited.
   Replication Type	Full Replication: Copies all data on every sync. Incremental Replication: Syncs only new or changed data since the last run.

   On the Fields tab, select which columns to include in the replication. Use Search Columns to filter by name, or narrow the list to selected, unselected, or fields with errors. Select Select All to include all visible columns. Drag and drop fields to reorder them, select individual fields as needed, and enter an alias directly in the list. An alias is an alternative name for the column in the target table, which defaults to the source column name.

   On the Advanced tab, configure how deletions are handled and define filter conditions for replication.

   Option	Description
   Disable Advance Delete	Skips delete operations during the sync. When enabled, the Partial Delete option is unavailable.
   Partial Delete	Sets the maximum number of days to search for deleted records. When enabled, a Set Days field appears to configure the lookback period. For example, 30 days.
   Filter - Rebuild	Define field-based conditions to specify which records are included in a full rebuild. Only records that meet the conditions are replicated.
   Filter - Incremental	Define field-based conditions to specify which records are included in incremental runs. Enable Apply Full Load Filter to apply the same filter conditions to incremental runs as the full rebuild.

   Select Save Configuration when done.

8. Select Next.
9. (Optional) On the Post Command tab, enter SQL statements that run after a successful replication. Select Add Post-command and enter the SQL to execute. Select Format SQL to automatically format your statement for readability. Use the Show dropdown to select which version of the SQL statement to run if you have added multiple versions.
   • Commands run only after a full task completes, not after incremental updates.
   • End each statement with a semicolon (;).
   • Use IF NOT EXISTS when creating objects to prevent errors on subsequent runs.
   • Commands execute against the replication endpoint.
10. Select Next.
11. On the Schedule tab, configure when the task runs automatically. Enable Schedule Configuration and select a Frequency:

    Frequency	Dependent Fields
    Hourly	Starting Daily at: Set the time the schedule begins. Time is in 24-hour format, for example 09:00. Repeating Every: Set the interval in hours. For example, if Starting Daily at is 09:00 and Repeating Every is 3, the task runs at 9:00 AM, 12:00 PM, 3:00 PM, and so on.
    Weekly	Starting on the day(s) at: Set the time the task runs. Days of Week: Select which days of the week the task runs.

    To exclude specific time windows from the schedule, select Add Exclusion Window and set the From and To times. Once configured, review the Next jobs list to confirm the upcoming scheduled runs.

    Note:

    • If Data Hub is offline during a scheduled run, that execution is skipped and not retried.
    • If multiple tasks are scheduled at the same time, they are queued and run in sequence.
12. Review the task summary to confirm your configuration.
13. Select Create Task. Data Hub validates the table configurations and adds the task to the Tasks list.

You can run the task manually at any time from the Tasks list, even before its scheduled time. See Run Replication Tasks for details.