Synchronization task example
To perform the insert operation where you can read data from a Microsoft SQL Server Source and can write data to the Microsoft SQL Server target.
Perform the following steps to create a synchronization task::
Note: You need to create a Microsoft SQL Server connection before configuring the synchronization task.
1In Data Integration, click New > Tasks.
2Select Synchronization Task, and click Create.
The Definition tab appears.
3Configure the following fields on the Definition tab:
Field | Description |
|---|
Task Name | Name of the synchronization task. |
Description | Description of the synchronization task. Maximum length is 255 characters. |
Task Operation | Select the task operation that you want to perform. |
4Click Next.
The Source tab appears.
5Configure the following fields on the Source tab:
Field | Description |
|---|
Connection | Select a Microsoft SQL Server connection you created. |
Source Type | Select the source type. By default, Single is selected. |
Source Object | Select the required object from the list. |
Display technical names instead of labels | Displays technical names instead of business names. |
Display source fields in alphabetical order | Displays source fields in alphabetical order. By default, fields appear in the order returned by the source system. |
6Click Next.
The Target tab appears.
7Configure the following fields on the Target tab:
Field | Description |
|---|
Connection | Name of the active target connection. |
Target Object | Name of target objects available in the connection. Select an existing object from the list or create a new object at the run time. |
Truncate Target | When you enable the Truncate Target option, the Secure Agent truncates table before writing data to target. Default is false. |
Enable Target Bulk Load | Uses Microsoft SQL Server bulk API to write data in bulk mode to Microsoft SQL Server. |
Display target fields in alphabetical order | Displays target fields in alphabetical order. By default, fields appear in the order returned by the target system. |
8Click Next.
The Data Filters tab appears.
9Select the filter object, filter field, and filter operator to create a data filter on the Data Filters page.
10Click Next.
The Field Mapping tab appears.
11Click Automatch on the Field Mapping tab to map source fields to target fields accordingly.
12Click Validate Mapping to validate the mapping.
13Click Next.
The Schedule tab appears where you can schedule the task for each requirement and save.
14Configure the advanced source properties on the Schedule tab.
15Click Save > Finish.
16Select the synchronization task from the Explore page and click Actions > Run.
In Monitor, you can monitor the status of the logs after you run the task.