Data Synchronization Task Example
You can create a Data Synchronization task to read data from a Microsoft SharePoint source and write data to the Microsoft SharePoint target.
Perform the following task to create a Data Synchronization task:
Note: You need to create a Microsoft SharePoint connection before you configure the Data Synchronization task.
1. Click Task Wizards > Data Synchronization.
The Data Synchronization Task Wizard appears.
2. Click New to create a Data Synchronization task.
The Definition tab appears.
3. Configure the following fields on the Definition tab:
Field | Description |
|---|
Task Name | Name of the Data Synchronization task. |
Description | Description of the Data Synchronization task. Maximum length is 255 characters. |
Task Operation | Select the task operation that you want to perform. |
4. Click Next.
The Source tab appears.
5. Specify the source Connection and Source Object to be used for the task.
6. Click Next.
The Target tab appears.
7. Select the target Connection and Target Object required for the task.
8. Click Next.
The Data Filters tab appears.
9. Select the filter object, filter field, and filter operator to create a data filter on the Data Filters page.
10. Click Next.
The Field Mapping tab appears.
11. Click Automatch on the Field Mapping tab to map source fields to target fields accordingly.
Note: When you select a Flat file as target connection, the Body/BodyLength fields need to be unmapped if you do not have to download any attachments. When you insert data in the document library object, you must specify the Name, Body, BodyLength, and ContentType fields.
- - When you select Source connection as Salesforce or any database and Target connection as Microsoft SharePoint, in the field mapping: Edit Body function and then add DEC_BASE64 expression to map the body. You need to ensure that “BodyLength” is mapped.
- - When you select Source connection as Microsoft SharePoint and Target connection as Salesforce or any database, in the field mapping: Edit Body function and then add ENC_BASE64 expression to map the body. You need to ensure that “BodyLength” is mapped.
- - To add or edit expression in Field Mapping, click fx.
12. Click Validate Mapping to validate the mapping.
13. Click Next.
The Schedule tab appears where you can schedule the task for each requirement and save.
14. Configure the advanced source properties on the Schedule tab.
15. Click Save and Run the task if you do not want to schedule the task.
After you run the task, the Monitor Log page appears where you can monitor the status of Data Synchronization tasks.